London #PowerBI user group with Peter Myers
January 27 @ 6:30 pm - 8:30 pm
We’re very excited to host Peter Myers at our next event who’s coming all the way from Australia.
The Do’s and Don’ts of Power BI Relationships
This presentation is about Power BI modeling with a specific focus on relationships. Relationships are essential to delivering intuitive, accurate, and optimal models. In this presentation, learn what relationships do and how they can be configured for Import, DirectQuery, and Composite models. After a straightforward introduction, theory and demos will progress beyond the basics to explain how to achieve sophisticated model designs that include role playing dimensions, many-to-many relationships (two techniques), ambiguous relationships, virtual relationships, and disconnected tables. The DAX functions that leverage or modify model relationships are also introduced.
Peter Myers is a consultant, trainer and presenter from Melbourne, Australia. He 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.
This month’s meetup will be held at Nigel Frank’s London office. If your Meetup user name isn’t your full name, please can you provide this by message, as we need to provide this information to building security.
18:30 to 18:35 – Welcome
18:35 to 19:00 – Recent Updates to Power BI
19:00 to 20:00 – Main Session
20:00 onwards – Networking and Pizza