Expert Data Modeling with Power BI
This book shows you how to effectively use Power BI, covering everything from Fact tables and Dimension tables to different data modeling techniques. With the help of real-world scenarios, you'll be able to identify when, why, where, and how to prepare data to support an efficient Star Schema to satisfy business requirements.
Offered by
Difficulty Level
Intermediate
Completion Time
23h16m
Language
English
About Book
Who Is This Book For?
This MS Power BI book is for BI users, data analysts, and analysis developers who want to become well-versed with data modeling techniques to make the most of Power BI. Basic working knowledge of Power BI and the Star Schema functionality are required to help you to understand the concepts covered in this book.
Expert Data Modeling with Power BI
- About Book
- Who Is This Book For?
- Book Content
Book content
chapters • 23h16m total length
Introduction to Data Modeling in Power BI
Data Analysis eXpressions and Data Modeling
Data Preparation in Power Query Editor
Getting Data from Various Sources
Common Data Preparation Steps
Star Schema Preparation In Power Query Editor
Data Preparation Common Best Practices
Data Modeling Components
Star Schema and Data Modeling Common Best Practices
Advanced Data Modeling Techniques
Row-Level and Object-Level Security
Dealing with More Advanced Data Warehousing Concepts in Power BI
Introduction to Dataflows
DirectQuery Connections to Power BI Datasets and Analysis Services in Composite Models
New Options, Features, and DAX Functions
Related Resources
Access Ready-to-Use Books for Free!
Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!