Course Code: pbi365
Duration: 14 hours
Prerequisites:

There are no specific requirements needed to attend this course.

Overview:

In this instructor-led, live training, participants will learn how to use Microsoft Power BI to analyze and visualize data using a series of sample data sets.

Format of the Course:

  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.

Course Customization Options

  • To request a customized training for this course, please contact us to arrange.

Audience:

  • Business managers
  • Business analysts
  • Data analysts
  • Business Intelligence (BI) and Data Warehouse (DW) teams
  • Report developers

By the end of this training, participants will be able to

  • Create visually compelling dashboards that provide valuable insights into data.
  • Obtain and integrate data from multiple data sources.
  • Build and share visualizations with team members.
  • Adjust data with Power BI Desktop.
Course Outline:

Introduction

  • Power BI - a unified, real-time business analytics dashboards

Importing and Transforming Data

  • Importing Data
  • Overview of Data Source Options
  • Query Building Best Practices
  • Query Editor Overview
  • Understanding Query Design & the ETL Process
  • Understanding Applied Steps
  • Data Transformations
    • Cleaning data (covers many different methods)
    • Filtering Queries
    • Reducing Columns
    • Reducing Rows
    • Merging Datasets
    • Unpivoting Data
    • Combining Files from a Folder
    • Appending Datasets
    • Creating Columns from Examples
    • Creating Conditional Columns
    • Replacing Values
    • Formating Data
  • Understanding the Value of a DateDim Table
  • Adding a Dynamic Calendar Table
  • Creating & Using Parameters for the Calendar
  • Changing Data Naming Conventions
  • Grouping Queries
  • Introduction to the M Language
  • Using the Power Query Formula bar
  • Understanding and Changing Data Types
  • Handling Different Data Formats
  • Column Profiling & Distribution
  • The Advanced Editor
  • Query Dependencies
  • Checking For Errors & Error Handdling

Data Visualization

  • Authoring in Power BI Desktop
  • Creating reports
  • Interacting with reports
  • Uploading reports to the Power BI Service
  • Revising report layouts
  • Publishing to PowerBI.com
  • Sharing and collaborating with team members

Data Modeling

  • Aquiring data
  • Modeling data
  • Security
  • Working with DAX
  • Refreshing the source data
  • Securing data