This is the code repository for Expert Data Modeling with Power BI, published by Packt.
Get the best out of Power BI by building optimized data models for reporting and business needs
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 knowledge of Power BI and Star Schema will help you to understand the concepts covered in this book.
This book covers the following exciting features:
- Implement virtual tables and time intelligence functionalities in DAX to build a powerful model
- Identify Dimension and Fact tables and implement them in Power Query Editor
- Deal with advanced data preparation scenarios while building Star Schema
- Explore best practices for data preparation and data modeling
- Discover different hierarchies and their common pitfalls
- Understand complex data models and how to decrease the level of model complexity with different data modeling approaches
If you feel this book is for you, get your copy today!
All of the code is organized into folders. For example, Chapter02.
The code will look like the following:
Sequential Numbers =
SELECTCOLUMNS(
GENERATESERIES(1, 20, 1)
, "ID"
, [Value]
)
- In Chapter 1, page 26, the image should be:
Following is what you need for this book: You will need to download and install the latest version of Power BI Desktop. All expressions have been tested in the March release of Power BI Desktop and will work in the later versions released on later dates. In addition to Power BI Desktop, you will need to install and use DAX Studio and Tabular Editor.
With the following software and hardware list you can run all code files present in the book (Chapter 1-12).
| Chapter | Software required | OS required |
|---|---|---|
| 1-12 | Power BI Desktop | Windows 8.1 / Windows Server 2012 R2, or later |
| 1-12 | DAX Studio | Windows 8.1 / Windows Server 2012 R2, or later |
| 1-12 | Tabular Editor | Windows 8.1 / Windows Server 2012 R2, or later |
We also provide a PDF file that has color images of the screenshots/diagrams used in this book. Click here to download it.
Soheil Bakhshi is the founder of Data Vizioner and is a sought after BI consultant. Working in data and analytics for more than 20 years, Soheil’s experience lies in Microsoft BI, Data Warehousing, and Power BI platform. He possesses MSCE, MCSA certifications and is a Microsoft MVP (Most Valuable Professional). He has a passion for sharing knowledge via his website and speaking at conferences and Power BI community events locally and globally. In following his desire for simplicity and efficiency, he is behind Power BI community tools and commercial products such as Power BI Exporter and Power BI Documenter.