We partnered with an Australian agency to develop a custom data panel and analytics integration solution. The project aimed to centralize and visualize data from multiple streaming services, such as Shopify and Apple Music, into a minimalist dashboard. The solution allowed users to easily access relevant data on playlists, songs, and artists while avoiding unnecessary complexity.
Before Implementation
The challenge of combining data from multiple platforms, which required effective integration strategies.
The need for a user-friendly and customizable dashboard that could handle specific data.
Ensuring data accuracy and consistency while transforming and centralizing it for streamlined analysis.
Key Improvements
Centralized data storage using Google Sheets and BigQuery, creating a unified view of analytics.
Developed a customizable dashboard through Looker Studio to meet the specific needs of different stakeholders.
Optimized data flow and transformation processes, enabling easy access to essential metrics with minimal effort.
Project Overview
1.
Data Integration
We integrated data from streaming platforms (Shopify, Apple Music) into Google Sheets and BigQuery.
2.
Data Transformation
Utilizing BigQuery, we built data marts to organize and optimize data for analysis.
3.
Dashboard Design
A minimalist, customizable dashboard was created in Looker Studio to visualize key data points for playlists, songs, and artists.
4.
Iterative Feedback
Through continuous communication with the agency, we refined the dashboard to ensure it met client needs and offered easy-to-interpret insights.
Shopify
Google Sheets
BigQuery
Looker
Technologies used
Sophie Johnson
CEO - This Before That
"The team worked closely with us to design a solution that truly fit our needs. The result has been a streamlined process for analyzing data across multiple services, with a dashboard that’s easy to customize and use."
