EXCEPTIONAL TRAINING FOR DATA PROFESSIONALS

Power BI - Power Query & M Training Course

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

NEXT COURSE
26 Sep London
request info

Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

Power BI - Power Query & M training course (code: PowerQueryM )

TRAINING COURSE OVERVIEW

Our Power BI (Beyond the Basics) training course for Microsoft Power BI is aimed at Power BI users who are looking to get even more out of this popular tool.

We will show you how to use Power Bi beyond the stage: learn how to administer security, tenants, permission. Use Advanced functionality in PowerQuery to import files, cleanse data & create functions in M Language.

A number of optional topics exist which can be requested for private courses, depending on your organisations business requirements.

AUDIENCE

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...


CONTENT

DETAILHIGHLIGHTS

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

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
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 logs

 

 

  • Advanced Power Query
  • M
  • Power BI Administration

UPDATES
Receive the latest version of this course into your inbox



LONDON COURSES
- INCLUDES LUNCH -

26th Sep 2019 - 1 days £795
Book

see all dates


X

Show Discount for this course


PRIVATE COURSES


  Bring a JBI course to your office
  and train a whole team onsite
  0800 028 6400
or request quote


  You can customise this course to
  suit your exact needs here
  0800 028 6400 or request quote


CONTACT
0800 028 6400



Why JBI ?

►"great technology tips"
► "Access to exclusive content"
► "Short course means less time off"

►"Inspiring trainers"
► "Joined via web"
► "Knowledgable sales staff"

NEWSLETTER
Get exclusive news about upcoming programs, technical insights & special offers