LIVE Instructor-Led Courses
Dismiss

Power BI - Beyond the Basics training course

A "World Class" course - Learn to maximise Power BI's features - Create outstanding Visuals and complex Calculations in DAX

JBI training course London UK

"Absolutely excellent, extremely helpful to plug gaps in my knowledge and learn the logic and workings behind Power BI and DAX. All explanations were extensive and now much more confident about Power Query, M language and understanding DAX, and there were many tricks I had no idea about in nearly three years of using Power BI. JBI will be my first port of call when scoping courses for me or the team in the future!."
NHS, Snr Perfomance Analyst, Power BI Adv, Aug 2023

Public Courses

20/03/24 - 3 days
£1750 +VAT
29/04/24 - 3 days
£1750 +VAT
03/06/24 - 3 days
£1750 +VAT

Customised Courses

* Train a team
* Tailor content
* Flex dates
From £1200 / day
EDF logo Capita logo Sky logo NHS logo RBS logo BBC logo CISCO logo
JBI training course London UK

  • Advanced DAX
  • Smart Visualisation
  • Power Query
  • M Language
  • Data Modelling
  • Power BI Publishing Architecture
  • More options for custom courses

In this Video, Clive gives an overview of the Power of DAX... The content is taken from our Microsoft Power BI Beyond the Basics training course

DAX

  • Understanding Filter context
  • Best Practice guidelines and development tips
  • Commonly Used DAX Functions: SUM, AVERAGE, COUNTROWS, IF, BLANK
  • Benefit of safe DIVIDE Function
  • Understand use of CALCULATE to modify filter context with ALL, FILTER
  • Calculate yearly percentage contributions with ALLEXCEPT
  • Tips for understanding complex DAX code
  • Moving Measures to a measure table
  • Dynamic titles driven by DAX
  • Time Intelligence prerequisites
  • Create Dates table in DAX
  • How relationship filter flow direction works
  • Time intelligence functions DATESYTD, SAMEPERIODLASTYEAR, PREVIOUSMONTH
  • Build an Example Time Intelligence Report
  • Implement Fiscal Years
  • Rolling totals
  • Key Performance Indicators
  • Use of DAX Variables
  • Create a polymorphic measure using SELECTEDVALUE and a slicer
  • Understanding Row Context and iteration
  • Context transition
  • Avoid creating DAX columns by using the X functions: e.g. SUMX
  • Pareto classification (80:20 rule) using row context formulas
  • DAX STUDIO:
  • DAX as a query language
  • Resolving performance problems

Smart Visualisation

  • Templates, Layouts
  • Options with Scatter Chart, Waterfall Chart
  • Play axis
  • Trend lines
  • Use TOPN to limit axis categories
  • Gauge and KPI visuals
  • Creating a Tooltip popup page
  • Set custom Page Size

Advanced Power Query

  • The Power Query Environment and M language
  • Stepped Data Transformation
  • Removing or hiding data model redundancies
  • Disable loading of intermediate queries not needed for visualisation
  • Adapting queries to a changed data source
  • Create a custom table with Enter Data
  • Merge queries
  • Append queries
  • Splitting columns
  • Custom columns
  • Multi-condition column
  • Create a column from example data values
  • Import text dates from a non-UK locale
  • Derive and visualise Durations
  • Advanced Search and Replace
  • Auto-import all sheets from a workbook
  • Auto-import all files from a folder

M Language

  • M Query Basics
  • Advanced Editor
  • M Variables and data types
  • Strengthen code with custom M variables
  • Understand the power of M Functions
  • Reference another query with the M language
  • Create and use an M function to change data values
  • Invoke an M function

Data Modelling

  • Normalised vs Denormalised data models
  • Build a Star Schema using Power Query
  • Build dimension tables from normalised data
  • Reduce fact table rows by reducing granularity
  • Reapportion numerical data from Header to Detail level granularity
  • USERELATIONSHIP function for inactive relationships

Power BI Publishing Architecture

  • What Gateways do
  • Gateways: Personal vs Enterprise
  • Gateways and Direct Query
  • Scheduling Data Refresh    

Options For Custom Courses Only   

  • Incremental Refresh using Power Query Parameters
  • Implementing and testing Row Level Security
  • Using the R and Python Visuals
  • Gannt chart
  • Unpivoting a pre-pivoted data source
  • Admin topics
JBI training course London UK

Business Analysts, Financial Analysts, Quants, 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

Note : This course requires delegates to run Power BI Desktop. Mac users must make arrangements to use a PC

 


5 star

4.8 out of 5 average

"Absolutely excellent, extremely helpful to plug gaps in my knowledge and learn the logic and workings behind Power BI and DAX. All explanations were extensive and now much more confident about Power Query, M language and understanding DAX, and there were many tricks I had no idea about in nearly three years of using Power BI. JBI will be my first port of call when scoping courses for me or the team in the future!."
NHS, Snr Perfomance Analyst, Power BI Adv, Aug 2023

“Learning more about the query editor was very useful and especially the merge tables features. The Bookmarks section was very good and it was nice to see some really good examples of how it can be used to present your work. The presenter was very helpful and had great knowledge of Power BI."
AG, Business Analyst, Power BI Advanced, Feb  2021

JBI training course London UK

Newsletter

 

