This repository contains SQL-based demand modelling and consumer analytics for a music retail business. It analyses transactional data to identify demand patterns across genres, geographies, and customer segments. Power BI is used for interactive KPI visualisation.
From the README
MUSIC RETAIL DEMAND MODELLING USING SQL AND POWER BI Project Overview Analysed transactional data from a music retail business to surface demand patterns across genres, geographies and customer segments. SQL was used for querying and aggregation; Power BI for interactive KPI visualisation. Tools Used SQL (MySQL) Excel Power BI Dataset An 11-table relational dataset covering customers, invoices, tracks, albums, artists, genres, employees and playlists. Full schema diagram included in repo. Key Analysis • Genre-based demand trends • Customer purchasing behaviour • Sales performance KPIs Key Findings • Top 5 revenue countries identified, with the USA accounting for the largest share of...
