top of page

Mon, May 11

|

Mezzo, hotel & business

Power Query - Advanced (2 d)

Want to go to the next level and become an authority in Power Query, this is the training session you don't wan't to miss!

Registration is Closed
See other events
Power Query - Advanced (2 d)
Power Query - Advanced (2 d)

Time & Location

May 11, 2020, 9:00 AM – May 12, 2020, 5:00 PM

Mezzo, hotel & business, Paalsesteenweg 170, 3583 Beringen, Belgium

About the Event

 Training Content

You have been putting Power Query in practice for many months and have encountered many obstacles and roadblocks, this training session helps you to acquire a thorough knowledge and gain deeper insights into the Power Query engine.

• The role of Power Query and the M-language in the Power BI landscape

 ○ Excel 

 ○ PowerBI-models 

 ○ Power BI dataflows 

 ○ Analysis Services 

 ○ Custom Connectors 

 ○ Azure Data Flows 

• M-Language - concepts and architecture

 ○ Evaluation model 

 ○ Expressions and variables, including 'let' 

 ○ Data structures and types

  + Tables 

  + Records 

  + Lists 

  + 'any' 

  + Other data types 

• Custom functions

 ○ The structure of a function 

 ○ Creating functions manually 

 ○ Creating functions through the UI 

 ○ A function in disguise 

• Environments and scope in Power Query

 ○ Global Environment 

 ○ Expression and Variable environments 

 ○ Expression.Evaluate 

• Iteration and Recursion

 ○ Row level function invocation pattern 

 ○ Recursive functions 

 ○ List.Generate 

 ○ List.Accumulate 

• Error Handling

 ○ Try 

 ○ Otherwise 

• Performance

 ○ The Performance Analyzer 

 ○ Query Folding 

 ○ Table.Buffer and List.Buffer 

 ○ Table Keys on joins 

 ○ GroupKind 

 ○ Memory considerations 

• From static to dynamic

 ○ How to plan for change 

 ○ Coding guidelines 

• Organizing queries

 ○ ETL-approach 

 ○ Define once, use many 

 ○ Using parameters 

 ○ Impact on performance 

 Goal

After this session, you will feel confident to face new challenges that previously seemed impossible. You will function as an authority / coach within your company to help colleagues with their projects so they learn from the best.  

 Prerequisites

Own Laptop 💻 + external mouse  

Power BI Desktop (see Microsoft's documentation Get Power BI Desktop). 

You can get Power BI Desktop in two ways, each of which is described in the following sections:

📖 Documentation

Students will get 2-year access to the on-line in2Facts documentation platform

🚫 Cancellations

Cancellations up to 8 days before the training course are at no charge. 

Cancellations after this date, as well as no-shows, will be liable for the full registration fee.

Tickets

  • Early Bird

    This ticket provides access to the professional training classes of the in2Facts Training Academy.

    €1,300.00
  • Trainee

    This ticket provides access to the professional training classes of the in2Facts Training Academy.

    €1,500.00

Total

€0.00

Share This Event

Early Bird Price

€ 650 / day
excl. VAT

First 5 seats are offered at an early bird entrance price.

Price

€ 750 / day
excl. VAT

Also KMO-Portefeuille registered

for providing training services.

Registration nr DV.O217305

Location

Mezzo Hotel - Paal

Perfect location at E313 exit 26 Paal,

just a 5 minute drive from the

cloverleaf (intersection E313 - E314) 

bottom of page