In this DAX Studio course, beginning with an introduction to its capabilities as a powerful tool for analyzing and optimizing data models within Power BI and other Analysis Services. You’ll learn how to connect DAX Studio to your data models, navigate its user-friendly interface, and unlock its potential for performance tuning and troubleshooting.
Overview
COURSE DIFFICULTY
COURSE DURATION
1h 5m
Skills Learned
After completing this online training course, students will be able to:
Build formulas and functions for data analysis
Create charts and visualizations for data presentation
Design interactive Excel dashboards
Excel Power Users, Business Analysts, Data Analysts
None
01. Introduction to Interactive Dashboards with Excel (Why Excel)
02. Introduction to Interactive Dashboards with Excel (Why Dashboards)
03. Introduction to Interactive Dashboards with Excel (VLOOKUP Series Selection Demo)
04. Thinking Outside the Cell (Introduction)
05. Thinking Outside the Cell (Why Develop Differently)
06. Thinking Outside the Cell (Inserting the Camera Tool)
07. Thinking Outside the Cell (Using the Camera Tool)
08. Thinking Outside the Cell (Development Principles)
09. Working with Formulas (Formula Editing Tips)
10. Working with Formulas (Excel's Calculation Engine)
11. Working with Formulas (Writing Better Formulas)
12. Lookup Functions (Introduction)
13. Lookup Functions (VLOOKUP, INDEX, MATCH)
14. Lookup Functions (Array Formulas)
15. Lookup Functions (Array Formulas Review)
16. Excel Tables (Introduction)
17. Excel Tables (Inserting an Excel Table)
18. Excel Tables (Working with Tables)
19. Excel Tables (Excel Table Chart)
20. Excel Tables (Excel Table Rules)
21. Sorting and Decision Function with Excel Tables (Sorting Functions)
22. Sorting and Decision Function with Excel Tables (Filters and SUMPRODUCT)
23. Sorting and Decision Function with Excel Tables (Filtering on Excel Tables)
24. Sorting and Decision Function with Excel Tables (Aggregation with Excel Tables)
25. Sorting and Decision Function with Excel Tables (Summary)
26. Introduction to Form Controls (Enabling the Developer Tab)
27. Introduction to Form Controls (Excel Controls)
28. Introduction to Form Controls (Form Control Basics)
29. Formula Driven Development (Introduction)
30. Formula Driven Development (Information-Transformation-Presentation)
31. Interactive Legends in Excel (Setting Up the Interactive Legend)
32. Interactive Legends in Excel (Perfecting the Interactive Legend)
33. Interactive Chart Toggle (Setup)
34. Interactive Chart Toggle (Formatting)
35. Interactive Chart Toggle (Maintenance)
36. Interactive Dashboards (Setup)
37. Interactive Dashboards (Formatting)
38. Interactive Dashboards (Maintenance)
39. Primer on Data Visualizations (Visual Perception)
40. Primer on Data Visualizations (Gestalt Laws of Grouping)
41. Primer on Data Visualizations (Preattentive Attributes)
42. Primer on Data Visualizations (The Problem with Pie Charts)
43. Primer on Data Visualizations (Data Vis vs Infographics)
44. Expanding the Chart Library (Dual Axis Banding)
45. Expanding the Chart Library (Area Chart Banding)
46. Expanding the Chart Library (Limit Charts)
47. Bullet Charts in Excel (Building the Chart)
48. Bullet Charts in Excel (Horizontal Bullet Chart Trick)
49. Infographics (Introduction)
50. Infographics (Progress Meter)
51. Infographics (Donut Chart)
52. Infographics (Waffle Chart)
53. Infographics (Bringing it Together with the Camera)
54. Summary
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Build formulas and functions for data analysis
Create charts and visualizations for data presentation
Design interactive Excel dashboards
WHO SHOULD ATTEND
Excel Power Users, Business Analysts, Data Analysts
PREREQUISITES
None
COURSE OUTLINE
01. Introduction to Interactive Dashboards with Excel (Why Excel)
02. Introduction to Interactive Dashboards with Excel (Why Dashboards)
03. Introduction to Interactive Dashboards with Excel (VLOOKUP Series Selection Demo)
04. Thinking Outside the Cell (Introduction)
05. Thinking Outside the Cell (Why Develop Differently)
06. Thinking Outside the Cell (Inserting the Camera Tool)
07. Thinking Outside the Cell (Using the Camera Tool)
08. Thinking Outside the Cell (Development Principles)
09. Working with Formulas (Formula Editing Tips)
10. Working with Formulas (Excel's Calculation Engine)
11. Working with Formulas (Writing Better Formulas)
12. Lookup Functions (Introduction)
13. Lookup Functions (VLOOKUP, INDEX, MATCH)
14. Lookup Functions (Array Formulas)
15. Lookup Functions (Array Formulas Review)
16. Excel Tables (Introduction)
17. Excel Tables (Inserting an Excel Table)
18. Excel Tables (Working with Tables)
19. Excel Tables (Excel Table Chart)
20. Excel Tables (Excel Table Rules)
21. Sorting and Decision Function with Excel Tables (Sorting Functions)
22. Sorting and Decision Function with Excel Tables (Filters and SUMPRODUCT)
23. Sorting and Decision Function with Excel Tables (Filtering on Excel Tables)
24. Sorting and Decision Function with Excel Tables (Aggregation with Excel Tables)
25. Sorting and Decision Function with Excel Tables (Summary)
26. Introduction to Form Controls (Enabling the Developer Tab)
27. Introduction to Form Controls (Excel Controls)
28. Introduction to Form Controls (Form Control Basics)
29. Formula Driven Development (Introduction)
30. Formula Driven Development (Information-Transformation-Presentation)
31. Interactive Legends in Excel (Setting Up the Interactive Legend)
32. Interactive Legends in Excel (Perfecting the Interactive Legend)
33. Interactive Chart Toggle (Setup)
34. Interactive Chart Toggle (Formatting)
35. Interactive Chart Toggle (Maintenance)
36. Interactive Dashboards (Setup)
37. Interactive Dashboards (Formatting)
38. Interactive Dashboards (Maintenance)
39. Primer on Data Visualizations (Visual Perception)
40. Primer on Data Visualizations (Gestalt Laws of Grouping)
41. Primer on Data Visualizations (Preattentive Attributes)
42. Primer on Data Visualizations (The Problem with Pie Charts)
43. Primer on Data Visualizations (Data Vis vs Infographics)
44. Expanding the Chart Library (Dual Axis Banding)
45. Expanding the Chart Library (Area Chart Banding)
46. Expanding the Chart Library (Limit Charts)
47. Bullet Charts in Excel (Building the Chart)
48. Bullet Charts in Excel (Horizontal Bullet Chart Trick)
49. Infographics (Introduction)
50. Infographics (Progress Meter)
51. Infographics (Donut Chart)
52. Infographics (Waffle Chart)
53. Infographics (Bringing it Together with the Camera)
54. Summary
