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!
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
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
○ 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
+ 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
• Iteration and Recursion
○ Row level function invocation pattern
○ Recursive functions
• Error Handling
○ The Performance Analyzer
○ Query Folding
○ Table.Buffer and List.Buffer
○ Table Keys on joins
○ Memory considerations
• From static to dynamic
○ How to plan for change
○ Coding guidelines
• Organizing queries
○ Define once, use many
○ Using parameters
○ Impact on performance
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.
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:
- Install as an app from the Microsoft Store.
- Download directly, as an executable you download and install on your computer.
Students will get 2-year access to the on-line in2Facts documentation platform
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.
This ticket provides access to the professional training classes of the in2Facts Training Academy.€1,300.00
This ticket provides access to the professional training classes of the in2Facts Training Academy.€1,500.00
Early Bird Price
€ 650 / day
First 5 seats are offered at an early bird entrance price.
€ 750 / day
Also KMO-Portefeuille registered
for providing training services.
Registration nr DV.O217305
Mezzo Hotel - Paal
Perfect location at E313 exit 26 Paal,
just a 5 minute drive from the
cloverleaf (intersection E313 - E314)