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.
Curriculum
54 Sections
0 Lessons
1 Hour
Expand all sectionsCollapse all sections
01. Introduction to Interactive Dashboards with Excel (Why Excel)
0
02. Introduction to Interactive Dashboards with Excel (Why Dashboards)
0
03. Introduction to Interactive Dashboards with Excel (VLOOKUP Series Selection Demo)
0
04. Thinking Outside the Cell (Introduction)
0
05. Thinking Outside the Cell (Why Develop Differently)
0
06. Thinking Outside the Cell (Inserting the Camera Tool)
0
07. Thinking Outside the Cell (Using the Camera Tool)
0
08. Thinking Outside the Cell (Development Principles)
0
09. Working with Formulas (Formula Editing Tips)
0
10. Working with Formulas (Excel's Calculation Engine)
0
11. Working with Formulas (Writing Better Formulas)
0
12. Lookup Functions (Introduction)
0
13. Lookup Functions (VLOOKUP, INDEX, MATCH)
0
14. Lookup Functions (Array Formulas)
0
15. Lookup Functions (Array Formulas Review)
0
16. Excel Tables (Introduction)
0
17. Excel Tables (Inserting an Excel Table)
0
18. Excel Tables (Working with Tables)
0
19. Excel Tables (Excel Table Chart)
0
20. Excel Tables (Excel Table Rules)
0
21. Sorting and Decision Function with Excel Tables (Sorting Functions)
0
22. Sorting and Decision Function with Excel Tables (Filters and SUMPRODUCT)
0
23. Sorting and Decision Function with Excel Tables (Filtering on Excel Tables)
0
24. Sorting and Decision Function with Excel Tables (Aggregation with Excel Tables)
0
25. Sorting and Decision Function with Excel Tables (Summary)
0
26. Introduction to Form Controls (Enabling the Developer Tab)
0
27. Introduction to Form Controls (Excel Controls)
0
28. Introduction to Form Controls (Form Control Basics)
0
29. Formula Driven Development (Introduction)
0
30. Formula Driven Development (Information-Transformation-Presentation)
0
31. Interactive Legends in Excel (Setting Up the Interactive Legend)
0
32. Interactive Legends in Excel (Perfecting the Interactive Legend)
0
33. Interactive Chart Toggle (Setup)
0
34. Interactive Chart Toggle (Formatting)
0
35. Interactive Chart Toggle (Maintenance)
0
36. Interactive Dashboards (Setup)
0
37. Interactive Dashboards (Formatting)
0
38. Interactive Dashboards (Maintenance)
0
39. Primer on Data Visualizations (Visual Perception)
0
40. Primer on Data Visualizations (Gestalt Laws of Grouping)
0
41. Primer on Data Visualizations (Preattentive Attributes)
0
42. Primer on Data Visualizations (The Problem with Pie Charts)
0
43. Primer on Data Visualizations (Data Vis vs Infographics)
0
44. Expanding the Chart Library (Dual Axis Banding)
0
45. Expanding the Chart Library (Area Chart Banding)
0
46. Expanding the Chart Library (Limit Charts)
0
47. Bullet Charts in Excel (Building the Chart)
0
48. Bullet Charts in Excel (Horizontal Bullet Chart Trick)
0
49. Infographics (Introduction)
0
50. Infographics (Progress Meter)
0
51. Infographics (Donut Chart)
0
52. Infographics (Waffle Chart)
0
53. Infographics (Bringing it Together with the Camera)