Uploaded November 2025 | Updated November 2026, 3 days ago
๐ฅ $50 OFF My Dashboards Course (code: SAVE50) ๐ chandoo.org/wp/excel-school-program
~
Become an Excel Dashboard PRO with this hands-on tutorial. Learn how to think like a business analyst, create KPIs, set up calculations, use pivot tables, slicers and build interactive charts + maps to create this dynamic business dashboard in just 30 minutes.
This is the perfect end to end Excel project for a data analyst.
โญ What you will learn:
1) How to set up the data for your dashboard in Excel?
2) What KPIs and business questions to address with the dashboard?
3) How to use Pivot Tables to build the "calculation engine" for your Excel dashboard
4) Storytelling with "summary" & "detail" approach
5) Building dashboard canvas with shapes and formatting in Excel
6) Creating various kinds of charts with Excel
7) Formatting charts so they look professional and slick!
8) Setting up Map Charts in Excel
9) Using Picture Links to create grids in dashboard
10) Interactive dashboards with slicers
11) Dashboard theming with Page Layout options
12) Storytelling with strong & insightful titles for your charts
๐ Topic-wise timestamps:
0:00 - Master Excel Dashboards in 26 Minutes (intro)
1:36 - Data for our dashboard
2:34 - KPIs and business questions for our dashboard
3:32 - Analysing data with Excel - Formulas vs. Pivots
4:00 - Calculated columns in our data
4:42 - Creating Pivot Tables for our dashboard
5:55 - Display format for the pivot values
6:18 - Dashboard Sheet Setup
8:24 - Building the Dashboard Side-panel (for summaries)
10:46 - 13 Week Sales Trend Graph
12:15 - Purchase Patterns Grid Chart (Picture Links)
14:49 - Quantity Distribution Chart (Pivot Grouping!)
16:23 - Most Popular Products Chart
18:02 - Map chart to see Geographic Trends
20:02 - Days to Delivery Chart
20:20 - Customer Satisfaction Chart
21:46 - Slicers for Dashboard Interactions!
26:18 - Adding Chart Titles
27:01 - Dashboard Theming (colors) with Page Layout options
28:44 - Closing Remarks (where to go from here)
๐ Download Sample Data:
Grab the sample file from here and build your own dashboard: chandoo.org/wp/wp-content/uploads/2025/11/ecommerce-blank.xlsx
๐งโ๐ป Learn more
Join my Excel School program and learn how to build world-class dashboards with Microsoft Excel. Use the coupon code SAVE50 to get $50 discount on the course.
Visit chandoo.org/wp/excel-school-program to enrol.
~
#excel #exceldashboard #dashboard
๐ฅ $50 OFF My Dashboards Course (code: SAVE50) ๐ chandoo.org/wp/excel-school-program
~
Become an Excel Dashboard PRO with this hands-on tutorial. Learn how to think like a business analyst, create KPIs, set up calculations, use pivot tables, slicers and build interactive charts + maps to create this dynamic business dashboard in just 30 minutes.
This is the perfect end to end Excel project for a data analyst.
โญ What you will learn:
1) How to set up the data for your dashboard in Excel?
2) What KPIs and business questions to address with the dashboard?
3) How to use Pivot Tables to build the "calculation engine" for your Excel dashboard
4) Storytelling with "summary" & "detail" approach
5) Building dashboard canvas with shapes and formatting in Excel
6) Creating various kinds of charts with Excel
7) Formatting charts so they look professional and slick!
8) Setting up Map Charts in Excel
9) Using Picture Links to create grids in dashboard
10) Interactive dashboards with slicers
11) Dashboard theming with Page Layout options
12) Storytelling with strong & insightful titles for your charts
๐ Topic-wise timestamps:
0:00 - Master Excel Dashboards in 26 Minutes (intro)
1:36 - Data for our dashboard
2:34 - KPIs and business questions for our dashboard
3:32 - Analysing data with Excel - Formulas vs. Pivots
4:00 - Calculated columns in our data
4:42 - Creating Pivot Tables for our dashboard
5:55 - Display format for the pivot values
6:18 - Dashboard Sheet Setup
8:24 - Building the Dashboard Side-panel (for summaries)
10:46 - 13 Week Sales Trend Graph
12:15 - Purchase Patterns Grid Chart (Picture Links)
14:49 - Quantity Distribution Chart (Pivot Grouping!)
16:23 - Most Popular Products Chart
18:02 - Map chart to see Geographic Trends
20:02 - Days to Delivery Chart
20:20 - Customer Satisfaction Chart
21:46 - Slicers for Dashboard Interactions!
26:18 - Adding Chart Titles
27:01 - Dashboard Theming (colors) with Page Layout options
28:44 - Closing Remarks (where to go from here)
๐ Download Sample Data:
Grab the sample file from here and build your own dashboard: chandoo.org/wp/wp-content/uploads/2025/11/ecommerce-blank.xlsx
๐งโ๐ป Learn more
Join my Excel School program and learn how to build world-class dashboards with Microsoft Excel. Use the coupon code SAVE50 to get $50 discount on the course.
Visit chandoo.org/wp/excel-school-program to enrol.
~
#excel #exceldashboard #dashboard










