22-25 April 2026

A Power BI Data Modelling Safari

2022

TL; DR

Data Modelling is the most important skill in a Power BI Data Analyst's arsenal. Well designed models allow for the most comprehensive business value. In this full day session we'll take you through the basics of Dimensional Modelling and then look at how to use DAX to answer questions which require additional modelling.

Session Details

The best way to learn about the African Bush is to go on a Safari. Spending a day with experienced guides, who can point out many things that would otherwise go unseen. This full-day session on Data Modelling in Power BI is the same. Your guides will spend the first half of the day working through the theory of Star Schemas, and how to shape your data to make the best Power BI Model from source. In the second half of the day, we'll explore DAX, starting with measures that are simple to create and explaining how and why they just work. We'll then look at some examples of problems that may not work on the model, and explore different DAX solutions to solve these problems.

3 things you'll get out of this session

Speakers

Michael Johnson

michaeladrianjohnson.com

Michael Johnson's previous sessions

James McGillivray

jimbabwe.co.za

James McGillivray's previous sessions

The Fundamentals of DAX Contexts
Explore the heart of DAX with this unique session, as I take you on an African Safari-themed adventure, where stunning wildlife photography serves as the backdrop for understanding the intricacies of DAX contexts. We'll encounter row and filter contexts, just like wild creatures in their natural habitat. Through captivating visuals, you'll uncover how these contexts shape DAX calculations and measure outcomes. Whether you're a data analyst or a business intelligence enthusiast, this session ensures a memorable and educational experience. Understanding DAX Contexts is your gateway to mastering DAX while enjoying the captivating beauty of African wildlife. Don't miss this opportunity to embark on your DAX adventure.
 
Fabric Power Hour
The famous Power BI Power Hour returns, but this time it has expanded to cover the whole of Fabric!
 
5 Things You Can Do to build better looking reports
Power BI Design is a lot like an art form, a mythical beast to many IT professionals. We’re generally inclined to think very analytically about our jobs, and creativity does not always come naturally. Thankfully, there are some patterns we can apply to design reports which are clean, uncluttered, and user friendly. Learn the science behind design, and a series of logical steps to follow to ensure that your reports always meet the mark.
 
The Fundamentals of DAX Contexts
Understanding how DAX determines evaluation context is a critical skill for a Power BI Developer. Writing anything other than the most simple measures requires this skill. In this session we'll explore Filter Context and Row Context individually, and how they combine to form Evaluation Context. We'll have a look at a number of simple measures and visualise how the context affects them.
 
"Whats in a Name?", Data Stories to Impress the Bard
Data on its own is useful, but boring. Data in story form makes people sit up and take notice. Learn to craft effective stories and maximise the impact of your data communication.
 
Power BI Report Design for the Aesthetically Challenged
Have you ever looked at other people's Power BI reports, and wondered how they look so good? Designing an aesthetically pleasing report does not require a graphic designer, just the lessons you'll take away from this session.