📊 Chinook Data Warehouse & KPI Analytics Project

📌 Project Overview

This project demonstrates the design and implementation of a complete data warehousing and analytics solution using the Chinook Database.

The objective was to transform raw transactional data into a structured Data Warehouse and extract meaningful business KPIs using Power BI.

🎯 Business Problem

The goal of this project was to extract analytical insights from operational data

Design a scalable Data Warehouse

Build automated KPI reporting

Enable business decision-making through dashboards

🏗 Architecture

🧱 Data Warehouse Design

The solution includes:

Staging tables for raw data

Fact tables (Sales)

Dimension tables (Customer, Artist, Album, Date, etc.)

Star schema modeling

SQL-based ETL transformations

⚙️ ETL Process

Data extracted from source database

Loaded into staging layer

Cleaned and transformed

Loaded into dimensional Data Warehouse

Connected to Power BI for reporting

📊 KPIs Extracted

Total Revenue

Revenue by Country

Monthly Sales Trend

Top-Selling Artists

Customer Lifetime Value

Sales per Genre

📈 Business Value

This system demonstrates how companies can:

Convert raw data into actionable insights

Automate reporting

Track performance metrics in real-time

Support strategic decision-making

🛠 Technologies Used

SQL

Data Warehousing (Star Schema)

Power BI

📸 Dashboard Preview