Optimizing DAX, 2E by Alberto Ferrari (.ePUB)
File Size: 27.1 MB
Optimizing DAX: Improving DAX performance in Microsoft Power BI and Analysis Services, 2nd Edition by Alberto Ferrari, Marco Russo
Requirements: .ePUB reader, 27.1 MB
Overview: This book is the state of the art of optimizing DAX expressions in Power BI and Analysis Services semantic models. Learn how to locate performance bottlenecks, read the query plan and performance metrics, rewrite the slower part of an expression, and measure the performance improvements. The content of this book is advanced. As such, it certainly does not start from scratch. We take for granted that the reader has an excellent knowledge of several topics: The DAX language. In the training, we never teach DAX concepts. Here, the goal is how to produce efficient DAX code. We will write a lot of DAX code together, taking it for granted that you will quickly understand the different formulas. If you are unfamiliar with DAX, we strongly suggest the Mastering DAX video course, “The Definitive Guide to DAX” book, and practicing the DAX language in your daily job for at least one year. Being proficient with DAX is an absolute requirement. The SQL language. The modules about DirectQuery use quite some SQL code. You do not need to master all the details about SQL. Still, you must be able to read and understand SQL code quickly and how indexes, column stores, and other relational database technologies may affect your query’s results and performance. We use Microsoft SQL Server in the book examples. You can apply the same concepts to other relational databases – even though you cannot use the same specific techniques described for Microsoft SQL Server. The book has many code samples in three languages: DAX, SQL, and xmSQL. You will learn xmSQL in this book, whereas you should already know DAX and SQL. Every language has a different style for code snippets that we present here to familiarize ourselves with. Prerequisites: proficiency in DAX and SQL (for DirectQuery), understanding of the Tabular engine used by semantic models, and familiarity with DAX Studio.
Genre: Non-Fiction > Tech & Devices
Free Download links: