Power BI for Business Users – Advanced

Power BI for Business Users – Advanced


The Power BI Advanced course focuses on building your knowledge and understanding of the data modeling and programmatic nature of Power BI, with emphasis on DAX syntax, measures, and function design using the Power Query Editor to load, transform, and perfect data. The student will also extend their knowledge with configuring visuals and dashboards using enhanced capabilities by applying features such as hierarchies, drill-through and tooltip pages. The student will also become familiar with Power BI Services collaboration and administration options.

SKU: N/A Categories: ,


Module 1: Prepare Data in Power BI
• Get data from various data sources
• Optimize performance
• Resolve data errors

Exercise: Defining Data Sources
Exercise: Resolving Data Errors

Module 2: Clean, Transform, and Load Data in Power BI
• Enhance the data structure
• Data Profiling

Exercise: Cleaning and Transforming Data
Exercise: Using Query Editor to Transform and Load Data

Module 3: Design a Data Model in Power BI
• Data modeling overview
• Security Principles and Data Modeling
• Table Principles and Data Modeling
• Dimensionality and Hierarchies

Exercise: Creating a Data Model in Power
Exercise: Applying 1:1, M:1, 1:M, M:M and Normalization Policies in Power BI

Module 4: Extending the Data Model
• Create model relationships
• Configure table and column properties
• Create hierarchies
• Create quick measures

Exercise: Integrating Multiple Data Sources into a Single Hierarchy

Module 5: DAX and Power BI
• DAX Context
• DAX Variables
• DAX Measures
• Calculated tables
• Calculated columns
• DAX Functions (14 Flavors)

Exercise: Creating a DAX Variable
Exercise: Creating a DAX Measure
Exercise: Using DAX Functions as Part of a Calculation

Module 6: Perfecting Model Performance
• Optimize the model for performance
• Optimize DirectQuery Models
• Create and manage aggregations
• Understand the importance of variables
• Enhance the data model
• Optimize the storage model
• Implement Data Aggregation

Exercise: Perfect Data Models for Quick Performance under Direct Import and Direct Query Modes

Module 7: Transitioning from Desktop to Services: Reporting
• Design and publishing a report
• Enhancing the report
• Design a report page layout for print-readiness
• Select and add effective visualizations
• Add basic report functionality
• Add report navigation and interactions
• Improve report performance
• Design for accessibility

Exercise: Publishing a Report from Desktop to Services
Exercise: Enhancing Reports in Services
Exercise: Making Reports Accessible

Module 8: Transitioning from Desktop to Services: Dashboards, Datasets, and Apps
• Create a Dashboard
• Pinning Reports to Dashboards
• Real-time Dashboards
• Enhance a Dashboard
• Use Q&A to create a dashboard tile
• Managing Datasets in Power BI Services
• Creating a Power BI Standalone App

Exercise: Creating a Dashboard
Exercise: Using Q&A (Artificial Intelligence) in Power BI
Exercise: Creating a Power BI App from Reports and Dashboards

Module 9: Create, Administer, and Manage Workspaces in Power BI Services
• Create and manage a workspace
• Understand workspace collaboration
• Monitor workspace usage and performance
• Managing Workspace Parameters and Datasets
• Understand the aspects of Power BI security
• Configure row-level security roles and group memberships
• Manage basic Power Bi Administrative Responsibilities

Exercise: Create a My Workspace
Exercise: Manage Roles and Responsibilities
Exercise: Explore Built-In Usage and Performance Reporting

Additional information


Commercial, Government