* COVID-19: All Public Classes are Running Live Online *


Microsoft Power BI Interactive Data Visualizations Course

Available: Live Online or Onsite. Private Training For Groups.

Attend Our Classes From Home - No Software Needed - Learn More...

Power BI TrainingMicrosoft Power BI Interactive Data Visualizations

by Certstaffix® Training

Length: 2 day(s)      Public Class Price: $1240/person (USD)      Group Class Price: Request Quote      Course Category: Power BI


Power BI Training
Microsoft Power BI transforms your company data into rich visuals that facilitate new ways of thinking about andorganizing your data, so that you can focus on what is important to achieving your goals. This course covers bothPower BI On Line and Power BI desktop.
Course Description: Print It | Download PDF | Email It

  Public Classes - Live Online at Your Location or OursHow It Works

Certstaffix® Training public classes are instructor-led, live online training you attend from your home or work or in one of our local computer labs. Our live online instructors teach you from a remote location while being able to interact with students as in a traditional classroom setting.

  • A real, live instructor teaching you from another location
  • Hands-on learning with the software/skills you are being taught
  • Interaction with all students in the class at other locations
  • Any needed software for class provided in online lab environment
  • Easy assistance from the instructor

Click a class date below to register & view location/attendance options.
Registrations received less than 15 days before start will be provided an eBook while print book ships.

 Register ➥   June 1, 2020     
 Register ➥   July 16, 2020     

  Group Classes for Organizations - Onsite or Online How It Works

Have a group of employees needing the same training? Onsite training at your office or group live online classes are great solutions.  

  • An expert Instructor will either come to your office or deliver a private live online class to your students
  • Course can be customized to your training needs
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 4 weeks lead time to arrange a training session

  Detailed Course Topics

Course Description: Print It | Download PDF | Email It

Course Topics

AUDIENCE

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

AT COURSE COMPLETION

Upon completing this course, students will have a basic understanding of the topics below, as well as an 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

MODULE 1: COURSE OVERVIEW


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


Lessons

Introduction
Course Materials
Facilities
Prerequisites
What We'll Be Discussing


Lab 1: COURSE OVERVIEW

None
After completing this module, students will be able to:

Successfully log into their virtual machine.
Have a full understanding of what the course intends to cover.


MODULE 2: POWER BI



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.


Lessons

What is Power BI?
Examining Power BI Suite of Products
Identifying Differences Between Products
Understanding Power BI Updates
Lab 1: POWER BI

None
After completing this module, students will be able to:

Understand Power BI.
Understand the differences between products.
Understand Power BI updates.


MODULE 3: POWER BI DESKTOP



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.


Lessons

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
Lab 1: POWER BI DESKTOP

Introduction to Power BI
After completing this module, students will be able to:

Understand and utilize installing Power BI Desktop.
Understand and utilize PBIX and PBIT file types.
Understand data sources, data refresh, and data types.


MODULE 4: WORKING WITH CSV, TXT AND EXCEL WORKSHEETS



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.


Lessons

Importing Data
Transforming Data
Loading Data
Appending Operations
Working with Folders and Files
Using Pivot Tables
Lab 1: WORKING WITH CSV, TXT AND EXCEL WORKSHEETS

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


After completing this module, students will be able to:

Understand and utilize importing, transforming, and loading data.
Understand and utilize appending operations.
Understand and utilize working with folders and files.
Understand and utilize using Pivot Tables.


MODULE 5: CONNECTING TO DATABASES



In this module, we will explore the process of connecting to databases and also examine relationships.


Lessons

Working with Relational Data
Understanding Relationships
Importing from SQL Server Analysis Services Multidimensional and Tabular
Lab 1: CONNECTING TO DATABASES

Importing From SQL Server and Examining Relationships
Importing From SSAS Multidimensional
After completing this module, students will be able to:

Understand and utilize importing from SQL Server and examining relationships.
Understand relationships.
Understand and utilize importing from SSAS Multidimensional.


MODULE 6: MERGING, GROUPING, SUMMARIZING, AND CALCULATING DATA



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.


Lessons

Understanding the Issues with Merges
Performing Merges
Grouping Options
Summarizing
Calculating
Lab 1: MERGING, GROUPING, SUMMARIZING, AND CALCULATING DATA

Performing Merges
Grouping and Summarizing
Calculating
After completing this module, students will be able to:

