Data Modeling in Power BI
A robust data model is essential for performant reports; poor design can cause issues. This course teaches you to model data in Power BI, manage table relationships, implement star/snowflake schemas, and use DAX and optimize for performance.
What you'll learn
Creating and maintaining a data model that is performant and scalable is a difficult task, especially when dealing with a complex set of data.
In this course, Data Modeling in Power BI, you’ll gain the ability to produce a model that is performant and provides a solid foundation for your reporting requirements.
First, you’ll explore how to model your data using relationships into either a star or snowflake schema.
Next, you’ll discover how to create DAX columns and DAX measures.
Finally, you’ll learn how to optimize your model to improve performance.
When you’re finished with this course, you’ll have the skills and knowledge of data modeling in Power BI needed to create a data model that expertly supports your Power BI reports.
Table of contents
About the author
Ben is a Power BI & Data Specialist with a healthy interest in Microsoft BI and planning tools. He has over 30 years of customer and implementation experience, has been a Microsoft MVP for 14 years, is a frequent speaker at several European conferences, and blogs and creates videos on a semi-regular basis. He is actively engaged in providing consultancy to UK FTSE companies, and co-runs the Manchester Power BI User Group.