Mastering Business Intelligence with DAX, Power BI, and Excel by Microsoft Press

Course details

In this course, master business intelligence using DAX, Power BI, and Excel. Understand and utilize various layers of business intelligence models and extend your data analysis skills. Discover key concepts such as designing semantic models, employing basic and advanced DAX functions, and leveraging time intelligence to enhance data reports. Learn to build efficient calculations, work with context and filters, and explore advanced techniques like table functions and window functions. Unravel the complexities of understanding relationships and optimizing data structures to improve performance. This course suits data professionals who aim to heighten their analytical proficiency using Microsoft tools. Check out this course to unlock the potential of DAX and Power BI, gaining insights into more efficient data report generation. With practical exercises and detailed examples, you can become adept at handling data challenges and optimizing analytical processes.

Concepts

0. Introduction

01 - Mastering business intelligence with DAX, Power BI, and Excel

1. Understand the Role of DAX

02 - Learning objectives
03 - Understand the five-layer model for business intelligence
04 - Use DAX in Power BI
05 - Use DAX in Excel

2. Design Semantic Models

06 - Learning objectives
07 - Understand the column store
08 - Choose data types
09 - Design efficient tables
10 - Understand relationships
11 - Define an effective model structure
12 - Decide on model architecture
13 - Exercises

3. Learn the Basics of DAX

14 - Learning objectives
15 - Extend a model with calculated columns
16 - Extend a model with calculated tables
17 - Understand measures
18 - Use basic aggregations
19 - Apply operators
20 - Implement conditional logic
21 - Exercises

4. Organize DAX Calculations

22 - Learning objectives
23 - Use a measure table and folders
24 - Add metadata
25 - Work with the DAX editor
26 - Exercises

5. Create Visual Calculations

27 - Learning objectives
28 - Understand AutoExist
29 - Leverage the visual matrix
30 - Add a visual calculation
31 - Use more advanced visual calculations
32 - Navigate the visual matrix with DAX
33 - Exercises

6. Understand Filters, Context, and CALCULATE

34 - Learning objectives
35 - Explore filters
36 - Understand row context
37 - Understand query context
38 - Use filter context with CALCULATE
39 - Exercises

7. Build More Advanced Calculations

40 - Learning objectives
41 - Use ALL functions
42 - Change relationship behavior
43 - Leverage KEEPFILTERS
44 - Use variables in DAX
45 - Exercises

8. Use Time Intelligence

46 - Learning objectives
47 - Create a date table
48 - Understand time intelligence
49 - Use common time intelligence functions
50 - Exercises

9. Understand DAX Table Functions

51 - Learning objectives
52 - Use table aggregations
53 - Leverage virtual tables
54 - Understand row context in table functions
55 - Retrieve summarized tables
56 - Change context for table evaluation
57 - Exercises

10. Apply Table Functions within CALCULATE

58 - Learning objectives
59 - Understand filters and tables
60 - Change context with virtual tables
61 - Understand lineage
62 - Exercises

11. Use WINDOW Functions

63 - Learning objectives
64 - Understand what changing context does
65 - Understand INDEX, OFFSET, and WINDOW
66 - Use PARTITIONBY and MATCHBY
67 - Exercises

12. Implement Parameters

68 - Learning objectives
69 - Use numeric range parameters
70 - Implement field parameters
71 - Exercises

13. Create and Use Calculation Groups

72 - Learning objectives
73 - Understand calculation groups
74 - Add calculation items
75 - Use dynamic formatting
76 - Create conditional calculation items
77 - Exercises

14. Use the DAX Query View

78 - Learning objectives
79 - Use Performance Analyzer
80 - Understand a visual's DAX query
81 - Use the DAX query view
82 - Apply quick queries and INFO functions
83 - Debug measures
84 - Exercises

15. Learn from DAX Exercises

85 - Learning objectives
86 - Understand lesson 2 exercises - Semantic models
87 - Understand lesson 3 exercises - Basic DAX
88 - Understand lesson 4 exercises - Organize calculations
89 - Understand lesson 5 exercises - Visual calculations
90 - Understand lesson 6 exercises - Context
91 - Understand lesson 7 exercises - Advanced calculations
92 - Understand lesson 8 exercises - Time intelligence
93 - Understand lesson 9 exercises - Table functions
94 - Understand lesson 10 exercises - Table filters
95 - Understand lesson 11 exercises - WINDOW functions
96 - Understand lesson 12 exercises - Parameters
97 - Understand lesson 13 exercises - Calculation groups
98 - Understand lesson 14 exercises - DAX query view

Conclusion

99 - Summary