talk-data.com

Description You might have heard the news: Building visuals and creating DAX measures in Power BI is easier when your data model is in shape.

You can consider a data model being in shape when it contains a date (or time) table and has all fact tables normalized and all dimension tables denormalized. You should also replace flags and indicators with meaningful texts, duplicate dimensions for role-playing purposes, create bin tables for range of values, etc. In this talk Markus will show you in live demos how you bring your data model into shape: trimming off the fat of your fact tables and adding muscles to your dimension tables with the help of Fabrics workloads. Follow Markus’ step-by-step guide to learn how you can make the life of Power BI report creators easy.

Speaker: Markus Ehrenmueller-Jensen | LinkedIn

Microsoft Data Platform Group Birmingham

Thursday 3rd April at 13:00 (GMT - UK Time)

Speaker: Markus Ehrenmueller-Jensen

Title: Data Shaping for Power BI in Fabric

Description: You might have heard the news: Building visuals and creating DAX measures in Power BI is easier when your data model is in shape.

You can consider a data model being in shape when it contains a date (or time) table and has all fact tables normalized and all dimension tables denormalized. You should also replace flags and indicators with meaningful texts, duplicate dimensions for role-playing purposes, create bin tables for a range of values, etc.

In this talk, Markus will show you in live demos how you bring your data model into shape: trimming off the fat of your fact tables and adding muscles to your dimension tables with the help of Fabric's workloads. Follow Markus’ step-by-step guide to learn how you can make the life of Power BI report creators easy.

Agenda:

12.45 - 13:00 : Setup and Join

13:00 - 13:05 : Open Lobby and Introductions

13:05 - 14:00 : Data Shaping for Power BI in Fabric

Venue: Wherever you have access to a computer or smart device! This session will be online only!

Other Details:

*** Please note registration on MeetUp is required to gain access to the Teams link!***

Please contact us on Twitter or via email if you are having any issues joining and we'll do everything we can to help.

Event Organiser Contact Details:

If you need any further details or have any requests for this or future Data Platform Group events, please get in touch.

Email: [email protected]

Twitter: @MSDataGroupBrum

Sponsors:

Purple Frog Systems

Power BI Sentinel

Data modeling is the single most overlooked feature in Power BI Desktop, yet it's what sets Power BI apart from other tools on the market. This practical book serves as your fast-forward button for data modeling with Power BI, Analysis Services tabular, and SQL databases. It serves as a starting point for data modeling, as well as a handy refresher. Author Markus Ehrenmueller-Jensen, founder of Savory Data, shows you the basic concepts of Power BI's semantic model with hands-on examples in DAX, Power Query, and T-SQL. If you're looking to build a data warehouse layer, chapters with T-SQL examples will get you started. You'll begin with simple steps and gradually solve more complex problems. This book shows you how to: Normalize and denormalize with DAX, Power Query, and T-SQL Apply best practices for calculations, flags and indicators, time and date, role-playing dimensions and slowly changing dimensions Solve challenges such as binning, budget, localized models, composite models, and key value with DAX, Power Query, and T-SQL Discover and tackle performance issues by applying solutions in DAX, Power Query, and T-SQL Work with tables, relations, set operations, normal forms, dimensional modeling, and ETL

When learning DAX you will soon discover, that it is both, “easy, but hard” (© Alberto Ferrari).

On the one hand, the syntax of this language is very close to Excel formulas and easy to understand. On the other hand, the semantic of some functions is very challenging.

In this talk Markus will share the challenges he faced when learning the language and how overcame them. You will get a proper understanding of the differences between calculated columns and measures and you will learn of the concept of context and how to manipulate the context to achieve advanced calculations.

About the speaker:

Markus Ehrenmueller-Jensen

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 (both were merged into Data Community Austria in 2021) and organizes Data Community Austria (fka. SQL Saturdays & Data Saturdays) in Vienna since 2014. For his technical leadership in the community he was awarded repeatedly as a Microsoft Data Platform MVP since 2017.

About the event:

• All presented times are Lisbon Time
• Meetup will be hosted in English

If you have any questions, please feel free to contact us.