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.
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...
Merge and Append queries
Create a blank Query
Create a custom table
Enter data manually
Create a table using M coding
Columns from example
The M Syntax
M language reference table
M Query Basics
Variables and Parameters
Parametrize data source
Create M Query Functions
Automate import using M function
Create date table using M
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 and direct query
What Gateway do
Data at rest
Data in Use
Data in Transit
Security Users access
Implementing Row Level Security
Implementing Dynamic Security
Manage custom visuals
Manage user licence
Manage Group and workspaces
Receive the latest version of this course into your inbox
08/02/2018: Power BI is an excellent visualization tool, released by Microsoft in June 2015 and updated every month since then. It’s relatively cheap compared...
24/04/2019: Power BI is extending and integrating more and more with advances Data Analysis. In this article we will show some examples of how you can use...
20/12/2018: Python or R in tomorrow’s world? Python and R are popular programming languages extensively used by data scientists today. But what about tomorrow...
18/12/2017: The Client A leading developer and manufacturer of sophisticated industrial products, abatement solutions and related value-added services. Their...
19/10/2017: A leading Financial Services organisation was keen to get several of its teams working consistently in an "Agile" way. Agile is an iterative...
13/10/2017: This organisation needed their Supply Chain department to get fully involved with Microsoft’s Power BI reporting product as soon as possible....
Bring a JBI course to your office
and train a whole team onsite
0800 028 6400 or request quote
0800 028 6400
Why JBI ?
"great technology tips"
"Access to exclusive content"
"Short course means less time off"
"Joined via web"
"Knowledgable sales staff"
Subscribe to our Newsletter – Receive the latest info on Tech courses & insights Subscribe