Sign up for the JBI Training newsletter to stay updated with world-class technology training opportunities, including Analytics, AI, ML, DevOps, Web, Backend and Security. Our Power BI Training Course is especially popular.  Gain new skills, useful tips, and validate your expertise with an industry-leading organisation, all tailored to your schedule and learning preferences.



DAX is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. Stated more simply, DAX helps you create new information from data already in your model.

On this advanced Microsoft Power BI training course we will explore how to maximise Power BI's functionality to produce stunning visuals, and how to use DAX to create complex calculations that will allow you flexibility beyond that offered by the standard toolset.

Power Query provides connectivity to hundreds of data sources and over 350 different types of data transformations for each of these sources, you can therefore work with data from any source and in any shape - More advanced data modelling and visualisation techniques will be explored on this Advanced Power BI training courses as well as how you can use Power Query and M Language to get even more out of your Power BI environment.

What characterises Power BI? Power BI, a medley of software services, apps, and connectors, harmonises disparate data sources into visually compelling, interactive insights. A Microsoft product, Power BI capacitates businesses to visualise their data, disseminate insights across the organisation, or embed them in an app or website.

What differentiates Power BI and Tableau? Both Power BI and Tableau, robust data visualisation tools, display key differences. Power BI, integrating flawlessly with the Microsoft suite and offering an intuitive interface, suits businesses heavily reliant on Microsoft products. Conversely, Tableau, more flexible with a steeper learning curve, fits needs for complex data analysis and extensive data sets.

How do Power Query and Power Pivot differ?  Power Query and Power Pivot, components of the Power BI suite, serve unique functions. Power Query, a data connection solution, enables data discovery, connection, combination, and refinement from varied sources. In contrast, Power Pivot assists in modelling and analysing the acquired data by creating data models, establishing relationships, and designing calculations.

What is Power BI Desktop? Power BI Desktop, a Windows-based application in the Power BI product spectrum, permits the creation of interactive reports and dashboards. It integrates the Power Query, Power Pivot and Power View tools into a single product, facilitating data extraction, shaping, modelling, and visualisation within one platform. It's essentially another version of Power BI.

What does Power Query encompass? Power Query, a data connection tool within Power BI, enables the extraction, transformation, and loading (ETL process) of data from a diverse range of sources into Power BI and Excel.

What does DAX denote? DAX (Data Analysis Expressions) is a library of functions and operators useful in formulating calculations in Power BI, Analysis Services, and Power Pivot in Excel. You can employ these formulas to generate new data columns, aggregate data for reports, or even determine how your visualisations present data.

What function do Filters perform in Power BI? Filters in Power BI operate as tools limiting the data displayed in a visual. By applying filters, you can focus on specific data segments meeting certain criteria, yielding more precise insights.

What are Custom Visuals in Power BI? Custom visuals in Power BI are visualisation elements that you can import or create, extending capabilities beyond Power BI's standard visuals. This feature allows users to exhibit their data uniquely, tailored to their particular needs.

What role does GetData play in Power BI?  GetData, a function within Power BI, facilitates connections to diverse data sources from within Power BI. This feature allows users to import data from various sources, like databases, online services, Excel files, and other data repositories, into Power BI for analysis.

What is Business Intelligence?

Business intelligence (BI) refers to technologies that gather and analyse data, and then display the resulting information in dashboards and Power BI reports.

BI aims to interpret the enormous volumes of data that organisations store, enabling data analysis to steer business decisions and management.

For example, many retail businesses use Power BI to sort and report their POS data, particularly when Azure Cloud houses the data. Being another Microsoft product, they interface very seamlessly with each other.

Is Power BI challenging to learn?

This potent software can amalgamate data from multiple sources. This data can then assist in business analytics, generating reports and dashboards.

Like other big data software, learning Power BI for straightforward analysis of simple datasets isn't challenging.

However, mastering the full suite of big data tools in Power BI for more complex data analysis is understandably more complex and time-consuming.

Can you learn Power BI by yourself?

Yes, you can absolutely learn Power BI by yourself. The learning curve might vary based on your existing knowledge and experience with Power BI and general data analysis tools. Microsoft provides several resources, including documentation, tutorials, and community forums, which prove extremely beneficial. Additionally, numerous online platforms offer courses and tutorials on Power BI, catering to beginners and advanced users.

Nevertheless, self-learning might necessitate a longer duration to grasp the intricacies of Power BI. Structured courses, like those JBI Training provides, can offer a quicker and more comprehensive learning experience. These courses, generally led by experienced professionals, incorporate live interactions, hands-on training, and immediate feedback, offering a strong foundation in Power BI. The choice between self-learning and course learning would hinge on your learning style, available time, and specific requirements.

CONTACT
+44 (0)20 8446 7555

[email protected]

SHARE

 

Copyright © 2023 JBI Training. All Rights Reserved.
JB International Training Ltd  -  Company Registration Number: 08458005
Registered Address: Wohl Enterprise Hub, 2B Redbourne Avenue, London, N3 2BS

Modern Slavery Statement & Corporate Policies | Terms & Conditions | Contact Us

POPULAR

Rust training course                                                                          React training course

Threat modelling training course   Python for data analysts training course

Power BI training course                                   Machine Learning training course

Spring Boot Microservices training course              Terraform training course

Kubernetes training course                                                            C++ training course

Power Automate training course                               Clean Code training course