Power BI Tools: Get and Transform Data (with M Programming)

Description

Duration: 1 day

This course is for individuals responsible for taking data and turning it into powerful business intelligence solutions. With Power Query you can transform data (by reducing, adding columns, and combining data sets) so that it is setup for additional analysis. Power Query makes “data munging” and “data wrangling” easy for non-programmers working as data scientists.

This course takes an in-depth approach to the Power Query and will provide an introduction to the M language, allowing you to replay a series of transformations. This is helpful when readying data on a weekly, monthly or quarterly basis, saving you time on these repetitive tasks. M Code will also allow you to manipulate data using features that are not accessible via keyboard commands.

Audience
This class is for users of either Power BI , Excel Power Tools, or SQL Server Analysis Services (SSAS). While all three products have a very similar Power Query-related interface, the course will be taught using the Excel 2016 software. Users of Power BI and SQL Server should have no problems with the slight differences between products.

This course is aimed at Excel power-users, Power BI users, BI professionals, and Excel power-users who have a general familiarity with Power Query but need more knowledge and experience to take it to its full potential. Our Power BI Tools: DAX Introduction course is a great complement to this class and is also designed for users of Excel, Power BI or SQL Server.

Prerequisites
While attendees do not need extensive prior experience with DAX formulas, it is recommended that they have taken either Microsoft Power BI Data Analyst OR Power BI Introduction for Excel Users class OR have similar experience.

What’s included?

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands-on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.

Methods

  • Instructor Led (the best training format we offer)
  • Live Online Classroom – Online Instructor Led
  • Self-Paced Video

Speak to an Admissions Representative for complete details

StartFinishPublic PricePublic Enroll Private PricePrivate Enroll
12/25/202312/25/2023
1/15/20241/15/2024
2/5/20242/5/2024
2/26/20242/26/2024
3/18/20243/18/2024
4/8/20244/8/2024
4/29/20244/29/2024
5/20/20245/20/2024
6/10/20246/10/2024
7/1/20247/1/2024
7/22/20247/22/2024
8/12/20248/12/2024
9/2/20249/2/2024
9/23/20249/23/2024
10/14/202410/14/2024
11/4/202411/4/2024
11/25/202411/25/2024
12/16/202412/16/2024
1/6/20251/6/2025

Curriculum

Power Query Overview
Power Query and Power BI
Power Query and Excel
Power Query Concepts
Power Query Walkthrough

Data Sources
Querying Relational Databases
Extracting Data from Files
Using Other Data Sources

Transforming Data with Power Query
Understanding Query Steps
Working with Columns
Filtering Rows
Sorting a Table
Changing Values in a Table
Unpivoting Columns and Rows
Transposing a Table
Creating Custom Columns

Introducing M
Writing M in the Query Editor
Understanding M Language Concepts
Creating Relationships between Tables in the Model
Lists Records and Tables
Functions

Working with Multiple Queries
Using One Query as a Source for Another
Working with Data from Different External data Sources
Appending Data from One Query to Another
Merging Two Queries
Explicit Calculated Field

Appendix: Power Query Recipes
Calculations
Table Transformations
Working with Data from the Web