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.
1 day (short version) or 2 days (preferred, full version)
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.
Good familiarity with Power BI, for example by having attended both the foundation and intermediate courses.
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.
Write and test DAX measures in the DAX Query View.
DAX concepts
DAX syntax
“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”