We have a music store that sells various music albums, tracks, and merchandise. The store operates both online and offline, serving customers worldwide.

This project demonstrates data analysis skills and visualization for Music Store using SQL Server and PowerBI.

Music store is losing its revenue and customers.

The management wants to fix this issue, the managing director wanted to incorporate “Business and Data Intelligence” to regain their market and revenue.

The goal is to analyze the available data and provide insights that can help the music store improve its business operations, optimize sales, and enhance customer experience.

The music store has a comprehensive database that contains information about albums, artists, playlist_track ,track , customers, employee , genre , invoice_line ,invoice ,media_type ,playlist . The database captures details such as album titles, track durations, artist names, genres, customer demographics, order dates, transaction amounts, and more.

Here is the Metadata used in the Project - https://github.com/saksham-mishra24/Revenue-Insights_Azure-data-Factory/tree/main/Metadata

Here is the dataset used in the video - https://github.com/saksham-mishra24/Revenue-Insights_Azure-data-Factory/tree/main/RawData

Good luck with your project!