Understand and utilize performing merges.
Understand and utilize grouping and summarizing.
Understand and utilize calculating.


MODULE 7: REPORTING



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



Lessons

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
Lab 1: 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
After completing this module, students will be able to:

Understand and utilize creating reports.
Understand and utilize the matrix visualization.
Understand and utilize the map visualization.
Understand and utilize the card visualization.
Understand and utilize the chart visualization.
Understand and utilize slicers.
Understand and utilize publishing to Power BI Online.


MODULE 8: POWER BI ONLINE



In this module, we will explore what Power BI Online is and examine the features available, then discuss mobile
options.


Lessons

Introduction to Power BI Online
Importing Data
Creating Reports
Configuring Dashboards
Sharing Reports and Dashboards
Exploring Power BI Mobile
Lab 1: POWER BI ONLINE

Exploring the Power BI Online Interface
Importing Excel (.xlsx or .xlsm), Comma Separated Value (.csv), and Power BI Desktop (.pbix) Files
Creating a Report
Adding Filters to a Report
Adding KPIs to a Report
Creating a Dashboard
Pinning Tiles
After completing this module, students will be able to:

Understand and utilize exploring the Power BI Online interface.
Understand and utilize importing data.
Understand and utilize creating reports.
Understand and utilize adding filters to a report.
Understand and utilize adding KPI’s to a report.
Understand and utilize creating a dashboard.
Understand and utilize pinning tiles.
Course Description: Print It | Download PDF | Email It

Public Class Format

Certstaffix® Training public classes are instructor-led live online training you attend either from your home/work location or in one of our computer labs. Our live online instructors teach you from a remote location while being able to interact with you like in a traditional classroom.


Quality Instructors

Our instructors have many years of experience teaching adult learners in person and online.

Complete Lab Environment

Access to software required is provided in a lab environment during class.

Hands-on Learning

Most classes are not all lecture - you can learn by actually doing.


Small Classes

You get more attention from the instructor and classes flow more smoothly.

Post-Class Lab Access*

Access practice lab environment for 180 days after most classes*.


Low Cancellation Rate

Most classes run as scheduled.



*These courses do not have post-class lab environment access: Adobe, Salesforce, QuickBooks Online Edition, Google, HTML, WordPress, ITIL, Six Sigma, CompTIA, Project Management, SEO, Social Media.


Group Training

Have a group of employees needing the same training? Onsite training at your office or group live online classes are great solutions.

How Group Training Works





  • An expert Instructor will either come to your office or deliver a private live online class to your students
  • Course can be fully customized to your training needs
  • Each student receives a Course Manual with Practice Files (Materials provided before the class date)
  • If a course has a hands‐on lab, we provide access to the configured course software and files.
    (Requires a high‐speed internet connection and certain open ports on your firewall. You can perform a Connection Assessment Test here)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 4 weeks lead time to arrange a training session
  • Training is completed in a convenient session(s) of your choosing
  • Two 15 minute breaks and one hour long break for lunch daily

Request a Free Quote

Microsoft Power BI Interactive Data Visualizations Class Reviews

Here are a sample of Power BI class reviews from past students that have attended our Power BI training courses.



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


Certstaffix® Class Reviews

Student Average:
4.68 out of 5 from 12 students

4.78 out of 5

The instructor was amazing and very knowledgeable.


- attended our Microsoft Power BI Desktop and Microsoft Power Query class

5.00 out of 5

Only consideration is this specific class may need more than just 8 hours to cover it. Richard Deolker is very knowledgeable and able to cater tone of instruction to how the class members will likely use the software.


- attended our Microsoft Power BI Desktop and Microsoft Power Query class

4.35 out of 5

It was a good class. I would prefer to have an Excel class separate from a PowerBI class. I could have spent the entire day in PowerBI.


- attended our Microsoft Power BI Desktop and Microsoft Power Query class

5.00 out of 5

Candyce Mairs is GREAT!!! THANK YOU!!


- attended our Microsoft Power BI Interactive Data Visualizations class

4.35 out of 5


- attended our Microsoft Power BI Interactive Data Visualizations class

4.39 out of 5


- attended our Microsoft Power BI Desktop and Microsoft Power Query class

5.00 out of 5


- attended our Microsoft Power BI Online class

4.91 out of 5


- attended our Microsoft Power BI Interactive Data Visualizations class

4.83 out of 5


- attended our Microsoft Power BI Interactive Data Visualizations class

