Length: 2 days

Course Description

Microsoft Power BI transforms your company data into rich visuals that facilitate new ways of thinking about and organizing your data, so that you can focus on what is important to achieving your goals. This course covers both Power BI Online and Power BI desktop.

Audience

This course is intended for Business Managers, Report Developers, Analysts, Project Managers and Team Leaders.

Course Objectives

Upon completing this course, students will have a good understanding of the following topics, as well as the ability to utilize and implement the concepts learned.

Power BI

Power BI Desktop

Working with CSV, TXT, and Excel Worksheets

Connecting to Databases

Merging, Grouping, Summarizing, and Calculating Data

Reporting

Power BI Online

Course Outline

Power BI Introduction

  • What is Power BI?
  • Examining Power BI Suite of Products
  • Identifying Differences Between Products
  • Understanding Power BI Updates

Power BI Desktop

  • Installing Power BI Desktop
  • Exploring the Power BI Desktop Interface
  • Utilizing File Types; PBIX vs PBIT
  • Examining Data Sources
  • Discussing Data Refresh
  • Understanding Data Types

Working with CSV, TXT and Excel Worksheets

  • Importing Data
  • Transforming Data
  • Loading Data
  • Appending Operations
  • Working with Folders and Files
  • Using Pivot Tables

Connecting to Databases

  • Working with Relational Data
  • Understanding Relationships
  • Importing from SQL Server Analysis Services Multidimensional and Tabular

Merging, Grouping, Summarizing and Calculating Data

  • Understanding the Issues with Merges
  • Performing Merges
  • Grouping Options
  • Summarizing
  • Calculating

Reporting

  • Creating Reports
  • Utilizing the Matrix Visualization
  • Utilizing the Map Visualization
  • Utilizing the Card Visualization
  • Utilizing the Chart Visualization
  • Utilizing Slicers
  • Publishing to Power BI Online

Power BI Online

  • Introduction to Power BI Online
  • Importing Data
  • Creating Reports
  • Configuring Dashboards
  • Sharing Reports and Dashboards
  • Exploring Power BI Mobile