Hierarchies are a cornerstone of most business data models—you’ll find them in product structures, sales territories, calendar dimensions, and geographic regions. Modeling these hierarchies effectively in Power BI is essential for building intuitive, high-performing reports.

In this session, Markus Ehrenmueller-Jensen will guide you through practical techniques for handling hierarchical data in Power BI - from building traditional hierarchies in your semantic model to implementing more complex parent-child structures. You’ll learn how to shape and transform hierarchical data using Power Query, SQL, and PySpark, and how to use DAX to navigate and calculate across hierarchical levels.

And to make things fun? We’ll be working with a sample dataset inspired by Game of Thrones—because who doesn’t love a good (data) battle for the Iron Throne?

What You'll Learn:
* How to model multi-level hierarchies and parent-child relationships
* Data preparation strategies using Power Query, SQL, and PySpark
* Writing DAX to traverse hierarchies and enable level-based calculations
* Design patterns that support scalability and usability in enterprise models

Who Should Attend:
Power BI developers, data engineers, and modelers who want to better understand how to manage and analyze hierarchical data using the full Power BI and Fabric toolset.