Portfolio / This Before That
Data Analytics - Music App
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
- 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.
How we did it
Data Integration
We integrated data from streaming platforms (Shopify, Apple Music) into Google Sheets and BigQuery.
Data Transformation
Utilizing BigQuery, we built data marts to organize and optimize data for analysis.
Dashboard Design
A minimalist, customizable dashboard was created in Looker Studio to visualize key data points for playlists, songs, and artists.
Iterative Feedback
Through continuous communication with the agency, we refined the dashboard to ensure it met client needs and offered easy-to-interpret insights.
“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.”Sophie Johnson · CEO - This Before That
Jamplus · E-commerce · US
StartSteps · Digital Education · Germany
Meshads · Marketing · Estonia