Amr Mousa
Back to Projects View GitHub Code
Data Analytics

Chinook Music Store Analysis

SQLPostgreSQLData AnalysisData QualityStatisticsBusiness IntelligenceAnalyticsChinook Database

The Problem

Relational databases contain interconnected entities and business data that can be difficult to understand and analyze without first validating the underlying structure, data quality, and business logic.

The Solution & Value

This project follows a structured analytical workflow that starts with understanding the Chinook database schema, validates data quality and business logic, applies statistical and outlier analysis, and then transforms the findings into business-oriented insights and recommendations using SQL.

Sales Funnel Impact

Demonstrates the complete analytical workflow of a Data Analyst, from database profiling and data validation to statistical analysis, business analysis, and actionable recommendations using a real-world relational database.

Chinook SQL Analysis
Rendering Document Pages...

Note: If the Microsoft Power BI service is blocked on your network, use the media tabs above.

Contact WhatsApp