Data modeling is another fundamental function that distinguishes Power BI Desktop, but users do not understand it well. This is a straightforward guide to ‘’Data Modeling with Microsoft Power BI,’’ it will get the learners up and running with data modeling using Power BI, Analysis Services tabular, and SQL databases. Inexperienced users and those who require a short course on the application of Power BI’s semantic model will find it especially useful.
Written by Markus Ehrenmueller Jensen, the founder of Savory Data, this book describes the concept of data modeling using DAX, Power Query, and T-SQL, starting from the fundamentals. The book’s chapters contain a T-SQL set of examples that will help a reader create a Data Warehouse. The book's contents are built up step by step to prevent difficulties, and they could be called easy to understand.
You will be taught the method for normalization and denormalization of data, how to handle the best data for calculation and dimension, and how to deal with tough issues such as budget and composite models. Another valuable guide that I can recommend is the book “Data Modeling with Microsoft Power BI.” Together with describing the process of data modeling, the book also contains a detailed guideline on how to work with such problems as performance issues, tables, relationships, and ETL processes.
Data Modeling with Microsoft Power BI Table of Contents:
- Part I: Data Modeling 101
- Part II: Data Modeling in Power BI
- Part III: Data Modeling for Power BI with the Help of DAX
- Part IV: Data Modeling for Power BI with the Help of Power Query
- Part V: Data Modeling for Power BI with the Help of SQL
Who is this course for?
- Power BI Users: Anyone working with Power BI Desktop who is willing to level up the data modeling capabilities.
- Beginners: Beginners to data modeling and those who want a step-by-step introduction to such.
- Data Professionals: Those who crave Power BI technical knowledge to improve their capability in using Power BI.
- SQL Developers: Data professionals consistently working with SQL databases desiring to expand their competency in Power BI and Analysis Services tabular.
- Business Intelligence Enthusiasts: This information is useful to those who work on the construction and further fine-tuning of data warehouse layers.
