👩‍💻 Checkout my advanced Excel course at https://chandoo.org/wp/excel-school-p...


📁 Download files 👉 https://chandoo.org/wp/free-call-cent...

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: https://chandoo.org/wp/wp-content/upl...
📊 Completed workbook (+more):  https://chandoo.org/wp/free-data-anal...
🎶 Full course playlist: FREE Data Analyst Course
💻 Full course webpage: https://chandoo.org/wp/free-data-anal...
👩‍💻 Advanced Excel course: https://chandoo.org/wp/excel-school-p...

~

#Excel #Chandoo #fdac #freedataanalystcourse