In this video, we dive into a two-year dataset of Florida retail shops to uncover how weather, location, and customer demographics shape sales performance.
1:16 Analysis Approach
3:30 How to Download MYSQL
9:02 Create Database
11:11 Building SQL View
29:10 Connect Power BI and MySQL with ODBC connector
36:21 Dashboard Question and Planning Visuals
40:44 Dashboard Build
1:20:07 Analysis Recommendations
You’ll learn:
How hot days boost sales while rainy days bring them down
Which shop outperforms the rest (and why Miami peaks in summer)
How families vs. singles shop differently across weekends and weekdays
Clear seasonal patterns and what they mean for planning
Practical strategies managers can use: staffing, promotions, and inventory decisions
We’ll use MySQL and Power BI to join datasets, run analysis, and visualize patterns.
To Download the Datasets
https://github.com/Gaelim/youtube/blob/master/Miami%20Shops.zip
To Download Power BI
https://www.microsoft.com/en-us/power-platform/products/power-bi/downloads
To Download MYSQL
https://dev.mysql.com/downloads/file/?id=544576
To Download The MYSQL Connector
https://dev.mysql.com/downloads/connector/odbc/
コメント