Data modeling 101: Understanding the basics of a good data model
2022TL; DR
Learn everything about a good data model in Power BI!
Session Details
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? During this session we will lift of from basic level and build up in complexity to understand the key element of a good data model! Everything presented in this session will include real-life examples and can be directly brought to practice.
After this session 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.
3 things you'll get out of this session
Speakers
Marc Lelijveld's previous sessions
Data modeling for experts with Power BI
Want to level up your Power BI data modeling skills? During this session you will learn how to deal with different source groups, storage modes and composite models in Power BI. Also, how to avoid redundant measures by implementing calculations groups and the challenge that comes when you combine calculation groups with remote and local Power BI models.
Successfully collaborate with externals in Power BI
Get started with B2B collaboration in Power BI. Get to know which questions to ask, how to set it up and leave the room well equipped to get your collaboration started!
We will provide you with best practices and ways of working and give you a decision tree to help you even after the session to make the right decisions.
Advanced data modeling with Power BI
After understanding the basics, lets take the next step in data modeling in Power BI!
Enterprise and multi-tier Power BI deployments with Azure DevOps.
Govern your Power BI estate and setup your DTAP approach for Power BI using DevOps or native deployment pipelines!