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.
![schema_diagram](https://private-user-images.githubusercontent.com/120908587/239757395-3a5ee892-1b55-4693-836e-4843487653c3.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjYxNTcxNjYsIm5iZiI6MTcyNjE1Njg2NiwicGF0aCI6Ii8xMjA5MDg1ODcvMjM5NzU3Mzk1LTNhNWVlODkyLTFiNTUtNDY5My04MzZlLTQ4NDM0ODc2NTNjMy5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwOTEyJTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDkxMlQxNjAxMDZaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1jM2RhMDdhYjc2ZjhmZWE3OWUyZjQ2YmYyMTRhNGY4ZDliMmYzNzUzOGY2MzBhOTdjOTFlNmQ0NzE3ZDRlNzk5JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.t3VxAqRYg3qctiRgqKv_XlhqhfQHhztNZ4lpEQUpJP0)
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
By leveraging the power of SQL and data analysis techniques, your project aims to provide the music store with valuable insights and actionable recommendations to enhance its business operations, drive sales growth, and improve overall customer satisfaction.
Good luck with your project!