Zomalex | Data and AI Training

Home | Power BI | Excel | Python | SQL | Generative AI | Visualising Data | Analysing Data | Prices | Contact Us | info@zomalex.co.uk

Power BI Advanced Course

Who should attend

People who are familiar and comfortable with the essentials of Power BI (building visualisations, shaping data in the query editor, using the model view for example to create hierarchies) and who want to get to grips with writing DAX measures well.

Course Length

1 day (short version) or 2 days (preferred, full version)

Learning Objectives

Attendees will be able to write DAX to solve data modelling and calculation challenges in Power BI, and to build a standard star schema data model.

Pre-requisites

Good familiarity with Power BI, for example by having attended both the foundation and intermediate courses.

Course Content

This is an advanced course with a code-first approach. Attendees write DAX in the DAX query view for much of the course. The course covers the following topics.

DAX

Write and test DAX measures in the DAX Query View.

DAX concepts

• Implicit and Explicit measures
• Aggregator Functions e.g. SUM() vs Iterator functions e.g. SUMX
• Context and Filtering. Row context in calculated columns. Implicit Filter Context in Measures. Context transition
• The CALCULATE and CALCULATETABLE functions and why they are so important

DAX syntax

• DEFINE and EVALUATE
• The SUMMARIZECOLUMNS function to return a query
• Variables. The VAR RETURN Syntax. Using several variables. Typical use cases and several examples.

Data Modelling with Power BI

• Fact and dimension tables
• Star schemas (and their advantages)

A few comments from attendees of previous courses

“The training is very helpful and will help in my future projects”

“The course was very interactive, allowing enough time to practise the exercises.”

“Mark delivered the Power BI training through Zoom. He ensured everyone felt engaged and no one was left behind. I really enjoyed how he showed us features of the software and gave us exercise to practice with the data. It was useful to collectively review our work and reflect on what we could improve. He was very patient and tailored-made the training to our needs. Feedback from participants was very positive, it was a great success!”

“What I appreciated most in the Power BI training was the opportunity to practice and the way that Mark clarified participants’ doubts.”

“Extremely helpful teaching on data modelling in Power BI”