Power Query for Excel and Power BI

Description

All self-service BI solutions start by downloading data from external sources and prepare them for further analysis. Power Query is exactly for that. With the help of this tool, available as a add-in to an Excel spreadsheet and console component of Power BI Dashbord, the business user can independently download, convert and save the data, needed to daily analysis. This course has been prepared just for users of Business Intelligence systems.

Options

  • Course level: 300
  • Start date: as required
  • Duration time: 2 days

Price: 2800 zł

  • Open training
  • On-site (costumer's premises)
  • Customer’s computer

Class

The course is addressed to managers of all levels and business users, including analytics. Its participants will be given the practical overview of the most important, but often forgotten newest Microsoft Bi technologies — Power Query.

Plan

The basic training is comprised of 8 modules. Just like all the other courses on our offer, it has been designed by our experts, therefore we can freely customize it to suit the individual needs of the participants.  We would like to encourage you not only to choose modules which you find relevant for your needs, but also to feel free to contact us with your suggestions and questions you would like to hear answered during the course.
Our trainings are unique also because we limit the time set aside for laboratory type classes customarily conducted after the completion of each module, to the benefit of exercises done with the assistance of the trainer and demonstrations. We believe in this manner we can equip you with substantially more practical information and tips, and focus on dealing with the issues directly within your scope of interest. However, each day of the training is finished with a laboratory class of approximately 1hr, so that you can do self-practice and do exercises of your choice.

Modules

Duration: Level:
Module 1

Overview of Power Query
  • What it does and how it fits into the wider Power BI stack
  • Introduces the Power Query user interface

90 minutes 300
Module 2

Extracting data from all of the supported data sources
  • Querying Relational Databases
  • Extracting Data from Files
  • Working with Folders and Multiple Files
  • Scraping Data from Web Pages
  • Using Other Queries as Data Sources
  • Working with Data from Azure

120 minutes 300
Module 3

Transforming Data with Power Query
  • Queries and Steps
  • Working with Columns
  • Data types
  • Filtering Rows
  • Sorting a Table
  • Changing Values in a Table
  • Aggregating Values
  • Creating Custom Columns

180 minutes 300
Module 4

Data Destinations
  • Advantages of Using the Excel Data Model
  • Loading Data to the Excel Data Model
  • Power Query and Table Relationships
  • Refreshing Queries

90 minutes 300
Module 5

Introduction to M
  • Writing M in the Query Editor
  • M Language Concepts
  • Expressions, Values, and Let statements
  • Trapping Errors
  • Conditional Logic
  • Lists
  • Records
  • Tables
  • Selection and Projection
  • Functions
  • Query Folding

180 minutes 400
Module 6

Working with Multiple Queries
  • Parametrized Queries
  • Working with data from different Data Sources
  • Appending Data from Other Query

60 minutes 300
Module 7

Power Query and Power BI for Office 365
  • Power BI Overview
  • Power BI building blocks: Dashboards, Reports and Datasets
  • Visualizations
  • Power BI Desktop
  • Sharing Queries

60 minutes 300
Module 8

Power Query Recipes
  • Calculations
  • Table Transformations
  • Working with Web Datas
  • Working with multiple data sources

60 minutes 400

Form

Ask Question

Register