Microsoft Power BI - Desktop and Microsoft Power Query Course

Course Details:

Length: 1 day

Price: $640/person (USD)

Bundle & Save: View Bundle

Group Price: Request Quote

Training Reviews

Course Features:

Live Instructor Teaching

Certificate of Completion

Digital Badge

Courseware: Print

Free 6 Month Online Retake

Hands-On Learning?: Yes

Software Lab Included?: Yes

Delivery Methods:

Live Online

Individuals and Groups
@ Your Location

Onsite for Teams

Group Teams
@ Your Organization

This is an instructor-led course. It is taught by an instructor live online or at organizations for groups.
For team training, we can teach onsite at your office or private live online.


Course Overview

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.

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.

Register Early: Registration Deadline is 2 Weeks Prior to Class Start.

Course Notes

Knowledge Prerequisites

• The student should be familiar with Excel and the concepts of datasets and basic reporting, including the use of PivotTables.

Course Topics

Course FAQs

What Are the Available Class Formats?

This course is taught by a live instructor and is available in two class formats:

  1. Live Online for Individuals
  2. Onsite/Online for Private Groups

What Is Power BI Power Query?

Power BI Power Query is a powerful data mashup and transformation tool that enables users to quickly gather, transform, integrate, and analyze data from multiple sources. It helps users create meaningful insights for their business decisions as it simplifies the process of combining and refining data from different sources. With Power BI Power Query, users can combine, filter, and shape data from multiple sources into datasets that can be used in the Power BI Desktop application. This ultimately allows users to quickly understand their data and make informed business decisions. Additionally, its intuitive drag-and-drop interface makes it easy for users to interact with the data and create visually compelling reports with ease. With Power BI Power Query, organizations are better equipped to make more informed business decisions and uncover insights faster.

What Are Power BI Power Query Data Options For: CSV, Text and Excel Sheets?

Power BI Power Query offers data import and transformation options for a variety of sources. CSV, text, and Excel sheets are just some examples of the different file types that can be connected to Power Query to extract and clean up data before loading it into your Power BI report.

For each type of file mentioned above, there are several methods available to connect the data and transform it into a dashboard-ready state. CSV files are generally considered one of the most straightforward ways to import data. All you have to do is select the file from your local directory, select delimiter type (if applicable), and let Power Query do the rest! Text files can also be imported into Power Query as long as the data is properly formatted. In addition, you can load Excel sheets and perform certain operations on them such as filtering and sorting.

Regardless of which type of file you choose to use with Power Query, it's important to remember that all data must be in a format that Power BI recognizes before it can be imported into your report. It's always a good idea to take some time to ensure that your data is properly formatted and structured before beginning any analysis. Power Query makes it easy to clean up your data so that you can spend more time focusing on insights rather than data wrangling.

What Are Power BI Power Query Database Options?

Power BI Power Query offers a wide range of database options to help you connect and analyze data. You can easily access data from various sources, such as databases, files, online services, and more. Power Query also allows you to transform your data before loading it into the Power BI dashboard for further analysis. Some of the commonly used database options include Microsoft SQL Server, Oracle Database, Microsoft Access, IBM DB2, and PostgreSQL. In addition to these popular database options, Power Query also supports a wide range of other data sources such as Excel files and text files. With the help of Power Query, you can easily connect to various databases quickly and efficiently without any hassle. This makes your data analysis process easier and more efficient. With the help of Power Query, you can easily access data from various sources and transform it into meaningful insights in no time. For businesses, this can be a great tool to make informed decisions quickly.

What Are Power BI Power Query Data Merge Functions?

Power BI Power Query data merge functions allow users to join and merge various data sources into a single dataset. This enables integration and analysis of disparate datasets from different sources, giving the user greater control over analyzing their data. The merge function allows for multiple join types including left, right, inner, outer and full, which enables users to combine data sets according to their specific requirements. Additionally, the function supports important features such as concatenation and aggregation, enabling users to create a powerful set of data points for further analysis. With these powerful capabilities, Power BI data merge functions allow users to analyze large and complex datasets together with ease. By combining multiple data sources into one, users can quickly and accurately analyze trends, identify correlations and gain better insights into their data. This helps businesses leverage their data to make smarter decisions.

What Are Data Loading Options Into Power BI From: Excel, Power Pivot and Power Bi Desktop?

Power BI can be used to quickly load data from Excel, Power Pivot, and Power BI Desktop. This allows users to easily access their data and create powerful visuals of it.

To load data from Excel, simply select "Get Data" on the Home tab of the Power BI ribbon to launch the Get Data dialog box. From there, select Excel from the list of data sources to import datasets directly from Excel.

Power Pivot is another tool available to access Power BI. It has a user-friendly interface that allows users to quickly create and manage data models with multiple tables and relationships within them. To load data into Power BI using Power Pivot, simply open the Power Pivot window, select the tables you want to import, and then click "OK".

Finally, Power BI Desktop provides an effective way to access your data stored in a local or network drive. To use this feature, simply launch Power BI Desktop and select the file that contains your data, and press "Load" in the upper right corner.

By using these three data loading options in Power BI, users can easily access their data and create powerful visuals with it. These functions are fast, easy to use, and help to make the most of your data.

What Are Power BI Power Query Grouping and Summarizing Features?

