Executing Data Modeling for Enhanced Flexibility, Productivity, and Decision-Making – Ávoris

Before:

SQL Barrier for End-Users, Lack of Actionable Insights

Ávoris has a long history of mergers that have brought about multiple sources, tools and applications. Following unprecedented changes in the tourism sector caused by the pandemic, and a merger with Globalia, Ávoris felt the need to transform from within.

Solution:

Google BigQuery & Looker to Improve Modeling Data

Looker would enable both the BI team and e-commerce department to gain autonomy, harness operational insights, and improve decision-making.

Greater flexibility of inputs & outputs, enhanced productivity and decision making were all valuable aspects at the time of choosing Looker. But the deciding factor was ease of modeling data – that is, converting raw data into curated information that addresses the user’s questions with a simple drag-and-drop. This allowed the team to eliminate the barrier of SQL for end users who can now quickly obtain actionable insights.

Spaulding Ridge conducted a 6-months long trial focused on BigQuery and Looker, during which time we worked on complex use cases to equip the BI and E-commerce teams with all the necessary tools to grant their self-service analytics objective.