Power BI : Building an Empire & Working with (data) models
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 an hour 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?
Don’t only tell your friends that you are a professional who works with models but be actually great in doing it. 😊
Trying to implement a BI project can be extremely tedious, take unreasonable amounts of time and in the end turn out to be something that the users didn’t want.
This session goes through how to use Power BI and dataflows to iteratively build a BI solution – starting from the absolute beginning with just an excel file, moving to combining data from several data sources, and finally explaining how to use Power BI dataflows to deliver maximum analytical power to the right users with a minimum of wasted time. You will walk away with new ideas how to start and grow your BI projects as well as an insight into Power BI dataflows and its uses.
Markus Ehrenmüller-Jensen is the founder of Savory Data and works as a project leader, data engineer and BI architect 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 in 2016 Power Platform Usergroup Austria and organizes SQL Saturdays in Vienna since 2014. For his technical leadership in the community he was awarded repeatedly as a Microsoft Data Platform MVP since 2017.
Alexander is principal solutions architect at Atea in Linköping, Sweden. Nobody really knows what it means to be a principal solutions architect, but he spends his days teaching courses or helping clients of all shapes and sizes to take better care of their data.
He has spent the last 20 years toying with data, databases and related infrastructure services such as storage, networking and virtualization, occasionally emerging from the technical darkness to attend a Star Wars convention somewhere in the world.
He is a Data Platform MVP, frequent international speaker, podcaster, Pluralsight author, blogger and a Microsoft Certified Trainer, focusing on SQL Server, Azure and Power BI.
|18u30||Welcome and introductions|
|18u45||Working with (data) models in Power BI (60 minutes)|
|19u45||Building an Empire – Implementing Power BI step by step (60 minutes)|
In between sessions, there’ll be a 15 minute break.