DAX Training Course

Highlights

DAX
Data modelling

Course Details

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

Data modelling

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

Who should attend

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...

Feedback

4.8 out of 5 average

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022

“JBI did a great job of customizing their syllabus to suit our business needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and the Instructor handled this particularly well - very impressive”

Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022

Certification

Every delegate will be entitled to a certificate of achievement on completion of the course.

If you are missing your certificate - please use the link below to apply - you can also use this link to sign up for the JBI Training newsletter to receive technology tips directly from our instructors - Analytics, AI, ML, DevOps, Web, Backend and Security.

More about this course

Our Dax 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.

FAQs

JBI Training offers a comprehensive suite of Power BI courses covering all skill levels. Available courses include Power BI Introduction, Power BI Beyond the Basics, Power BI Modelling and Data Prep, Power BI Administration and Report Management, Data Analytics with Power BI, Power BI DAX, Power BI Power Query and M, and Power BI Visualisation. All courses are available as scheduled classroom sessions in London, as live online instructor-led training, or as customised onsite programmes for corporate teams.

Yes. Power BI training for corporate teams is one of JBI's most requested programmes. Courses can be delivered onsite at your organisation's premises or online for distributed teams, and the content can be customised to your specific data sources, reporting requirements, and business objectives. JBI has delivered Power BI training for corporate clients including the BBC, NHS, RBS, Sky, Capita, Cisco, and Lloyds Banking Group.

Power BI training is available at every level. The introductory course requires no prior Power BI experience and is suitable for anyone who works with data, including business analysts, finance professionals, and report developers. Intermediate and advanced courses cover topics such as DAX calculations, Power Query, data modelling, and administration, and assume some prior experience with Power BI or data analysis tools.

DAX (Data Analysis Expressions) is the formula language used in Power BI, Excel Power Pivot, and Analysis Services to create calculated columns, measures, and custom aggregations. It is a core skill for anyone building analytical reports in Power BI. JBI's Power BI courses introduce DAX from the basics and progress through advanced patterns, including time intelligence functions, filter context, and row context, giving delegates the ability to build accurate and flexible calculations for business reporting.

Power BI Desktop is a Windows application used to build and design reports, data models, and DAX calculations. Power BI Service is the cloud-based platform used to publish, share, schedule data refreshes, and manage access to reports and dashboards across an organisation. JBI's Power BI courses cover both environments, helping delegates understand when to use each component and how they work together in a production reporting environment.

Yes. JBI's Power BI training is continuously updated to include the latest Microsoft enhancements, including Copilot in Power BI, AI-powered visuals, smart narratives, and the evolving integration between Power BI and Microsoft Fabric. Delegates learn how these features work in practice and how they can be used to accelerate report development and insight generation.

Power BI is widely used across finance and banking, retail, healthcare, the public sector, manufacturing, professional services, and media. It is particularly valuable in any organisation that needs to consolidate data from multiple sources, automate reporting, and share interactive dashboards with stakeholders. Power BI training is relevant for professionals in business intelligence, financial analysis, operations, HR analytics, and data engineering roles.

Yes. JBI's Power BI courses are continuously reviewed and updated to reflect the latest version of Power BI Desktop and Power BI Service. This includes new features released by Microsoft as part of its regular monthly update cycle, as well as developments in the broader Microsoft data platform, including Power Query enhancements, DAX improvements, Copilot integration, and Microsoft Fabric connectivity. Delegates learn skills that reflect how Power BI is currently used in professional environments.

Yes. Power BI connects to a wide range of data sources including Microsoft Excel, SQL Server, Azure SQL Database, SharePoint, Dynamics 365, Salesforce, Google Analytics, REST APIs, and many other on-premise and cloud services. JBI's Power BI courses include practical exercises connecting to and transforming data from multiple source types, reflecting the diverse environments that professionals encounter in practice.

Maximise Power BI's features - create complex Calculations in DAX

Public Courses

Customised Courses

Highlights

Course Details

DAX

Data modelling

Who should attend

Feedback

4.8 out of 5 average

Certification

More about this course

FAQs

Highlights

Course Details

DAX

Data modelling

Who should attend

Feedback

4.8 out of 5 average

Certification

More about this course

FAQs

What Power BI training courses does JBI Training offer?

Is Power BI training available for corporate teams and organisations?

What level of experience is required to attend a Power BI course?

What is DAX and why is it covered in Power BI training?

What is the difference between Power BI Desktop and Power BI Service?

Does Power BI training cover Copilot and AI features?

Which industries use Power BI and benefit most from this training?

Is the Power BI training kept up to date with the latest Microsoft releases?

Can Power BI be used with data from Excel, SQL, and cloud sources?

Email this page to yourself