Session

Level-up your Power BI data modeling skills

After a successful webinar series on Data Modeling with Power BI, all webinar content is now packed together in a full day precon. The day will be in three sections, where we kick-off with the basics of data modeling. Then we continue with more advanced patterns to finish the day with expert level modeling by using all advanced features and techniques.

So, what is a good data model in Power BI? How do you make sure you have the basics in place so the model you build today, will still work next year? We talk about different modeling concepts, whether to use the data model or Power Query for transformations, the differences in calculated columns and DAX with their effects on your model and handling role-playing dimensions.

After the basics, it is time to level-up by considering more complex patterns like different types of relationships, overcoming ambiguity, and successfully implementing aggregations. Also, different types of storages modes come into play. Dealing with DirectQuery and Imported (cached) data in the same model on table level with user defined aggregations, but also hybrid tables with different storage modes in the same table. Of course, we will talk about composite models with Power BI datasets and/or (Azure) Analysis Services.

To top-off this day full of real-life examples, we will talk about calculation groups and their behavior in composite models. We make sure you finish the day with a list full of tips and tricks that can be directly brought to practice directly.

After this precon you will be able to:
- Explain basic dimensional modeling concepts
- Create a well working and performing data model in Power BI
- Decide when to use Power Query vs the data model
- Decide when to use Calculated columns or measures
- Handle complex situations with inactive relationships and role-playing dimensions.
- Leverage one and bi-directional relationships
- Overcome and handle ambiguous data models
- Successfully implement aggregations
- Work with real live scenarios containing multiple fact tables
- Understand and explain different types of storage modes in Power BI
- Combine DirectQuery and import storage modes in a composite model
- Successfully implement calculation groups
- Understand calculation groups in composite models and their behavior

This precon is a comprehensive training session on data modeling in Power BI, covering both basic and advanced topics. The session is divided into three sections, starting with the fundamentals of data modeling before moving onto more advanced patterns and finishing with expert-level modeling using all advanced features and techniques.

The first section covers the basics of data modeling, discussing various modeling concepts and techniques, including whether to use the data model or Power Query for transformations, calculated columns and DAX, and handling role-playing dimensions. Participants will learn how to create a well-working and performing data model in Power BI and understand the basic dimensional modeling concepts.

The second section focuses on more advanced topics, including different types of relationships, overcoming ambiguity, and successfully implementing aggregations. Participants will also learn about different types of storage modes, including DirectQuery and Imported (cached) data, and how to handle them in the same model, as well as composite models with Power BI datasets and/or (Azure) Analysis Services.

The final section covers expert-level modeling by discussing calculation groups and their behavior in composite models. The session provides real-life examples, giving participants a list of tips and tricks that can be applied directly to their work.

Upon completion of this precon, participants will be able to understand and explain different modeling concepts, decide when to use Power Query vs. the data model, and when to use calculated columns or measures. They will also be able to handle complex situations with inactive relationships and role-playing dimensions, leverage one and bi-directional relationships, and overcome ambiguous data models. Additionally, participants will learn how to work with real-life scenarios containing multiple fact tables, understand and explain different types of storage modes in Power BI, and successfully implement calculation groups in composite models.

Marc Lelijveld

Data Platform MVP | Technical Evangelist | Solution Architect Data Solutions & Insights

Haastrecht, The Netherlands

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top