Business Intelligence
Enhancing marketing decision-making through Looker
Discover how Astrafy migrated Spock from Qlik to Looker, built a tailored BI data strategy, delivered custom dashboards, and trained their team for a seamless handover.
Spock is a Spanish startup founded in 2022 that organizes collective purchases of electricity and gas for small consumers, aiming to secure more competitive rates and reduce energy bills. By aggregating thousands of users, Spock negotiates with energy suppliers as a large consumer, enabling participants to access better prices.
The challenge
Moving beyond Qlik for simpler, self-serve analytics
Spock wanted to migrate their daily analytics and dashboard tool, Qlik, to increase data-driven decision making by enhancing simplicity and self-serve analytics. Their goal was to use a tool better suited to their GCP structure, with faster, more intuitive functionality tailored to the daily analytics needs of business users to assure company-wide adoption.
The solution
Migrating dashboards to Looker and training the team
Astrafy led the migration of Qlik dashboards to Looker, covering customer profiling, Google Ads, and Google Analytics dashboards, as well as a customer lifetime value report. We bootstrapped Looker, collaborated closely with each business owner to thoroughly define analytical needs and design customized dashboards. Lastly, we trained their team on Looker to empower their team to use it.
Results
Doubled adoption and lower BigQuery costs
Spock duplicated user adoption from Qlik to Looker after the migration, enabling their team to access the already-made reports and perform self-serve analytics to satisfy their team's needs without technical expertise. Besides, the cost was reduced from BigQuery thanks to the optimizations performed on the ingestion and partitioning of tables, saving up to 65% on daily BigQuery costs.
Latest case studies
