A Power BI Data Modelling Safari
2022TL; 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's previous sessions
Data Lakehouse Vs Data warehouse in Fabric, which is right for you
Microsoft Fabric offers a variety of data engineering solutions that can suit different needs and goals. However, this also means that choosing the right solution can be challenging and confusing for those who want to migrate to Microsoft Fabric.
The accidental administrator's guide Power BI
If not properly planned and managed, your Power BI environment quickly becomes a mess., making it hard to use and improve. Join this session where we will look at 6 key areas that you as a Power BI administrator will need to look at.
Building a robust deployment pipeline in Power BI
Does your organisation need to manage the deployment of Power BI better? Join this session to learn how to shorten the time to deploy new features to your users while ensuring you maintain a standard for high quality using tools such as Azure DevOps and Power BI deployment Pipelines.
Power BI Premium on a budget
Power BI Premium has many features that organisations desire yet the price makes it impractical for most. In this talk you will learn how Power BI Embedded can be used to enable many of these features at a much lower cost.
Analyzing real-time data using Azure Streaming Analytics.
Businesses today require real-time information to make better-informed decisions, this requires a new set of tools. In this session you will learn about Azure Stream analytics and how it can help address real-time data scenarios
James McGillivray
jimbabwe.co.za
James McGillivray's other proposed sessions for 2026
5 Design Patterns for Better Looking Reports - 2026
From Ranking to Rolling Totals: Windowing Functions Explained - 2026
Same Words, Different Worlds: Communication Across Domains, Roles and Ranks - 2026
Seconds to Save Lives: Real World Real-Time Intelligence with Fabric - 2026
Solving Real Business Challenges with DAX - 2026
Super Simple Fabric Workloads Make You Feel Precocious - 2026
The Force Awakens: Charting Your Career Path with the Data Community - 2026
Turning Data Into Stories People Remember - 2026
Understanding DAX Through Pictures - Part 1 - 2026
Understanding DAX Through Pictures - Part 2 - 2026
YMCA: You Must Consider Accessibility - 2026
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.