EXCEPTIONAL TRAINING COURSES FOR IT PROFESSIONALS
LONDON UK | ONSITE | ONLINE


Power BI (advanced) Training Course

NEXT COURSE
17 Sep London
request info

Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

Power BI (advanced) training course (code: PowerBIAdv)

Maximise Power BI's features to create outstanding Visuals and complex Calculations in DAX


SEE MORE COURSES IN THIS CATEGORY

TRAINING COURSE OVERVIEW

Our Microsoft Power BI advanced training course is aimed at seasoned 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.

AUDIENCE

Business Analysts, Financial Analysts, Data Scientists and Staff who already use Power BI and 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...




DETAILHIGHLIGHTS

Advanced visualization

Digital Storytelling
Bookmarks
Selection Pane
Drillthrough
Tool tips page
Visuals with DAX
Use of Custom Visuals
Custom Themes
Multiple pages slicers

Advanced DAX

DAX Basics review
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

Advanced Data modelling

Creating a Bridge Table
Role Playing Tables with DAX
Role Playing Tables without DAX
Mismatched Granularies

Advanced Power Query and M (OPTIONAL)

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

power BI Administration (OPTIONAL)

Data Refresh Overview
Scheduling Data Refresh
Implementing Row Level Security
Implementing Dynamic Security

POWER BI SERVICES (OPTIONAL)

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

* OPTIONAL topics can be added for private courses and may also be added to public courses subject to there being sufficient time left over at the end of the core topics.

 

  • Advanced visualization
  • Advanced DAX
  • Advanced Data modelling
  • Advanced Power Query and M
  • power BI Administration
  • POWER BI SERVICES
Receive the latest version of this course into your inbox


PUBLIC COURSES (LONDON, UK)
 

17th Sep 2018 - 2 days £1300
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


Get in touch
0800 028 6400




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"


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