* COVID-19: 1 Person per Room Health & Safety Policy *


Microsoft Power BI Desktop and Microsoft Power Query Course

Power BI Training Online & Onsite

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

Power BI TrainingMicrosoft Power BI Desktop and Microsoft Power Query

by Certstaffix® Training

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


Power BI Training
This course familiarizes the participant with Microsoft Power Query, a revolutionary data tool for Excel that allows you to intuitively discover and automate the import, transformation, and combination of data across a variety of data sources for use in Excel and Microsoft Power BI. Power Query is a free add-in for Excel that enhances the self-service Business Intelligence experience in Excel. The course uses Excel 2016, however Power Query works with Excel 2010 and above.

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.

  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

The student should be familiar with Excel and the concepts of datasets and basic reporting, including the use of PivotTables.
After completing this course, students will be able to:

Understand the revolutionary changes in Power Query and the ease it provides for Excel pros.
Successfully navigate the Power Query interface.
Understand and properly configure data types.
Understand and perform importing data.
Understand and perform transforming data.
Understand and perform loading data.
Understand and utilize ranges in Excel.
Understand and handle special situations.
Understand and perform appending operations.
Understand and utilize working with folders and files.
Understand and perform combining worksheets.
Understand and utilize PivotTables.
Understand working with relational data.
Understand and perform importing from SQL Server Analysis Services Multidimensional.
Understand and perform importing from SQL Server Analysis Services Tabular.
Understand the issues encountered when performing merges.
Understand and utilize merges.
Understand and utilize loading into Excel.
Understand and utilize loading into Power Pivot.
Understand and utilize loading to Power BI Desktop.
Understand and utilize the data sources available.
Understand and utilize grouping.
Understand and utilize summarizing.
Understand the M interface.
Understand Power Query formulas.

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: INTRODUCTION TO POWER QUERY


In this module, we will explore the Power Query interface and examine the importance of data types and how to properly utilize them.



Lessons



Understanding The Ease That the Revolutionary Changes Afforded by Power Query Provide to the Excel Pro
Examining The Power Query Interface
Configuring Data Types


Lab 1: Introduction to Power Query



Power Query Interface
Understanding Data Types


After completing this module, students will be able to:



Understand the revolutionary changes in Power Query and the ease it provides for Excel pros.
Successfully navigate the Power Query interface.
Understand and properly configure data types.


MODULE 3: WORKING WITH CSV, TXT AND EXCEL WORKSHEETS


In this module, we will explore working with CSV, TXT, and Excel worksheets. We will examine the import process and explore transforming and loading data. We will also cover utilizing ranges and working with large numbers of files and folders, then finish with sections on combining worksheets and utilizing PivotTables.



Lessons



Importing Data
Transforming Data
Loading Data
Using Ranges in Excel
Understanding and Handling Special Situations
Appending Operations
Working with Folders and Files
Combining Worksheets
Using PivotTables


Lab 1: Working with CSV, TXT and Excel Worksheets



Importing, Transforming, and Loading Data
Utilizing Ranges
Understanding and Handling Special Situations
Appending Operations
Working with Folders and Files
Combining Worksheets
Using PivotTables


After completing this module, students will be able to:



Understand and perform importing data.
Understand and perform transforming data.
Understand and perform loading data.
Understand and utilize ranges in Excel.
Understand and handle special situations.
Understand and perform appending operations.
Understand and utilize working with folders and files.
Understand and perform combining worksheets.
Understand and utilize PivotTables.


MODULE 4: CONNECTING TO DATABASES


In this module, we will examine working with databases and walk-through the process of connecting and importing data from these sources.



Lessons



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


Lab 1: Working with Databases



Importing From SSAS Multidimensional
Importing From SSAS Tabular


After completing this module, students will be able to:



Understand working with relational data.
Understand and perform importing from SQL Server Analysis Services Multidimensional.
Understand and perform importing from SQL Server Analysis Services Tabular.


MODULE 5: PERFORMING MERGES


In this module, we will examine the process of merging datasets. We will cover common issues encountered and discuss ways to resolve them.



Lessons



Understanding the Issues
Performing Merges


Lab 1: Performing Merges



Performing Merges


After completing this module, students will be able to:



Understand the issues encountered when performing merges.
Understand and utilize merges.


MODULE 6: LOADING YOUR DATA


In this module, we will examine other places where you can load your data, such as Power BI Desktop. We will cover the options available with each area, and explore the different interfaces.



Lessons



Loading into Excel
Loading into Power Pivot
Loading into Power BI Desktop


Lab 1: Loading Your Data



Importing, Transforming, and Loading Data into Excel and Power Pivot
Introduction to Power BI Desktop
Data Sources


After completing this module, students will be able to:



Understand and utilize loading into Excel.
Understand and utilize loading into Power Pivot.
Understand and utilize loading to Power BI Desktop.
Understand and utilize the data sources available.


MODULE 7: GROUPING AND SUMMARIZING WITH POWER QUERY


In this module, we will cover grouping and summarizing data with Power Query.



Lessons



Grouping Options
Summarizing


Lab 1: Grouping and Summarizing with Power Query



Grouping and Summarizing


After completing this module, students will be able to:



Understand and utilize grouping.
Understand and utilize summarizing.


MODULE 8: WORKING WITH THE POWER QUERY LANGUAGE “M” (OPTIONAL)


In this optional module, we will examine the Power Query Language “M” and the capabilities that the language provides. We will also briefly examine formulas.



Lessons



Understanding the “M” Interface
Examining Power Query Formulas


Lab 1: Working with the Power Query Language “M” (Optional)



None


After completing this module, students will be able to:



Understand the M interface.
Understand Power Query formulas.
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 Desktop and Microsoft Power Query Class Reviews

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



This course familiarizes the participant with Microsoft Power Query, a revolutionary data tool for Excel that allows you to intuitively discover and automate the import, transformation, and combination of data across a variety of data sources for use in Excel and Microsoft Power BI. Power Query is a free add-in for Excel that enhances the self-service Business Intelligence experience in Excel. The course uses Excel 2016, however Power Query works with Excel 2010 and above.



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:

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