5.00 out of 5


- attended our Microsoft Power BI Interactive Data Visualizations class

4.00 out of 5


- attended our Microsoft Power BI Interactive Data Visualizations class

4.56 out of 5


- attended our Microsoft Power BI Desktop and Microsoft Power Query class



Please contact us if we do not yet have any reviews or you would like more.


View all Power BI training reviews

Power BI Courses By City:

BC - Vancouver       HI - Honolulu       NC - Winston-Salem       QC - Montreal      
CA - Bakersfield       IA - Des Moines       ND - Bismarck       RI - Providence      
CA - Fresno       IA - Iowa City       ND - Fargo       SC - Greenville      
CA - Los Angeles       ID - Boise       NE - Lincoln       SC - Myrtle Beach      
CA - Merced       IL - Chicago       NE - Omaha       SC - North Charleston      
CA - Modesto       IL - Rockford       NH - Bedford       SD - Sioux Falls      
CA - Napa       IN - Bloomington       NJ - Bridgewater       SK - Regina      
CA - Oakland       IN - Evansville       NM - Albuquerque       SK - Saskatoon      
CA - Oxnard       IN - Fort Wayne       NM - Las Cruces       TN - Chattanooga      
CA - Rancho Cucamonga       IN - Indianapolis       NM - Santa Fe       TN - Knoxville      
CA - Sacramento       IN - South Bend       NS - Halifax       TN - Memphis      
CA - Salinas       KS - Overland Park       NV - Henderson       TN - Nashville      
CA - San Diego       KS - Topeka       NV - Reno       TX - Amarillo      
CA - San Jose       KY - Lexington       NY - Albany       TX - Austin      
CA - Santa Maria       KY - Louisville       NY - Buffalo       TX - Beaumont      
CA - Santa Rosa       LA - Baton Rouge       NY - New York City       TX - Corpus Christi      
CA - Stockton       LA - Lafayette       NY - Rochester       TX - Dallas      
CB - Caribbean       LA - New Orleans       NY - Syracuse       TX - El Paso      
CB - Kingston       LA - Shreveport       OH - Beaver Creek       TX - Fort Worth      
CB - Nassau       MA - Burlington       OH - Cincinnati       TX - Houston      
CO - Boulder       MA - Springfield       OH - Cleveland Heights       TX - Killeen      
CO - Colorado Springs       MA - Westborough       OH - Columbus       TX - Laredo      
CO - Denver       MB - Winnipeg       OH - Toledo       TX - Longview      
CT - Cheshire       MD - Largo       OH - Youngstown       TX - Lubbock      
CT - New Haven       MD - Laurel       OK - Oklahoma City       TX - McAllen      
CT - Stamford       ME - Portland       OK - Tulsa       TX - Midland      
DE - Wilmington       MI - Ann Arbor       ON - Ottawa       TX - San Antonio      
FL - Daytona Beach       MI - Flint       ON - Toronto       TX - Tyler      
FL - Fort Lauderdale       MI - Grand Rapids       OR - Beaverton       TX - Waco      
FL - Fort Myers       MI - Lansing       OR - Bend       UT - Ogden      
FL - Gainesville       MI - Livonia       OR - Eugene       UT - Salt Lake City      
FL - Jacksonville       MN - Minnetonka       OR - Medford       VA - Charlottesville      
FL - Lakeland       MO - Columbia       OR - Salem       VA - Glen Allen      
FL - Miami       MO - St. Louis       PA - Allentown       VA - Harrisonburg      
FL - Naples       MS - Biloxi       PA - Erie       VA - Roanoke      
FL - Pensacola       MS - Jackson       PA - Harrisburg       VA - Virginia Beach      
FL - Sarasota       MT - Billings       PA - Malvern       VT - Burlington      
FL - Tallahassee       MT - Montana       PA - Philadelphia       WA - Seattle      
FL - Tampa       NB - Moncton       PA - Pittsburgh       WA - Spokane      
FL - Winter Park       NB - Saint John       PA - Reading       WI - Eau Claire      
GA - Augusta       NC - Asheville       PA - Scranton-Wilkes Barre       WI - Green Bay      
GA - Columbus       NC - Charlotte       PA - York       WI - Madison      
GA - Peachtree Corners       NC - Greensboro       PR - Puerto Rico       WI - Milwaukee      
GA - Savannah       NC - Raleigh