Microsoft Power BI Part 1

Microsoft Excel Power BI

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. This course is intended for Business Managers, Report Developers, Analysts, Project Managers and Team Leads.


Prerequisites

Excel Part 1, Excel Part 2, Excel PivotTables and Power Tools or equivalent working knowledge.


Learning Objectives

  • Power BI Overview
  • Power BI Desktop User Interface and Navigation
  • Connecting, importing and preparing data for use
  • Merging, Grouping, Summarizing, and Calculating Data
  • Visualizing & Creating Reports
  • Publishing reports for online consumption

Lesson Contents

This module explains how the class will be structured and introduces course materials and additional administrative
information.

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing

In this module, we will explain what Power BI provides, examine the products available and what they bring to the
table, and cover how Power BI updates are provided.

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

In this module, we will examine the steps necessary to install Power BI Desktop, explore the interface, discuss the
available file types, and data sources, and discuss how to configure data refresh settings. We will also cover the
available data types and discuss best practices in utilizing them.

  • 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

In this module, we will examine importing data, transforming data, loading data, and manipulating data using CSV,
TXT, and Excel Worksheets. Power BI handles these files types with ease.

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

In this module, we will discuss why merges have been difficult in the past, examine how much easier they are to
utilize today, and explore grouping, summarizing and calculating options.

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

In this module, we will create a report and examine the visualization options.

  • 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

Coming Fall 2018

This course is not yet scheduled, but we can notify you when it is.

Send Me Updates  

Discount Information
Refund Policy