Power BI is the data service from Microsoft that is creating a real buzz in the analytics and business intelligence community. Business users can get data from almost any source, visualise it and share their insights. It also has great power under the covers to do sophisticated data preparation and modelling and build beautiful dashboards. Users can ask questions of their data with natural language and Power BI will do it's best to answer you .
This group will help you get started with Power BI. We'll offer a mix of introductory talks but we'll also have some sessions for the experts as well. Some of the events will be hands-on.
We meet monthly in Central London on a weekday evening. Please come along - you will be sure of a warm welcome.
The London Power BI Users Group is part of the Microsoft Power BI User Group Program. Microsoft is not responsible for content on this website or activities that take place at Group meetings.
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