Description
Power BI is Microsoft's Business Intelligence solution in the Office 365 environment. This software helps users connect to different data sources and create reports with different images to show the data in a comprehensive way. This training focuses on using advanced features in Power BI.
Audience
This course is intended for anyone who has some experience in creating and publishing reports and dashboards in Power BI and who wants to have more knowledge about using advanced features in the Power BI environment
Methods
Classic training with individual guidance. Practical exercises make it possible for students to become familiar with the possibilities of the product. Each participant performs the exercises at their own workstation.
Contents
- Using advanced DAX instructions
- Using relationships effectively
- Semi-additive measures
- Using time intelligence functions
- Optimize model performance
- Optimize the Data Model for Performance
- Use Variables to Improve Performance and Troubleshooting
- Performance Analyzer
- Review Performance Results
- Analyze Query Plans
- Reduce Cardinality
- Implement Granularity Table
- Optimize DirectQuery Models
- Implications of using DirectQuery
- Optimize Performance
- Create and Manage Aggregations
- Creating Aggregations
- Managing Aggregations
- Create Paginated Reports in Power BI
- Paginated Report Overview
- Introduction to Paginated Reports
- When are they the right fit?
- Creating Paginated Reports
- Getting Data
- Create a Paginated Report
- Work with Charts and Tables
- Publish the Report
- Perform Advanced Analytics
- Advanced Analytics
- Explore Statistical Summary
- Identify Outliers
- Conduct Time Series Analysis
- Using the Analyze Feature
- Advanced Analytics Custom Visuals
- Quick Insights
- Groupings and Binnings
- Clustering Techniques
- Data Insights through AI Visuals
- Introduction to AI Visuals
- The Q&A Feature
- AI Insights
- Key Influencer Visual
- Visual Decomposition Tree
- Create and Manage Workspaces
- Creating Workspaces
- Introduction to Workspaces
- Create a Workspace
- Assign Workspace Roles
- Create Apps
- Configure and Update a Workspace App
- Sharing and Managing Assets
- Monitor Usage and Performance
- Development Lifecycle Strategy
- Viewing Data Lineage
- Data Protection
- Manage Datasets in Power BI
- Using Parameters
- Introduction to Datasets and Parameters
- Dynamic Reports with parameters
- What-if Parameters
- Datasets
- Scheduled Refresh dataset
- Incremental Data Refresh Settings
- Manage and Promote Datasets
- Troubleshooting Service Connectivity
Certification
Participation certificate: At the end of the training, participants will receive a certificate that they have completed this course.