The new composite models in Power BI introduced a new type of relationship cardinality called many-to-many. Nevertheless, despite their name, they are not many-to-many relationships, they are relationships between tables generated at a different granularity.
In this session we clarify the purpose of the relationships with many-to-many cardinality, highlighting the significant difference with canonical many-to-many relationships. In the meantime, we show how and when to use the different kind of many-to-many relationships with several practical examples.
Our guest speaker, Marco Russo, is a business intelligence consultant and mentor. He wrote several books with Alberto Ferrari about Power BI, Analysis Service, and Power Pivot. They also regularly write articles and white papers that are available on www.sqlbi.com. Marco is a Microsoft MVP. Today, Marco focuses his time with SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide.
Meeting will be sponsored by Data Ignite.
6:00pm - Pizza and networking
6:30pm - Meeting announcements and Presentation