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/Case-Study
Watch video Data Analysis Case Study | Product Recommendation | Fortune 100 Company online without registration, duration hours minute second in high quality. This video was added by user Absent Data 26 March 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,626 once and liked it 230 people.