Complete Data Analytics Project in Excel | Data Cleaning to Dashboard

In this video, we walk through a complete end-to-end data analytics project using Microsoft Excel. This project demonstrates the core workflow that many analysts follow in real business environments: cleaning data, normalizing tables, and building a clear dashboard to communicate insights. If you're learning data analytics, projects like this help you move beyond theory and start developing practical analysis skills. Tools used in this video include features within Excel such as Power Query, Power Pivot, and Pivot Charts. Link to Kaggle Dataset (you need to create an account for downloads) https://www.kaggle.com/datasets/vivek468/superstore-dataset-final Date Table in Power Query - M Code https://drive.google.com/file/d/1ToWWR1hglQI_XyNYKR0MMPhnd-RuhZQw/view?usp=drive_link Timeline 0:00 Introduction: What you will learn in this video 1:34 Getting Data from Kaggle 3:47 Start Power Query 6:00 Power Query Interface 6:47 Dataset Normalization 17:14 Date Table in Power Query 20:30 Load Data into Excel Data Model 21:48 Start Power Pivot and Create Relationships 23:39 Creating Measures in Power Pivot 28:43 Card Visuals in Microsoft Excel 36:09 Creating Measures from the Fields Pane 38:42 Quarterly Sales Trend 40:45 Year over year growth 42:36 Sales & Profit per Region 44:43 Sales and Profit Tables by Product Sub-Category 46:33 KPI in Power Pivot 49:01 Top N Filter in Pivot Tables 53:47 Insert Timeline and Slicers 55:49 Snap Objects to Grid and resize 58:08 Hide white space 58:34 Formatting Charts in Microsoft Excel 59:16 One more Measure, Profit per Unit 01:03:40 Adding Chart Titles in Microsoft Excel 01:04:05 Final Sales Performance Dashboard in Microsoft Excel