Join us for a hands-on Microsoft Fabric training with Zane, where you’ll learn how to connect to a Power BI Semantic Model, work with data across the Fabric platform, and understand the value of using Fabric for scalable, integrated analytics. This session will highlight not just the “how,” but the “why” behind leveraging Fabric to streamline data workflows and unlock deeper insights.
Overview
COURSE DIFFICULTY
COURSE DURATION
30m
Skills Learned
After completing this online training course, students will be able to:
Create DAX measures for business calculations
Build calculated columns for data enrichment
Build formulas and functions for data analysis
BI Developers, Data Analysts, Excel Power Users, Business Analysts
None
01. Introduction
02. What Are Aggregates?
03. File Tour and Setup
04. SUM
05. SUMX
06. MAX
07. MAXX
08. MAXA
09. MIN
10. MINX
11. MINA
12. AVERAGE
13. AVERAGEX
14. AVERAGEA
15. COUNTROWS
16. COUNT
17. COUNTX
18. APPROXIMATEDDISTINCTCOUNT
19. DISTINCTCOUNT
20. DISTINCTCOUNTNOBLANK
21. COUNTBLANK
22. COUNTA
23. COUNTAX
24. PRODUCT
25. PRODUCTX
26. Advanced Aggregation Techniques
27. Class Wrap Up
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Create DAX measures for business calculations
Build calculated columns for data enrichment
Build formulas and functions for data analysis
WHO SHOULD ATTEND
BI Developers, Data Analysts, Excel Power Users, Business Analysts
PREREQUISITES
None
COURSE OUTLINE
01. Introduction
02. What Are Aggregates?
03. File Tour and Setup
04. SUM
05. SUMX
06. MAX
07. MAXX
08. MAXA
09. MIN
10. MINX
11. MINA
12. AVERAGE
13. AVERAGEX
14. AVERAGEA
15. COUNTROWS
16. COUNT
17. COUNTX
18. APPROXIMATEDDISTINCTCOUNT
19. DISTINCTCOUNT
20. DISTINCTCOUNTNOBLANK
21. COUNTBLANK
22. COUNTA
23. COUNTAX
24. PRODUCT
25. PRODUCTX
26. Advanced Aggregation Techniques
27. Class Wrap Up
