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

Overview This course is for individuals responsible for taking data and turning it into powerful business intelligence solutions.

1 DayLive Online & In-CenterInstructor-led since 1983Course Code: BPQM01

Course overview

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.

Who this is for

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 attended either ` Microsoft Power BI Data Analyst

OR Power BI Introduction for Excel Users

OR have similar experience.

Course outline

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

Download outline as PDF →

$495

Live Online & In-Center