Power BI's Power Query grouping and summarizing feature allows you to group data quickly and easily. This feature can be used to create a summary of your data, such as totals, averages, counts, and other aggregate functions. With this powerful tool, you can also transform your data into a more meaningful format for easier analysis. This feature is especially useful for large datasets, as it can rapidly summarize the data and make it easier to digest. Additionally, grouping and summarizing in Power Query allow users to apply multiple functions on the same dataset without having to break them out into separate queries. This makes such tasks much more efficient, allowing users to get the most out of their data.

Overall, Power BI's Grouping and Summarizing feature provides a powerful way to quickly summarize your data and make it easier to analyze. By leveraging this tool, users can gain valuable insights from their data in the shortest amount of time possible.

What Is the Power BI Power Query Language "M"?

The Power BI Power Query Language "M" is a powerful data mashup language designed for the manipulation and transformation of data stored in various sources. It provides a wide range of features, such as the ability to create custom columns and functions, as well as join multiple datasets together. The language has an easy-to-understand syntax and can be used to connect to a variety of data sources, such as Excel, text files, and databases. Additionally, it offers an extensible library of functions for manipulating and transforming data more efficiently. All in all, M provides powerful capabilities for working with data and is a valuable tool for Power BI users.

Related Power BI Information:

How Much Do Power BI Training Courses Cost?

Public instructor-led Power BI course prices start at $620 per student. Group training discounts are available.

Self-Paced Power BI eLearning courses cost $600 at the starting point per student. Group purchase discounts are available.

What Power BI Skills Should I Learn?

A: If you are wondering what Power BI skills are important to learn, we've written a Power BI Skills and Learning Guide that maps out Power BI skills that are key to master and which of our courses teaches each skill.

Read Our Power BI Skills and Learning Guide

What is the best course to learn Power BI?

A: There are many different courses available to learn Power BI, depending on your learning style and needs. For those who prefer to learn online, Certstaffix Training offers both online live and eLearning classes that can be taken at your own pace. For groups, we offer onsite training face-to-face which can be customized to meet your specific needs. No matter what route you choose, our experienced instructors will ensure that you gain the skills and knowledge you need to confidently use Power BI.

How long will it take to learn Power BI?

A: There is no one-size-fits-all answer to this question, as the amount of time it takes to learn Power BI will vary depending on your prior experience and level of expertise. However, we can say that our Power BI training classes are designed to help you gain a comprehensive understanding of the software in a relatively short amount of time - a few days. The key after completing our training or other online resources like tutorials or videos, is to keep practicing to maintain and grow your Power BI skills.

Whether you choose to take our online or group onsite Power BI classes, you can be confident that you will receive the quality instruction needed to become a proficient Power BI user.

Is Power BI difficult to learn?

A: No, Power BI is not difficult to learn. Certstaffix Training provides classes online and onsite for corporate groups that can help you get started with Power BI quickly and easily. Our experienced instructors will guide you through the process of creating powerful data visualizations, so you can make better decisions for your business.

There are other ways to learn Microsoft Power BI than attending classes. You can watch video tutorials, read manuals, and attend webinars. If you prefer to learn on your own, these are great options. However, if you want more hands-on help or want to learn with others, consider attending a Power BI class. Certstaffix Training offers online and team onsite classes that are taught by experienced instructors who will help you get up and running with Power BI quickly. Sign up today and see how easy it is to get started with this powerful data visualization tool.

Is coding required for Power BI?

A: No, coding is not required for Power BI. Knowledge of SQL querying is helpful, but not required for basic tasks. Certstaffix Training provides classes online and onsite that can help you get started with this business intelligence tool. Power BI training classes can provide you with the skills you need to create reports and visualizations to help you make better decisions for your business. Contact Certstaffix Training today to learn more about our Power BI training options.

What are the top Power BI skills?

A: The top Power BI skills include the ability to collect and analyze data, create visualizations and reports, and effectively communicate findings. In addition, Power BI users should have a strong understanding of statistical methods and be able to apply them to real-world scenarios. Furthermore, it is important for Power BI users to be able to work with complex data sets and be able to understand the relationships between different data points. Finally, Power BI users should have the ability to effectively communicate their findings to others.

Top Power BI Skills

1. Data modeling

2. Data visualization

3. DAX (Data Analysis Expressions)

4. Query editing

5. Report authoring

6. Custom visualization

7. Collaboration and sharing

8. Support and maintenance

9. Training and documentation

10. Project management

These are just some of the skills that are necessary to use Power BI effectively. If you want to be a power user, it is recommended that you master all of them.

Where Can I Learn More About Power BI?

Power BI Blogs

Power BI User Groups

Power BI Online Forums

Explore Power BI Training Classes Near Me:



Have a Group?
Request Private Training

7/7/2023 10:00:00 AM
Online Class

Registration Deadline - 06/20/2023


8/17/2023 10:00:00 AM
Online Class

Registration Deadline - 08/01/2023


9/28/2023 10:00:00 AM
Online Class

Registration Deadline - 09/12/2023


11/9/2023 10:00:00 AM
Online Class

Registration Deadline - 10/24/2023


12/18/2023 10:00:00 AM
Online Class

Registration Deadline - 12/03/2023

Start your training today!