CUSTOMISED
Expert-led training for your team
Dismiss

Power BI - Power Query & M training course

Use Advanced functionality in Power Query to import files, cleanse data, create functions in M Language

JBI training course London UK

“Learning more about the query editor was very useful and especially the merge tables features. The Bookmarks section was very good and it was nice to see some really good examples of how it can be used to present your work. The presenter was very helpful and had great knowledge of Power BI."

AG, Business Analyst, Power Query & M, January 2021

Watch live Client feedback - Python & Power BI training courses: 


Public Courses

28/10/24 - 1 days
£795 +VAT
09/12/24 - 1 days
£795 +VAT
20/01/25 - 1 days
£795 +VAT

Customised Courses

* Train a team
* Tailor content
* Flex dates
From £1200 / day
EDF logo Capita logo Sky logo NHS logo RBS logo BBC logo CISCO logo
JBI training course London UK

  • Acquire skills in advanced Power Query to merge, create and append queries
  • Explore advanced functionality in Power Query to import files, cleanse data & create functions in M Language
  • Learn to parametrize data sources to define parameters that you can use in various ways when working with your data
  • Use M language and explore M functions to create a table with M coding  
  • Use Power BI Administration to Schedule Data and Refresh Data
  • Learn about licencing and Gateway
  • Understand how to administer security, tenants and permission
  • Acquire knowledge on how to implement and apply security

An exercise from DAX programming part of Power BI training course.  

Advanced Power Query

  • Merge and Append queries
  • Create a blank Query
  • Create a custom table
  • Enter data manually
  • Create a table using M coding
  • Conditional column
  • Multi-condition column
  • Columns from example

M Language

  • The M Syntax
  • M language reference table
  • M Query Basics
  • Variables and Parameters
  • Parametrize data source
  • Create M Query Functions
  • Invoke functions
  • Automate import using M function
  • Create date table using M

Power BI Administration

  • Data Refresh When, Who, What
  • Gateway : overview, installation, when needed
  • Which connection require a Gateway and which do not
  • Scheduling Data Refresh
  • Data refresh and licencing
  • Gateway: personal mode and Enterprise mode
  • Gateway: prerequisites
  • Gateway installation
  • Gateway Configuration
  • Gateway and direct query
  • What Gateway do
  • Security
  • Data at rest
  • Data in Use
  • Data in Transit
  • Security Users access

 (Cont...)

  • Implementing Row Level Security
  • Implementing Dynamic Security
  • Administration portal
  • Usage metrics
  • Users administration
  • Tenant settings
  • Embedded code
  • Manage custom visuals
  • Global administrator
  • Manage user licence
  • Manage Group and workspaces
  • Audit log
JBI training course London UK

Business Analysts, Financial Analysts, Data Scientists and Staff who already use Power BI or who have attended our introduction course and who need to explore its features in more depth. Developers and Super Users/ Power Users looking to get more out of Power BI.

Learn to build Dashboards like this mixing and matching different data sources and filter access through dynamic security - Typically used for CFO Dashboards, Revenue & Profitability, Expense Management, Financial Planning & Analysis, Sales, Stock Control, Risk & Compliance Analysis...

 


5 star

4.8 out of 5 average

“Learning more about the query editor was very useful and especially the merge tables features. The Bookmarks section was very good and it was nice to see some really good examples of how it can be used to present your work. The presenter was very helpful and had great knowledge of Power BI."

AG, Business Analyst, Power Query & M, January 2021

Watch live Client feedback - Python & Power BI training courses: 




“JBI  did a great job of customizing their syllabus to suit our business  needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and  the Instructor handled this particularly well - very impressive”

Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022

 

 

JBI training course London UK
 
Top 20 "Pain Points" for Data Analysts
 

Problem 11 : You have a very complex Excel spreadsheet and you want to reproduce EXACTLY the same spreadsheet in Power BI
Solution: Power BI is not Excel, it works differently and it has different strengths. In order to tackle this issue the best way is going back to the source and try to...

All 20 points are in our latest Newsletter - Delivered directly to your inbox



Our Power BI - Power Query and M training course for Microsoft Power BI is aimed at Power BI users who want to get even more out of this popular tool.

We will show you how to use Power BI to administer security, tenants and permission. You will also use advanced Power Query functionality to import files, cleanse data and create functions in M Language.

CONTACT
+44 (0)20 8446 7555

[email protected]

SHARE

Corporate Policies     Terms & Conditions
JB International Training Ltd  -  Company number 08458005

Registered address Wohl Enterprise Hub 2B Redbourne Avenue London N3 2BS

POPULAR

Rust training course                                                                          React training course

Threat modelling training course   Python for data analysts training course

Power BI training course                                   Machine Learning training course

Spring Boot Microservices training course              Terraform training course

Kubernetes training course                                                            C++ training course

Power Automate training course                               Clean Code training course