IL - Power BI for Data Professionals

Course Overview

This course covers using Power BI Desktop to create and deploy datasets and reports as well as deploying, sharing, and securing assets in PowerBI.com. 
We will start off by reviewing the components of the Power BI ecosystem. Then we will begin to build a model in Power BI Desktop by acquiring data using Power Query/M. Next, we will shape and model the data using M and DAX. Then we will build calculations to support analysis and reporting. 
Once we have a working dataset, we will build a report using default and custom visuals, buttons, and bookmarks. Then we’ll add dynamic row-level security roles.  
Next, we’ll explore various ways to deploy and share the data model and the report in PowerBI.com. This will include organization of workspaces, user roles within the workspace, row-level security, and use of Power BI apps. We will also look at scheduling the refresh of data in imported and composite datasets. 
The course will wrap up by looking at some reusability and lifecycle management techniques including version control, pre-production environments, use of shared and certified datasets, and suggested quality checks before deploying to production. 

Course Details
  • Duration: 2 Days
  • Level: 300

Who this course is designed for
  • Business Intelligence and Data Professionals

What You Will Learn

  • 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

Prerequisites:

  • Previous experience with BI concepts and visualization tools

Outline

MODULE 1: Introduction to Power BI

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;

Contact the experts at Opsgility to schedule this class at your location or to discuss a more comprehensive readiness solution for your organization. Contact us to enroll or book a class

Contact Us
Looking for on-demand training?
Try SkillMeUp.com