Chinook_SQL_Data_Analysis

Music store Exploratory Data Analysis Using SQL

1- Project Overview:

The Chinook is a Fake Database, holds information about a music store.
Download the Database

2- Task:

Using sqlite answer four questions about the database and then plot results via any tool (Excel, Matplotlib or Tableau) and communicate results via report.

3- Files:

1. ERD.png:

• Database Entity Relationship Diagram.

2. Report.pdf

• Findings & Communication Report.

3. chinook.db

• Chinook Music Store Database.

4. query_1.sql

• SQLite query to answer the first EDA question.

5. query_2.sql

• SQLite query to answer the second EDA question.

6. query_3.sql

• SQLite query to answer the third EDA question.

7. query_4.sql

• SQLite query to answer the fourth EDA question.

4- Database Describtion:

4.1. Tables:

• Invoice:
  • Total Customer Invoice.
• InvoiceLine:
  • Unit price per track.
• Customer:
  • Customer data.
• Employee:
  • Employee data.
• Album:
  • Track containing album.
• Artist.
• Track.
• Genre.
• MediaType.
• PlaylistTrack.
• Playlist.

4.2. Entity Relationship Diagram:

• View/ Download Database ERD

5- Questions for Exploratory Data Analysis:

1. Who are the Top 10 Selling Composers?
2. In the Top Revenue Driving Country, who are the Top 5 Selling Artists?
3. What is the Proportion of Sold Tracks for Each Media Type?
4. In How Many Countries was Each Genre the Top Selling Genre?

6- Queries:

1. Who are the Top 10 Selling Composers?
2. In the Top Revenue Driving Country, who are the Top 5 Selling Artists?
3. What is the Proportion of Sold Tracks for Each Media Type?
4. In How Many Countries was Each Genre the Top Selling Genre?

7- Explanatory Data Analysis:

• A pdf report was implemented to communicate findings & results from previuos queries.
• View/ Download Report

8- Run Locally:

• Download files from Code > Download ZIP.
• Import chinook.db into SQLite db browser or any SQLite database manager.
• Run each query separateley.