Power BI - Beyond the Basics training course

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

NEXT COURSE 18 December (3 days £1650 + VAT) BOOK NOW

JBI training course London UK

  • Apply DAX functions to build formulae and expressions in Power BI
  • Explore Power BI's functionality to produce stunning visuals
  • Leverage Dax Studio to write, execute, and analyze DAX queries in Power BI Designer
  • Learn how Power Query helps to connect to one or many data sources, shape and transform the data
  • Build an Example Time Intelligence Report
  • Code in M language to connect to various different data sources and “Mashing” them up
  • Utilise Power BI Administration to  control and monitor self-service, processes and policies
  • Use Advanced Visualisations tools to add and create navigation, Buttons, Bookmarks and presentations 
  • Maximise Power BI's features to create outstanding Visuals and complex Calculations in DAX

FULL COURSE DETAILS

This advanced Power BI 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.


FULL COURSE DETAILS
JBI training course London UK
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 - Typically used for CFO Dashboards, Revenue & Profitability, Expense Management, Financial Planning & Analysis, Sales, Stock Control, Risk & Compliance Analysis...

 


FULL COURSE DETAILS

Related Courses

DAX

  • Commonly Used DAX Functions
  • Sum, Average, Count, DistinctCount
  • Create a measure table
  • Copying and Moving Measures
  • Use Variables in calculation
  • Different granularity: calculate allocated weight
  • Filter context
  • Evaluation Contexts and Relationships
  • Understand the use of CALCULATE
  • Table Functions: ALL, ALLEXCEPT, FILTER
  • Table Functions: DISTINCT, VALUES
  • Advanced Evaluation Context DAX  
  • Context transition
  • Iterator -> nested row context
  • Row context and Totals
  • Row context and cumulative total
  • Time Intelligence prerequisites
  • Time intelligence functions MTD, QTD, YTD, SamePeriodLastYear
  • YTD, MTD with CALCULATE
  • Rolling totals for different periods
  • IF, HasOneValue
  • Using a Safe Divide Function
  • Using the Blank() Function
  • Build an Example Time Intelligence Report
  • Creating Dynamic titles
  • Using parameter table
  • What is scenarios
  • DAX STUDIO:
  • Dax as a query language
  • Capturing and debugging queries with Dax Studio
  • Power BI referencing

Advanced visualization

  • Moving away from 1 Dimensional Story-telling
  • Adding navigation with Buttons and Bookmarks
  • Create a presentation using bookmarks
  • Using Focus Mode
  • Selection Pane
  • Creating Drill-Through Reports
  • Use of Custom Visuals
  • Custom Themes
  • Building Reports using Q&A

Advanced visual (Cont...)

  • Optimizing Report Slicers
  • Filtering Reports by Relative Dates
  • Multiple pages slicers
  • Types of Slicers and Filters
  • Filter Pane
  • Customizing Report Visual Interactivity
  • Cross Highlighting or Cross Filtering
  • Choosing Visuals Based on Context
  • Using Custom Visuals
  • Creating amazing reports with Layouts
  • Conditional Colour formatting
  • Adding & Optimizing Tool Tips
  • Using the Format Painter
  • Visual Alignment Tips
  • Custom Page Sizing and Tooltip page
  • Using Logos & Custom Icons
  • Making Enhancements with Shapes and Lines
  • Formatting Tips & Tricks
  • Best Practice Guidelines and Development Tips
  • Removing or Hiding Data Model Redundancies
  • Optimizing Waterfall Charts
  • Getting Value from Scatter, Ribbon & Bullet Charts
  • Use R and Python in Power BI visuals

Advanced Modelling

  • Many-to-Many relationship
  • Cross filtering
  • Cross Filtering with CALCULATE
  • Cross Filtering and Time intelligence
  • Role Playing Dimensions
  • Creating  a ordered vs shipped date table
  • UseRelationship function

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
  • 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
 
Course Updates & Newsletter
 
 

Receive the latest version of this course by email & subscribe to our Newsletter



CONTACT
0800 028 6400

enquiries@jbinternational.co.uk

SHARE

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

Registered address 1345 High Road, London, N20 9HR