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's functionality to produce stunning visuals and how DAX can be used in order to create complex calculations which will allow you flexibility beyond that offered by the standard toolset.
A number of optional topics exist which can be requested for private courses, depending on your organizations 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 - Typically used for CFO Dashboards, Revenue & Profitability, Expense Management, Financial Planning & Analysis, Sales, Stock Control, Risk & Compliance Analysis...
Data Models
Relationships
Design Reports
Visualisation & Custom Visualisation
Power Query : Transforming Data & Combining Data Set
Basic DAX
Power BI Service : Publish & Share
Digital Storytelling
Bookmarks
Selection Pane
Drillthrough
Tool tips page
Visuals with DAX
Use of Custom Visuals
Custom Themes
Multiple pages slicers
Table Functions
Evaluation Contexts o Filter and Row Context o CALCULATE
Evaluation Contexts and Relationships
Time Intelligence Calculations
DAX as a Query Language: use of DAX Studio
Advanced Table Functions
Advanced Evaluation Context DAX (Understanding Cross filters)
Calculations over Hierarchies
Parent/Child Hierarchies
Creating Dynamic titles
Using parameter table
Capturing and debugging queries with Dax Studio
Creating a Bridge Table
Role Playing Tables with DAX
Role Playing Tables without DAX
Mismatched Granularies
Create tables
Custom Column, conditional column, column from example
M language:
The M Syntax
M Query Basics
Variables and Parameters
Expanding Lists
M Query Functions
Create date table using M
Gateway : Usage and Installation
Data Refresh Overview
Scheduling Data Refresh
Implementing Row Level Security
Implementing Dynamic Security
Sharing your reports and dashboards:
Collaborating with co-workers in app workspaces.
Publishing app to a larger group or your whole organization.
Publishing to the web
Printing and exporting dashboards and reports
Upload report in SSRS 2016 (or later)
Power BI Report Server (Premium)
Power Bi embedded
B2B
See why people choose JBI
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...
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...
10/12/2018: Natural Language Processing is right at the cutting-edge of Artificial Intelligence, and the handling of data is critical to its success. Computers,...
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....
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
Get in touch
0800 028 6400
Power BI
Power BI - Beyond the Basics
Power BI - Dax in a Day
Power BI - Admin Power Query & M
Power BI - Advanced Visualisation
Tableau
Excellent feedback, consistently !
"great tips help reduce build times"
"we got access to exclusive content"
"Short course meant less time off"
"what an inspiring trainer !"
"colleagues at 2 sites joined via web"
"I passed my exam the next day"
Subscribe to our Newsletter – Receive the latest info on Tech courses & insights Subscribe