This project involves developing a STAR schema to load the Million song dataset which is available in a JSON format into 5 different tables (songplays, artists, songs, users, time) using Python create ...

This github repository consists of the following file: ETL.py - This is the main code where the data is extracted, transformed and loaded into MySQL DB. Dimensional Modelling.xlsx - This is the file ...