The Digital Music Store sells a wide variety of music, including albums, tracks, and playlists. It also allows customers to create their own playlists. The store has a large number of employees, who work at multiple locations in Canada. The store also has a large number of customers world-wide, who make regular purchases.
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.
The Data is available at 11 csv tables :-
– Artist
– Invoice
– Playlist
– Employee
– Album
– Invoice Line
– Playlist Track
– Customer
– Track
– Media Type
– Genre
a) The USA is the dominant market, with over 1,051 purchases, nearly double that of the next country, Canada (541). This establishes it as the primary driver of global music sales.
b) The top 10 list is heavily dominated by North American (USA, Canada) and European nations (France, Germany, Czech Republic, UK, Portugal, Ireland), indicating these regions have the highest customer engagement.
c) Significant markets emerge from South America, with Brazil (432) and Argentina (40) making the list, highlighting a strong regional presence.
d) The data reveals strong engagement from English-speaking countries (USA, Canada, UK, Ireland, Australia) and major European economies, suggesting a correlation between market size, language, and purchase volume.
e) The presence of the Czech Republic (276) and Portugal (187) in the top 10, ahead of larger economies like Australia, points to unexpectedly high per-capita music consumption in these regions.
● The USA is the most popular country for music purchases with 1051 purchases followed by Canada and Brazil with 541 and 432 purchases respectively.
● Rock music is the top selling genre with $3664.98 spent and Reggae is the lowest selling genre.
● AC/DC is the top selling artist.
● Prague has the highest sales volume.