The Do’s and Don’ts of Power BI Relationships


BI guru Peter Myers will be in town from Australia to talk about Power BI modeling. He'll focus on relationships and how they are essential to delivering intuitive, accurate, and optimal models. You will learn that model relationship design is considered part science and part art. Peter is a master of demos and you'll get to see a lot.

You'll learn:

* What relationships do
* How relationships can be configured for Import, DirectQuery, and Composite models
* Best practice guidance for developing models, including role playing dimensions, many-to-many relationships (two techniques), ambiguous relationships, and disconnected tables
* About DAX functions that leverage or modify model relationships

Peter Myers is a consultant, trainer and presenter, and has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services. He has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007.