The course will prepare students to take the Microsoft 70-778, Analyzing and Visualizing Data with Power BI certification exam.
- Introduction to Power BI
- The Power BI Service and Desktop Application
- Connecting to Data Sources
- Creating Desktop Reports and Dashboards
- Creating and Publishing Online Reports and Dashboards
- Extensions and Developer Capabilities
- Natural Language Processing in Power BI
- Power BI Analytics with R
- Previous experience with BI concepts and visualization tools
This module is an introduction to Power BI. We will cover Power BI Desktop vs Power BI Service including mobile. We will also cover the core functions of Power BI including basic reporting, managing on-premises and online data sources in Power BI, and securing, sharing and embedding reports.
Lab: Working with Power BI
MODULE 2: Power BI for Advanced Data Visualization
In this module, we will look at advanced visualization in Power BI. We will cover optimal visualization selection, page layout, configuring visual relationships, setting up default summaries and categories, and managing text and images.
Lab: Visualizing Data with Power BI
MODULE 3: Dashboarding Theory and Practice
In this module, we will cover dashboard and report development in Power BI. Topics covered will include static and interactive dashboards, publishing to the Power BI service, filtering, settings and customization and natural language queries.
Lab: Dashboarding in Power BI
MODULE 4: Advanced Analytics in Power BI
In this module, we look at the advanced analytics capabilities in Power BI. We will cover DAX queries and performance KPIs. We will also look at leveraging parameters to customize reports and KPIs. Students will also learn to create and optimize data models and manage data relationships.
Lab: Creating DAX Queries
Lab: Creating Performance KPIs
Lab: Using Parameters to Build Custom Reports
MODULE 5: Extending Advanced Analytics with R
In this module, we will look at extending the capabilities of Power BI with R. We will start with an introduction to R. We will teach students how to integrate R into Power BI to generate descriptive statistics and calculate probability.
Lab: R Scripting
Lab: Configuring R with Power BI
Dedicated instructor-led training is designed for group training and is delivered by the experts at Opsgility. Delivery availability is anywhere in the world at your location or using advanced virtual training software.
- Standard or Customized Curriculum
- Globally Available for Delivery
- Holistic Learning Plans are Available
- Industry Recognized Subject Matter Experts