Overview
Syllabus
Module 1 Get Started with Microsoft Data Analytics
- Data Analytics and Microsoft
- Getting Started with Power BI
Module 2 Getting Data in Power BI
- Data Analytics and Microsoft
- Optimize Performance
- Resolve Data Errors
Module 3 Cleaning, Transforming, and Loading Data in Power BI
- Shaping the Data
- Profiling the Data
- Enhance the data structure
Module 4 Design a Data Model in Power BI
- Introduction to data modeling
- Working with tables
- Dimensions and Hierarchies
- Create Model Relationships
- Configure Tables and Column Properties
- Create hierarchies
Module 5 Create Model Calculations using DAX in Power BI
- Introduction to DAX
- Real-time dashboards
- Advanced DAX
- Create calculated tables
- Create calculated columns
- Create measures
- Use the CALCULATE() function to manipulate filter context
- Use Time Intelligence functions
Module 6 Optimize Model Performance in Power BI
- Optimize the data model for performance
- Optimize DirectQuery Models
Module 7 Create Reports in Power BI
- Design a report
- Enhance the report
- Create and configure Sync Slicers
- Create a drillthrough page
- Apply conditional formatting
- Create and use Bookmarks
- Design a report
- Configure visual fields and format properties
Module 8 Create Dashboards in Power BI
- Create a Dashboard
- Real-time Dashboards
- Enhance a Dashboard
- Create a Dashboard
- Pin visuals to a Dashboard
- Use Q&A to create a dashboard tile
Module 9 Identify Patterns and Trends in Power BI
- Advanced Analytics
- Data Insights through AI visuals
- Create animated scatter charts
- Use the visual to forecast values
Module 10 Create and Manage Workspaces in Power BI
- Creating Workspaces
- Sharing and Managing Assets
Module 11 Manage Files and Datasets in Power BI
- Parameters
- Datasets
Module 12 Row-level Security in Power BI
- Security in Power BI
- Configure many-to-many relationships
- Enforce row-level security
Taught by
Bruce Gay, Steve Pesklo, and Joe Mlakar