Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Expert Data Modeling with Power BI, Second Edition

You're reading from   Expert Data Modeling with Power BI, Second Edition Enrich and optimize your data models to get the best out of Power BI for reporting and business needs

Arrow left icon
Product type Paperback
Published in Apr 2023
Publisher Packt
ISBN-13 9781803246246
Length 698 pages
Edition 2nd Edition
Languages
Arrow right icon
Author (1):
Arrow left icon
Soheil Bakhshi Soheil Bakhshi
Author Profile Icon Soheil Bakhshi
Soheil Bakhshi
Arrow right icon
View More author details
Toc

Table of Contents (22) Chapters Close

Preface 1. Section I: Data Modeling in Power BI
2. Introduction to Data Modeling in Power BI FREE CHAPTER 3. Data Analysis eXpressions and Data Modeling 4. Section II: Data Preparation in Query Editor
5. Data Preparation in Power Query Editor 6. Getting Data from Various Sources 7. Common Data Preparation Steps 8. Star Schema Preparation in Power Query Editor 9. Data Preparation Common Best Practices 10. Section III: Data Modeling
11. Data Modeling Components 12. Star Schema and Data Modeling Common Best Practices 13. Section IV: Advanced Data Modeling
14. Advanced Data Modeling Techniques 15. Row-Level and Object-Level Security 16. Dealing with More Advanced Data Warehousing Concepts in Power BI 17. Introduction to Dataflows 18. DirectQuery Connections to Power BI Datasets and Analysis Services in Composite Models 19. New Options, Features, and DAX Functions 20. Other Books You May Enjoy
21. Index

Index

A

absolute position 630

Access 128

Advanced Editor 102

AdventureWorksDW2019 database 586

Adventure Works organization 531

Agg Awareness 414

aggregation, managing 435-437

aggregation table, creating 429, 430

aggregation table, setting 433-435

approaches 427

dimensions storage mode, setting 433-435

relationships, creating 432

tables, loading in DirectQuery mode 430, 431

using 426-428

aggregation, at Date level

control measures, creating in base table 418

Internet Sales table, summarizing 415, 416

new measures, creating in summary table 418

relationships, creating 416, 417

summary table, hiding 419-421

aggregations

implementing, at Date level 415

implementing, at Year and Month level 421-426

implementing, for non-DirectQuery data sources 414

important notes 449, 450

managing 435-437

testing 438

using 413, 414

aggregation, testing options

DAX Studio 442, 443

...
lock icon The rest of the chapter is locked
arrow left Previous Section
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image