Uploaded September 2024 | Updated November 2026, 3 days ago
π©βπ» Checkout my advanced Excel course at chandoo.org/wp/excel-school-program
π Download files π chandoo.org/wp/free-call-centre-dashboard
In our final lesson of Excel module, we will be building a call centre performance dashboard as show-cased above. In this portfolio project, you will learn:
βΆ Designing the dashboard color theme and fonts
βΆ How to use Data model feature of Excel to connect datasets
βΆ Creating KPIs and measures using Power Pivot and DAX
βΆ Using Pivot tables to create all the dashboard calculations
βΆ Making interactive Pivot Charts with slicers
βΆ Applying conditional formatting to charts & tables
βΆ Using XLOOKUP and images in Excel to show dynamic pictures
β± Video timestamps:
==================
0:00 - Demo of what we are going to build - call centre dashboard
1:35 - A closer look at the dataset and dashboard assets
2:57 - Set up dashboard color scheme and fonts
4:31 - Creating pivot tables
5:31 - Setting up the data model and relationships
7:29 - Calculating the DAX measures for various KPIs
12:47 - Making dashboard tiles
20:48 - Calls trend line graph
27:22 - Weekday trend bar graph
31:18 - Calls and amounts by rep (dynamic chart)
44:58 - Formatting slicers with styles
47:36 - Calls by customer demographics
50:19 - Rating distribution histogram
52:33 - Customer Revenue Analysis (table)
57:10 - Conditional formatting databars
58:51 - Highlighting selected "rep" in the table
1:01:34 - Adding the "picture" of selected rep
1:10:11 - Making dashboard title etc.
1:11:30 - How to learn more and become really good in Excel
π Files:
=======
π Blank data file: chandoo.org/wp/wp-content/uploads/2024/09/sample-data-excel-portfolio-project.xlsx
π Completed workbook (+more): chandoo.org/wp/free-data-analyst-course
πΆ Full course playlist: youtube.com/playlist?list=PLmejDGrsgFyCD25L2XEKESQEw8smsY6WO
π» Full course webpage: chandoo.org/wp/free-data-analyst-course
π©βπ» Advanced Excel course: chandoo.org/wp/excel-school-program
~
#Excel #Chandoo #fdac #freedataanalystcourse
π©βπ» Checkout my advanced Excel course at chandoo.org/wp/excel-school-program
π Download files π chandoo.org/wp/free-call-centre-dashboard
In our final lesson of Excel module, we will be building a call centre performance dashboard as show-cased above. In this portfolio project, you will learn:
βΆ Designing the dashboard color theme and fonts
βΆ How to use Data model feature of Excel to connect datasets
βΆ Creating KPIs and measures using Power Pivot and DAX
βΆ Using Pivot tables to create all the dashboard calculations
βΆ Making interactive Pivot Charts with slicers
βΆ Applying conditional formatting to charts & tables
βΆ Using XLOOKUP and images in Excel to show dynamic pictures
β± Video timestamps:
==================
0:00 - Demo of what we are going to build - call centre dashboard
1:35 - A closer look at the dataset and dashboard assets
2:57 - Set up dashboard color scheme and fonts
4:31 - Creating pivot tables
5:31 - Setting up the data model and relationships
7:29 - Calculating the DAX measures for various KPIs
12:47 - Making dashboard tiles
20:48 - Calls trend line graph
27:22 - Weekday trend bar graph
31:18 - Calls and amounts by rep (dynamic chart)
44:58 - Formatting slicers with styles
47:36 - Calls by customer demographics
50:19 - Rating distribution histogram
52:33 - Customer Revenue Analysis (table)
57:10 - Conditional formatting databars
58:51 - Highlighting selected "rep" in the table
1:01:34 - Adding the "picture" of selected rep
1:10:11 - Making dashboard title etc.
1:11:30 - How to learn more and become really good in Excel
π Files:
=======
π Blank data file: chandoo.org/wp/wp-content/uploads/2024/09/sample-data-excel-portfolio-project.xlsx
π Completed workbook (+more): chandoo.org/wp/free-data-analyst-course
πΆ Full course playlist: youtube.com/playlist?list=PLmejDGrsgFyCD25L2XEKESQEw8smsY6WO
π» Full course webpage: chandoo.org/wp/free-data-analyst-course
π©βπ» Advanced Excel course: chandoo.org/wp/excel-school-program
~
#Excel #Chandoo #fdac #freedataanalystcourse




![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)





