Welcome to our music store data analysis project conducted using SQL! Our exploration delves into an extensive dataset comprising 11 tables, including Employee, Customer, Invoice, InvoiceLine, Track, MediaType, Genre, Album, Artist, PlaylistTrack, and Playlist.
Through the application of SQL queries, this project aims to unravel valuable insights and answer numerous critical questions about our music store's operations. By diving deep into the dataset, we aspire to gain profound understanding and enhance decision-making processes within the realm of our music retail venture. Join us in this data-driven exploration!
- SQL Server
- SQL Workbench
- Schema: Music Store Database
- Clone the repository: https://github.com/madhumitagupt/Music-Store-Data-Analysis-Using-SQL.git
- Import the dataset into your SQL database management system.
- Run SQL queries located in the SQL_Music_Store_Project.sql file against the database to perform data analysis and generate insights.
Contributions to this project are welcome. If you have suggestions for improvements or find any issues, feel free to open a pull request or submit an issue in the repository.