![Learn DAX ALL() Functions in Just 30 Minutes [POWER BI Essentials]
Learn the when and how to use ALL function in Power BI. We are also going to cover the difference between ALL, ALLSELECTED, REMOVEFILTERS, ALLEXCEPT and SELECTEDVALUE functions with real-world examples of when and how to use them for data analysis.
What we are going to learn:
1) Explanation of the data model
2) How and why we use ALL funciton
3) Using ALL(table) vs. ALL(table[column]) with a real-world example
4) DAX Query View to debug and check measures
5) Understanding the evaluation context and why sometimes doesnt work
6) ALL vs. ALLSELECTED
7) ALL vs. ALLEXCEPT
8) ALL vs. REMOVEFILTERS
9) Understanding ALLCROSSFILTERED & ALLNOBLANKROW
10) Practical Example #1: Rank among all vs. Rank in a specific category (ALL with RANKX)
11) Example #2: How a specific month sales vary compared to all months sales
๐ Sample Power BI File:
Blank file: https://github.com/chandoo-org/Power-BI/raw/refs/heads/main/sample%20files/All%20the%20ALL%20functions-blank.pbix
Completed file (available only for my Power BI Course members): join here ๐ https://chandoo.org/wp/power-bi-course/
๐ Video Topics:
0:00 - Understanding all the ALL functions in DAX (Power BI)
0:45 - Why and when to use ALL function
3:01 - Using ALL() with a table vs. table column
4:50 - DAX Query View and how it helps you with understanding calculations
6:10 - The key to understanding DAX - Evaluation Context
9:49 - ALL vs. ALLSELECTED
13:27 - ALL vs. ALLEXCEPT
17:20 - ALL vs. REMOVEFILTERS
18:40 - ALLCROSSFILTERED and ALLNOBLANKROW
22:14 - Rank in all vs. Rank in Category - RANKX + ALL Example
26:01 - Specific month sales vs. all month sales - Variance Analysis
๐บ More Power BI Videos and Playlists
๐ฅ Complete Power BI Course: If you want to learn Power BI including Power Query, DAX, Data Modeling and Dashboards - Check out my comprehensive Power BI Course - https://chandoo.org/wp/power-bi-course/
Use Code SAVE100 to get upto $100 (or Rs 6,000) discount on my Power BI + Excel bundle.
๐ถ Power BI Videos playlist - https://www.youtube.com/playlist?list=PLmejDGrsgFyClheDmsfikqOt0no-TKArs
๐ถ DAX + Power Pivot Playlist - https://www.youtube.com/playlist?list=PLmejDGrsgFyCm0i58VobdriBr FA8lYh
~
#powerbi #dax Learn DAX ALL() Functions in Just 30 Minutes [POWER BI Essentials]](https://i.ytimg.com/vi/o1WPhrvwjLQ/mqdefault.jpg)