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

Reza Rad

Sep 2020 · RADACAD Systems Limited

Ebook

309

Pages

Eligible

Ratings and reviews aren’t verified Learn More

About this ebook

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.

About the author

Reza Rad is a Microsoft Regional Director[https://rd.microsoft.com/en-us/reza-rad], an Author, Trainer, Speaker, and Consultant. He has a BSc in Computer engineering; he has more than 20 years of experience in data analysis, BI, databases, programming, and development, mainly on Microsoft technologies. He is a Microsoft Data Platform MVP[https://mvp.microsoft.com/en-us/PublicProfile/4030647?fullName=Reza%20%20Rad] for 11 straight years (from 2011 till now) for his dedication to Microsoft BI. Reza is an active blogger and co-founder of RADACAD[https://radacad.com/]. Reza is also co-founder and co-organizer of the Difinity[http://difinity.co.nz/] conference in New Zealand, and the Power BI Summit[https://www.globalpowerbisummit.com/] (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 Data, Insights, and Power BI user group in Auckland, New Zealand (Since Microsoft Fast Track Recognized Solution Architect – Power Platform

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 be found on his blog: https://radacad.com/blog[https://radacad.com/blog].

He wrote some books on Microsoft BI and also is writing some others. He was also an active member on online technical forums such as MSDN and Experts-Exchange, was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the leader of the Power BI and Analytics users group[https://www.meetup.com/New-Zealand-Business-Intelligence-User-Group/]. He is also the author of the very popular book Power BI from Rookie to Rock Star[https://radacad.com/online-book-power-bi-from-rookie-to-rockstar], which is free with more than 1700 pages of content and the Power BI Pro Architecture[https://www.apress.com/gp/book/9781484240144]. He also wrote a book on Row-Level Security in Power BI[https://www.amazon.com/gp/product/B082SFR2J4], Basics of Power BI modeling[https://www.amazon.com/gp/product/B08HWNZ7GC] and Power BI DAX Simplified[https://www.amazon.com/gp/product/B099SBN1XP], which are valuable assets for Power BI users.

He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday, and user groups. And He is a Microsoft Certified Trainer.

LinkedIn: Reza Rad[https://www.linkedin.com/in/rezarad/]

Twitter: Reza Rad[https://twitter.com/Rad_Reza]

Rate this ebook

Tell us what you think.

Reading information

Smartphones and tablets

Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.

Laptops and computers

You can listen to audiobooks purchased on Google Play using your computer's web browser.

eReaders and other devices

To read on e-ink devices like Kobo eReaders, you'll need to download a file and transfer it to your device. Follow the detailed Help Center instructions to transfer the files to supported eReaders.

Report illegal content