Chinook Data Analysis

Chinook Data Analysis Project

The Chinook Project is a data analysis case study using the Chinook database, a sample database that simulates a digital media store. The database includes tables for customers, invoices, employees, artists, albums, tracks, and genres.

Objective

To explore and analyze sales and customer data.

To answer key business questions about revenue, customer behavior, and music trends.

Tools & Skills Used

SQL: wrote queries to extract insights (joins, aggregations, filtering, subqueries).

Power BI / Tableau: built dashboards to visualize sales by country, top customers, and most profitable genres.

Excel: used pivot tables for quick summaries and ad-hoc analysis.

Python (optional if you used it): for advanced data cleaning or visualization with Pandas/Matplotlib.

Key Insights

Identified top-selling genres and artists that drive most of the revenue.

Discovered countries with highest sales and which customer segments contribute the most.

Highlighted employee performance based on customer support and sales distribution.

Created a dashboard that helps stakeholders track KPIs like revenue by region, top customers, and monthly sales trends.

Outcome

Delivered clear business recommendations on where to focus marketing and sales.

Demonstrated strong skills in data extraction, analysis, visualization, and storytelling.

Showed ability to translate raw data into actionable insights for decision-making.