Course Objective

This course is designed for new or intermediate Power BI users who have some experience with the software. Students will learn the fundamentals of the tool and how to apply basic functionality to build and share dashboards of data visualizations using their data.

Students will connect to various data sources, shape and combine data, work with reports, and create and share useable dashboards. This course is taught workshop-style — hands-on with valuable tools to take directly back to current projects. 

 

Course Outline

Power BI Overview

Power BI Use Cases

  • Power BI Service 
  • Sharing
  • Apps 
  • Licensing 
  • Dashboards 
  • Reports 
  • Datasets 
  • Workbooks 
  • Excel 
  • Data refresh 
  • Collaboration 
  • Notifications 
  • Application Integrations 

Power BI Desktop

  • Connections 
  • Modeling 
  • Visualization 
  • DAX
  • Version control 
  • Using Query Editor 
  • Aggregation 
  • Manipulating Data 

Power BI Premium

  • Licensing 
  • Capacity Planning 

Power BI Embedded

  • Licensing 
  • Capacity Planning 
  • Row Level Security 
  • Multi Tenant 
  • Azure AD Security 
  • Embed 
  • Reports 
  • Tiles 
  • Dashboards 
  • Q&A 
  • Application Registration 
  • REST API 

Data Architecture API

  • Building Relationships 
  • Connect and transform data sets 
  • Work with unstructured datasets
  • Storage and connectivity 
  • Data Types 
    • Structured 
    • Unstructured
  • Schema Overview 
  • Working with Query Editor
    • Merging tables together 
    • Appending tables 
    • Data type transformations 
    • Group rows 
    • Create custom columns

SQL

  • Queries 
  • Stored Procedures 
  • Relationships
  • Data Types 
  • Security 

Gateways

  • Deployment 
  • Management 
  • Use cases

Custom Visuals

  • Market place visuals 
    • How to use and deploy 
  • D3
    • Implementation and building 

Administration

  • Auditing 
  • Service Health 
  • User Management
  • Capacity management 
  • Workspace management 

Data Visualization

  • Data Analysis 
  • Visual Selection 
  • Understanding Audience
  • Storytelling 
  • Color selection 

Report Management

  • Version control
  • File Sharing/Collaboration 
  • Report CI/CD 
  • Understanding datasets 

Dashboards

  • Building templated dashboards
  • Deploying to the organization 
  • Customization 

Apps

  • Build and deploy to organization 
  • Version control
  • Collaboration 

Security

  • Row Level Security 
  • Dynamic role-based access 
  • Constructing role-based filters
  • Security Groups 
  • Workspace Security 
  • Report/Dashboard security

Custom Tooltips

  • Building
  • Managing 
  • Color and Visualization selection 

DAX

  • Understanding structure 
  • Using variables
  • Nested functions 
  • Use cases
    • Custom Measures 
    • Custom Columns 

 

A Message From the Head Instructors About This Course

Duration 3 to 3
Materials

Manual and supporting materials included

Prerequisites

None

Software Requirements

Power BI Desktop, Internet Access

Get a Quote