FREE Data Analyst Course - Become an Excel PRO with this complete Dashboard Project 📈

5.0 (1)

7 learners

What you'll learn

This course includes

15.5 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

chandoo chandoo.org Excel spreadsheets excel end to end project excel end to end project for data analyst excel dashboard tutorial advanced excel dashboard interactive excel dashboard dynamic excel dashboard call centre dashboard in excel customer care dashboard

Full Transcript

👩‍💻 Checkout my advanced Excel course at https://chandoo.org/wp/excel-school-program/ 📁 Download files 👉 https://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: https://chandoo.org/wp/wp-content/uploads/2024/09/sample-data-excel-portfolio-project.xlsx 📊 Completed workbook (+more): https://chandoo.org/wp/free-data-analyst-course/ 🎶 Full course playlist: https://www.youtube.com/playlist?list=PLmejDGrsgFyCD25L2XEKESQEw8smsY6WO 💻 Full course webpage: https://chandoo.org/wp/free-data-analyst-course/ 👩‍💻 Advanced Excel course: https://chandoo.org/wp/excel-school-program/ ~ #Excel #Chandoo #fdac #freedataanalystcourse

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Welcome