Skip to content
Branch: master
Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
..
Failed to load latest commit information.
.ipynb_checkpoints
Comparison.png
README.md
chinook-schema.svg
chinook.db
main.ipynb

README.md

Answering Business Questions

In this mini-project, we'll be working with a modified version of a database called Chinook. The Chinook database contains information about a fictional digital music shop - kind of like a mini-iTunes store. It contains information about the artists, songs, and albums from the music shop, as well as information on the shop's employees, customers, and the customers purchases.

We'll provide solutions to few Business Questions by analysing data from Chinook Database.

Github Repo | Notebook Preview (nbviewer)


Following Packages and Concepts are explored:

  • Pandas - DataFrame (Consolidating Data)
  • Matplotlib - Visualisation
  • SQLite3 - Database
  • SQL - SELECT, FROM, WITH _ AS, CASE, WHEN, THEN, EXCEPT, THEN, JOIN, COUNT, CAST, GROUP BY, LIMIT

Visualisation depicting Sales Comparison

You can’t perform that action at this time.