# Expert Data Modeling with Power BI

<a href="https://www.packtpub.com/product/expert-data-modeling-with-power-bi/9781800205697?utm_source=github&utm_medium=repository&utm_campaign=9781800205697"><img src="https://static.packt-cdn.com/products/9781800205697/cover/smaller" alt="Expert Data Modeling with Power BI" height="256px" align="right"></a>

This is the code repository for [Expert Data Modeling with Power BI](https://www.packtpub.com/product/expert-data-modeling-with-power-bi/9781800205697?utm_source=github&utm_medium=repository&utm_campaign=9781800205697), published by Packt.

**Get the best out of Power BI by building optimized data models for reporting and business needs**

## What is this book about?
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](https://www.amazon.com/dp/1800205694) today!

<a href="https://www.packtpub.com/?utm_source=github&utm_medium=banner&utm_campaign=GitHubBanner"><img src="https://raw.githubusercontent.com/PacktPublishing/GitHub/master/GitHub.png" alt="https://www.packtpub.com/" border="5" /></a>

## Instructions and Navigations
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]
)
```

**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).

### Software and Hardware List



| Chapter  | Software required                   | OS required                        |
| -------- | ------------------------------------| -----------------------------------|
| 1-12	   | Power BI Desktop                    | Windows, Mac OS X, and Linux (Any) |
| 1-12     | DAX Studio                          | Windows, Mac OS X, and Linux (Any  |
| 1-12     | Tabular Editor                      | Windows, Mac OS X, and Linux (Any  |



We also provide a PDF file that has color images of the screenshots/diagrams used in this book. [Click here to download it](https://static.packt-cdn.com/downloads/9781800205697_ColorImages.pdf). 


### Related products <Other books you may enjoy>
* Learn Power BI [[Packt]](https://www.packtpub.com/free-ebook/learn-power-bi/9781838644482) [[Amazon]](https://www.amazon.com/dp/1838644482)

* Microsoft Power BI Quick Start Guide [[Packt]](https://www.packtpub.com/product/microsoft-power-bi-quick-start-guide/9781789138221) [[Amazon]](https://www.amazon.com/dp/1789138221)

## Get to Know the Author

**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.	

