Business Intelligence professionals, BI developers and existing Power BI users looking to master Power BI for all their data visualization and dashboarding needs will find this course to be useful. While understanding of the basic BI concepts is required, some exposure to Microsoft Power BI will be helpful.
We recommend that attendees of this class have completed the course “Power BI for Desktop”.
After completing this course, students will be able to
- Build efficient data retrieval and transformation processes with the Power Query M Language
- Developing DAX Measures and Security Roles
- Manage and monitor the Power BI Service and the On-premises data gateway
- Develop a fully on-premise solution with the Power BI Report Server
- Scale up a Power BI solution via Power BI Premium capacity and migration to Azure Analysis Services or SQL Server Analysis Services
Chapter 1: Connecting to Sources and Transforming Data with M
- Query design per dataset mode
- Data sources
- Power BI Desktop options
- SQL views
- Parameters
- Staging queries
- Data types
- Query folding
- M query examples
- M query editing tools
Chapter 2: Developing DAX Measures and Security Roles
- DAX measures
- Filter and row contexts
- DAX variables
- Base measures
- Date intelligence metrics
- Dimension metrics
- Ranking metrics
- Security roles
- Dynamic row-level security
- Performance testing
Chapter 3: Managing the On-Premises Data Gateway
- On-premises data gateway planning
- Gateway clusters and architectures
- Configuration of the On-premises data gateway
- Scheduled data refresh
- Dashboard tile cache refresh
- Managing gateway clusters
- Monitoring gateway usage
- Live connections to Analysis Services models
- Single sign-on DirectQuery
Chapter 4: Deploying the Power BI Report Server
- Planning for the Power BI Report Server
- Installation and configuration of Power BI Report Server
- Power BI Desktop for Power BI Report Server
- Power BI Report Server Portal
- Scheduled data refresh and Live connections
- Power BI mobile applications
- Power BI Report Server administration
- Scaling Power BI Report Server
Chapter 5: Creating Power BI Apps and Content Distribution
- Content distribution methods
- Power BI apps
- Sharing dashboards and reports
- Data Alerts and notifications
- SharePoint Online embedding
- Report and dashboard subscriptions
- Analyze in Excel
- Custom application embedding
Chapter 6: Administering Power BI for an Organization
- Data governance for Power BI
- Azure Active Directory conditional access policies
- Azure Active Directory B2B collaboration
- Power BI admin portal
- Power BI service Tenant settings
- Power BI activities in Audit Logs
- Using metrics reports
- Administering Power BI Premium capacities
Chapter 7: Scaling with Premium and Analysis Services
- Power BI Premium
- Power BI Premium provisioning factors
- Power BI Premium capacity allocation
- Analysis Services versus Power BI datasets
- Azure Analysis Services and SQL Server Analysis Services
- Migration from Power BI dataset to Analysis Services model
