You're reading from Expert Data Modeling with Power BI Get the best out of Power BI by building optimized data models for reporting and business needs

Product type Paperback

Published in Jun 2021

Publisher Packt

ISBN-13 9781800205697

Length 612 pages

Edition 1st Edition

Languages

DAX

Tools

Power BI

Concepts

Data Analysis

Author (1):

Soheil Bakhshi

View More author details

Table of Contents (18) Chapters

Preface

1. Section 1: Data Modeling in Power BI

2. Chapter 1: Introduction to Data Modeling in Power BI FREE CHAPTER

3. Chapter 2: Data Analysis eXpressions and Data Modeling

4. Section 2: Data Preparation in Query Editor

5. Chapter 3: Data Preparation in Power Query Editor

6. Chapter 4: Getting Data from Various Sources

7. Chapter 5: Common Data Preparation Steps

8. Chapter 6: Star Schema Preparation in Power Query Editor

9. Chapter 7: Data Preparation Common Best Practices

10. Section 3: Data Modeling

11. Chapter 8: Data Modeling Components

12. Chapter 9: Star Schema and Data Modeling Common Best Practices

13. Section 4: Advanced Data Modeling

14. Chapter 10: Advanced Data Modeling Techniques

15. Chapter 11: Row-Level Security

16. Chapter 12: Extra Options and Features Available for Data Modeling

17. Other Books You May Enjoy

Leave a review - let other readers know what you think

Time intelligence and data modeling

Time intelligence is one of the most powerful and commonly used functionalities in Power BI. For those coming from a SQL development background, it will be pretty clear how hard it is to build time intelligence analysis in a relational database system such as SQL Server. These complex calculations are made easy in Power BI by just a handful of time intelligence functions. This section briefly looks at the common challenges of working with time intelligence functions in Power BI.

Note

Our aim in this book is not to teach you how to use DAX functions; we just cover some more relevant data modeling concepts.

There are currently 35 time intelligence functions available in Power BI. You can find the complete list of functions on the Microsoft website: https://docs.microsoft.com/en-us/dax/time-intelligence-functions-dax.