Basics of Power BI Modeling: The fundamental lessons of building a data model that works best for Power BI solutions

I have been dealing with many Power BI challenges in my professional life as a Power BI consultant and a trainer. Challenges normally come as calculation or DAX questions, or sometimes as a performance question. However, after digging deeper into the problem, soon, it will be revealed that the problem is related to a more fundamental challenge; data modeling.If you have a Power BI implementation with many calculation-related or performance-related issues, I strongly suggest looking into your data model because that is where most of the problems start.A good data model is a great base, which upon that, you can build up many stories of calculations and analysis. A bad data model causes problems on every level that you add upon it, and might sometime cause the whole solution to collapse.Fortunately, data modeling is not rocket science. I explained the basic principles of the data modeling with examples in this book. Use this book as the learning path towards a better data model. Most of the tips mentioned in this book are product-agnostic (such as star-schema, dimension, and fact tables). However, this book is particularly designed and developed for a Power BI product user.This book is for you if you are building a Power BI solution. If your task is only visualizing the existing data, this book might not be needed for you. However, What I have seen in many cases, is that the requirement starts with just visualize the data, and then more data tables appear, and you get into the tunnel of data modeling without knowing the principles of it. This book is a guide for you through that tunnel.

Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker, and Consultant. He has more than 20 yearsof experience in data analysis, BI, databases, programming, and development,mainly on Microsoft technologies. He is a MicrosoftData Platform MVP for 11 straight years (from 2011 till now).Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of the Difinity conference in New Zealand, and the PowerBI Summit (the biggest Power BI conference)

• CEO at RADACAD
• Chairman and Director at Power BI Summit
• Chairman and Director at Difinity conference (Since 2017)
• Microsoft Regional Director (Since 2018)
• Microsoft Data Platform MVP (Since 2011)
• Leader of Power BI user group in Auckland, New Zealand
• Power BI All-Star award winner
• Microsoft Power Platform Fast Track Solution Architect - Power BI
• Dynamic Communities Emerald award winner
• Author of more than ten books on BI, analytics, and Power BI
• Speaker at many conferences such as Ignite, Microsoft Business Applications Summit, PASS, etc.
• Blogger and content creator
• Consultant and trainer
• Microsoft Certified trainer
• Microsoft Certified professional

His articles on different aspects of technologies, mainly on BI, can befound on his blog.
He is an MCP, MCSE, and MCITP of BI. He is the leader of theNew Zealand Business Intelligence users group. He wrote morethan 10 books. He is also the author of the very popular book PowerBI from Rookie to Rock Star, and the PowerBI Pro Architecture. He also wrote a book on Row-LevelSecurity in Power BI and Power BI DAX Simplified, which are valuable assets for Power BI users.
He is an International Speaker in Microsoft Ignite, Microsoft BusinessApplications Summit, Data Insight Summit, PASS Summit, SQL Saturday, anduser groups. And He is a Microsoft Certified Trainer.