Data modeling is the single most overlooked feature in the Power BI Desktop, yet it's what sets Power BI apart from other tools on the market. This practical book serves as your fast-forward button for data modeling with Power BI, Analysis Services tabular, and SQL databases. It serves as a starting point for data modeling, as well as a handy refresher. Author Markus Ehrenmueller-Jensen, founder of Savory Data, shows you the basic concepts of Power BI's data model with hands-on examples in DAX, Power Query, and T-SQL. If you're looking to build a data warehouse layer, chapters with T-SQL examples will get you started. You'll begin with simple steps and gradually solve more complex problems. The first part of this book will introduce you to the necessary concepts in a general way, which is written in an agnostic way: You can apply this to any analytical system. In the second part you will learn about the properties of a data model in Power BI. The rest of this book works its way over DAX, Power Query to SQL. The book is designed for you, the reader, to have an individual experience, based on your knowledge. You may not know DAX, Power Query and SQL. But it is up to your choice, to pick and choose to fill in gaps in your knowledge.