In this session led by Mitchell, attendees will gain insights into leveraging visual calculations to streamline DAX calculations in Power BI. Mitchell will explore this new capability, providing participants with a clear understanding of its functionality and potential applications. Emphasis will be placed on replacing complex DAX calculations with simplified visual calculations.
Overview
COURSE DIFFICULTY
COURSE DURATION
1h 46m
Skills Learned
After completing this online training course, students will be able to:
Design interactive Excel dashboards
Develop analytical models with SQL Server Analysis Services
Write MDX queries for multidimensional analysis
Design and manage cube partitions
Data Engineers, Database Administrators, Excel Power Users, Business Analysts
None
01. What you need to get started
02. Dimension Modeling
03. SSAS Overview
04. Cube Design and Browsing
05. Dimension and Cube Designers
06. Adding New Facts and Dimensions
07. MDX and Calculations (MDX Basics)
08. MDX and Calculations (Creating Calculations)
09. Data Mining Basics
10. Actions and KPIs
11. Reporting Services with SSAS
12. Administration (Partitions)
13. Administration (Aggregations)
14. Administration (Perspectives)
15. Administration (Security)
16. Administration (Deployment)
17. Using Excel to Build Cube Interfaces
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Design interactive Excel dashboards
Develop analytical models with SQL Server Analysis Services
Write MDX queries for multidimensional analysis
Design and manage cube partitions
WHO SHOULD ATTEND
Data Engineers, Database Administrators, Excel Power Users, Business Analysts
PREREQUISITES
None
COURSE OUTLINE
01. What you need to get started
02. Dimension Modeling
03. SSAS Overview
04. Cube Design and Browsing
05. Dimension and Cube Designers
06. Adding New Facts and Dimensions
07. MDX and Calculations (MDX Basics)
08. MDX and Calculations (Creating Calculations)
09. Data Mining Basics
10. Actions and KPIs
11. Reporting Services with SSAS
12. Administration (Partitions)
13. Administration (Aggregations)
14. Administration (Perspectives)
15. Administration (Security)
16. Administration (Deployment)
17. Using Excel to Build Cube Interfaces
