This is a full case study where you will be doing a full end to end data analysis using Excel, Power Query and Power BI. The problem statement asks us to create an analysis to discover what product mix should be recommended for the new stores. #datanalysis #excel #powerbi
0:59 Case Study Breakdown
4:27 Data Exploration
8:20 Cleaning Data with Power Query
12:43 Create columns
19:10 Grouping Data
25:02 Creating Product Mix Proportions
28:54 Unpivoting/Melting Data
30:56 Visualizing Data in Excel
37:20 Correlations
38:29 Loading Data in Power BI
39:51 Shape Map
44:20 Dashboard Build
54:20 Building DIM tables
59:05 Dynamic Narrative
1:03:00 Recommendations and Summary
Get the data here:
https://github.com/Gaelim/CaseStudy