This project analyzes data from the Chinook Digital Music Store to uncover key business insights and identify opportunities for growth. Using MySQL for data extraction and Tableau for visualization, the project explores customer trends, sales performance, and artist popularity.
The analysis focuses on answering several key business questions, such as:
- Which genres generate the highest sales?
- Who are the top-selling artists?
- Which countries have the most customers and total revenue?
- What is the average invoice value across regions?
- How do sales vary by country and genre?
The project began by connecting to the Chinook database, a sample dataset representing a digital music store. It contains information about customers, invoices, tracks, albums, and artists.
- Data Extraction:
Data was retrieved from the MySQL Chinook database using SQL queries. - Data Cleaning & Preparation:
Irrelevant records were filtered out to ensure accuracy. - Exploratory Data Analysis (EDA):
SQL queries were used to analyze patterns, trends, and relationships in the data. - Data Visualization:
Insights were visualized using Tableau to create an interactive dashboard that tells a clear story.
This process helped transform raw data into meaningful insights for better business decision-making.
| Tool | Purpose |
|---|---|
| MySQL | Data extraction, cleaning, and transformation |
| SQL | Writing analytical queries to explore sales, customers, and artists |
| Tableau | Interactive dashboard creation and visual storytelling |
| Excel | Quick summaries |
- The total revenue generated across all markets is heavily concentrated in North America, particularly the United States.
- The USA alone accounts for over 50% of total sales, highlighting its role as the store’s primary market.
- Countries like Canada, France, and Brazil also show steady performance, indicating potential secondary markets.
- Monthly revenue trends show spikes around specific months, possibly tied to holiday seasons or music releases.
💡 Recommendation:
- Focus marketing campaigns and artist promotions around high-performing months to maximize seasonal trends.
- Consider expanding targeted digital ads and playlists to Europe and South America, where moderate growth potential exists.
- Rock and Alternative & Punk are the most purchased genres, driving the majority of total revenue.
- Latin, Jazz, and Classical have much smaller market shares, indicating niche but loyal audiences.
- Genre preferences vary by region — for example, Latin music performs better in South American markets.
💡 Recommendation:
- Strengthen partnerships with Rock and Alternative artists through exclusive deals or featured content.
- Promote region-specific genres (e.g., Latin music in Brazil, Jazz in France) to boost local engagement.
- Introduce curated playlists or bundled offers (e.g., “Top Rock Albums of the Year”) to drive multi-purchase behavior.
- The top 10 customers account for a significant portion of total revenue, suggesting a strong repeat purchase behavior.
- However, a large percentage of customers only made one-time purchases, signaling limited retention.
- Average Order Value (AOV) remains moderate, meaning customers buy a few tracks or albums per transaction rather than large bundles.
💡 Recommendation:
- Introduce a loyalty or membership program that rewards repeat purchases.
- Offer personalized recommendations or discounts based on listening history to encourage upselling.
- Implement email marketing targeting one-time buyers with offers on similar artists or genres.
- The Top Artist by Revenue contributes significantly to total sales, indicating high listener loyalty.
- Tracks from a small group of artists dominate purchases, while many others see minimal sales.
- There’s evidence of underperforming artists within popular genres — possibly due to low visibility or poor placement in playlists.
💡 Recommendation:
- Highlight top-performing artists in featured playlists and marketing campaigns to boost overall engagement.
- For underperforming artists, analyze streaming/purchase data to identify low visibility vs. low interest, and adjust promotion strategy accordingly.
- Consider collaboration campaigns between popular and emerging artists to expand audience reach.
- Revenue distribution shows that digital tracks make up the majority of sales, while albums contribute less but have higher margins.
- Cross-selling opportunities exist between tracks and albums, as customers who buy one track from an artist are likely to buy more.
💡 Recommendation:
- Encourage customers to purchase full albums by offering discounts after buying multiple tracks.
- Introduce bundled offers like “Buy 3 Get 1 Free” or genre-themed bundles to increase total order size.
- Continuously monitor invoice trends to identify the best-performing price points and optimize accordingly.
- Invest in data-driven personalization to increase retention and revenue.
- Use insights from MySQL and Tableau dashboards to monitor monthly sales and adjust promotions dynamically.
- Expand into emerging markets while sustaining focus on North America, where brand loyalty is already strong.
- Leverage Tableau dashboards for quarterly reviews to track progress against sales goals and customer engagement KPIs.
The Chinook analysis reveals that a small group of loyal customers and top-performing artists drive most of the revenue, and that Rock and Alternative genres dominate sales.
However, with better customer retention programs, targeted marketing, and regional personalization, the Chinook store can expand its footprint and significantly increase its long-term profitability.
- Download and install a SQL database (MySQL).
- Import the
Chinook_MySql.sqlscript into your database. - Run the queries provided in the
queries/folder. - Explore the generated visualizations inside the
Tableau dashboard/folder.