Power Bi Training Courses London UK

Power BI Course

DAX Training

Join our 5-Day Power BI course to master DAX, the key to advanced data manipulation. We start with the basics to build a solid foundation, then progress to complex functions, focusing on practical application and engagement.

By the end, you’ll confidently write tailored DAX expressions, tackle intricate challenges, and optimize functions using the best tools and techniques. This course is an invaluable step towards becoming a Power BI expert, equipping you with immediately applicable skills for your professional role. Book now and transform your data analysis capabilities.

About this Course:

Without using DAX, you can only use 50% of Power BI’s capability. Although Power BI Dax is simple, with only a few fundamental concepts, it is not easy as these concepts require deep learning. That is why a lot of Power BI users think they know DAX until they realize their functions are not returning correct results.

This 5-Day Power BI course is designed to lay solid foundations before diving deep into complex DAX functions. This is achieved by focusing on 2 key elements i.e. engagement, and practicality.

Participants will be spending 90% of their time writing hands-on DAX functions, looking at the result, discussing what works, and especially what does not work and WHY? Additionally, all the modules and concepts are reinforced by real-life, scenario-based examples to solidify the learnings.

After this course, participants should be able to write DAX expressions to address their specific business needs, leverage available resources to tackle complex problems and debug and optimize using available tools and the right techniques.

Moreover, the entire course walks through a single data set so participants can concentrate on mastering the concepts rather than worrying about the specifics of the dataset.

Prerequisites:

This Power BI DAX course is suitable for people who have either completed the Power BI Essentials course or have a reasonable understanding of data modeling concepts. To benefit most from this course, participants must have some expertise in using Excel functions or T-SQL.

Who should take this course?

This course is for business users (Finance, Marketing, Operations, etc.) or SQL Server report creators who want to take their reports and dashboards to the next level by writing custom calculations using DAX functions to address specific business requirements.

TRUSTED BY TOP COMPANIES

We’re proud to have trained employees from some of the most renowned companies in
the UK. Here’s a glimpse of companies we have had the honour to train:

Upcoming Dates

July

Date Day Training Mode
01.07.2024 Mon Online/Classroom
08.07.2024 Mon Online/Classroom
15.07.2024 Mon Online/Classroom
22.07.2024 Mon Online/Classroom
29.07.2024 Mon Online/Classroom
Please contact us for further dates

August

Date Day Training Mode
05.08.2024 Mon Online/Classroom
12.08.2024 Mon Online/Classroom
19.08.2024 Mon Online/Classroom
21.08.2024 WedOnline/Classroom
26.08.2024 Mon Online/Classroom
Please contact us for further dates

September

Date Day Training Mode
02.09.2024 MOn Online/Classroom
09.09.2024 Mon Online/Classroom
16.09.2024 Mon Online/Classroom
23.09.2024MonOnline/Classroom
30.09.2024 Mon Online/Classroom
Please contact us for further dates

October

Date Day Training Mode
07.10.2024 Mon Online/Classroom
14.10.2024 Mon Online/Classroom
21.10.2024 Mon Online/Classroom
23.10.2024 WedOnline/Classroom
28.10.2024 Mon Online/Classroom
Please contact us for further dates

November

Date Day Training Mode
04.11.2024 Tue Online/Classroom
11.11.2024 Mon Online/Classroom
18.11.2024 Mon Online/Classroom
20.11.2024 WedOnline/Classroom
25.11.2024 Mon Online/Classroom
Please contact us for further dates

December

Date Day Training Mode
02.12.2024 Mon Online/Classroom
03.12.2024 Tue Online/Classroom
09.12.2024 Mon Online/Classroom
10.12.2024 TueOnline/Classroom
16.12.2024 Mon Online/Classroom
Please contact us for further dates

For more date options and to

complete the booking please contact us

Course Outline

Module 1: Introduction to DAX
  • What is DAX?
    • Overview of DAX in Power BI
    • Importance of DAX in Data Modeling and Analysis
  • Understanding DAX Syntax and Structure
    • Basic Syntax
    • Common Errors and Debugging
  • Creating Calculated Columns
  • Creating Measures
  • Differences Between Calculated Columns and Measures
  • Basic Functions in DAX
    • SUM, AVERAGE, MIN, MAX, COUNT
  • Aggregation Functions
    • SUMX, AVERAGEX, MINX, MAXX, COUNTX
  • Time Intelligence Functions
    • DATEADD, DATESYTD, DATESMTD, DATESQTD
    • SAMEPERIODLASTYEAR, PARALLELPERIOD, TOTALYTD
  • Understanding Row Context and Filter Context
  • Filter Functions
    • FILTER, ALL, ALLEXCEPT, ALLSELECTED
    • CALCULATE, CALCULATETABLE
  • Using RELATED and RELATEDTABLE
Module 5: Advanced DAX Functions
  • Logical Functions
    • IF, SWITCH, AND, OR
  • Text Functions
    • CONCATENATE, LEFT, RIGHT, MID, FIND, SEARCH
  • Date and Time Functions
    • TODAY, NOW, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND
  • Parent-Child Functions
    • PATH, PATHITEM, PATHLENGTH
  • Hierarchies and DAX
  • Using DAX in Relationship Management
  • Advanced Calculations and KPI Metrics
    • Dynamic Titles and Labels
    • What-If Analysis with DAX
  • Best Practices for Writing Efficient DAX
  • Understanding and Using Variables
  • Optimizing DAX Queries
    • Reducing Model Size
    • Improving Calculation Speed
  • Using DAX Studio for Performance Tuning
  • Financial Analysis
    • Year-over-Year and Month-over-Month Calculations
    • Running Totals and Moving Averages
  • Sales and Marketing Analytics
    • Customer Segmentation
    • Sales Forecasting
  • Operational Metrics
    • Inventory Management
    • Employee Productivity Analysis
Module 9: Case Studies and Practical Exercises
  • Hands-On Case Studies
    • End-to-End DAX Solutions for Various Scenarios
  • Practical Exercises
    • Building Complex Measures and Calculated Columns
    • Real-World Data Challenges
  • Common DAX Errors and Solutions
  • Using DAX Debugging Tools
    • DAX Studio
    • Power BI Performance Analyzer
  • Best Practices for Error Handling
  • Using DAX in Power BI Service
    • Dataflows and DAX
    • DAX and Power BI Report Server
  • Collaboration and Sharing
    • Sharing DAX Solutions
    • Version Control with DAX

#1 Choice For Power BI Training

Contact Us

Kindly submit your details and a training consultant will contact you shortly.

Course Manual

Our training is complemented by a thorough course manual that covers every aspect of Power BI, from its basic features to advanced analytics. These manuals are crafted keeping the user’s perspective in mind, offering step-by-step guides, tips, and practical examples. Whether it’s about data modelling, visualization techniques, or advanced analytics, the manual is your go-to resource.

Flexible Study
Modes

Pick the learning style that suits you best with our Flexible Study Modes. You can join our live online sessions for easy and flexible learning or enjoy the hands-on experience at our classroom locations. For teams looking for a tailored approach, we also provide on-site training at your location, bringing personalised Power BI expertise directly to your company.

Free Class Re-
Sit

To ensure thorough understanding and retention, we offer participants the opportunity to re-sit the same class free of charge. This not only reinforces the learning but also provides a chance to clear any lingering doubts. It’s our way of guaranteeing that you’re completely confident in applying your Power BI knowledge in real-world scenarios.