Power BI is a self-service Business Intelligence tool, which does a great job in hiding complexity and technology away from the user. But when it comes to performance and even correct numbers, one should spend some time in finding the right way of modelling the tables and how they are related to each other. In this talk we spend 50 minutes on doing exactly that. You will get answers to questions like: Why should you care about the data model? What kind of relations are available? How do they influence performance? Why redundancy is (not) a bad thing?
Markus Ehrenmüller-Jensen is the founder of Savory Data and works as a project leader, trainer & consultant for data engineering, business intelligence, and data science since 1994. He is an educated software-engineer, graduated business educator and professor for databases and project engineering at HTL Leonding (technical college) and certified as MCSE Data Platform and MCSE Business Intelligence. Markus speaks regularly on international conferences (eg. SQL PASS Summit, SQLBits London, Power Platform Worldtour, SQL Saturdays, SQL Days, SQL PASS Austria, ...) and writes articles for well-known journals. In 2013 he co-founded SQL PASS Austria and organizes SQL Saturdays in Vienna since 2014. He co-founded Power BI Usergroup Austria in 2016. For his technical leadership in the community he was awarded as a Microsoft Data Platform MVP since 2017.
We seek to provide a respectful, friendly, professional experience for everyone, regardless of gender, sexual orientation, physical appearance, disability, age, race or religion. We do not tolerate any behavior that is harassing or degrading to any individual, in any form. The Code of Conduct will be enforced.
All live stream organizers using the Global Azure brand and Global Azure speakers are responsible for knowing and abiding by these standards. We encourage every organizer and attendee to assist in creating a welcoming and safe environment. Live stream organizers are required to inform and enforce the Code of Conduct if they accept community content to their stream.
If you are being harassed, notice that someone else is being harassed, or have any other concerns, report it. Please report any concerns, suspicious or disruptive activity or behavior directly to any of the live stream organizers, or directly to the Global Azure admins at firstname.lastname@example.org. All reports to the Global admin team will remain confidential.
We encourage local organizers to set up and enforce a Code of Conduct for all Global Azure live stream. A good template can be found at https://confcodeofconduct.com/, including internationalized versions at https://github.com/confcodeofconduct/confcodeofconduct.com. An excellent version of a Code of Conduct, not a template, is built by the DDD Europe conference at https://dddeurope.com/2020/coc/.