This book helps business analysts generate powerful and sophisticated analyses from their data using DAX and get the most out of the modern Microsoft analytics platform based on Power BI and Fabric.
Extreme DAX will first teach you the principles of business intelligence, good model design, semantic model architectures, and how DAX fits into it all. Then, you'll launch into detailed examples of DAX in real-world business scenarios such as inventory calculations, real estate planning, benchmarking, and data security. At each step, senior DAX experts will walk you through the subtleties involved in working with semantic models and common mistakes to look out for as you build advanced data aggregations.
You'll deepen your understanding of DAX functions, visual calculations, and measures, and how and when they can be used to derive effective insights. You’ll also learn about more advanced techniques like field parameters, calculation groups, user-defined functions and custom calendars. For each chapter, you'll be provided with PBIX files so that you can follow along and explore in your own time

Zobacz także:

• Data Science w Pythonie. Kurs video. Przetwarzanie i analiza danych 149,00 zł, (67,05 zł -55%)
• Excel 2013. Kurs video. Poziom drugi. Przetwarzanie i analiza danych 79,00 zł, (35,55 zł -55%)
• Kompletny przewodnik po Power Query (M). Opanuj wykonywanie z 169,00 zł, (84,50 zł -50%)
• OSINT w praktyce. Jak gromadzi 67,00 zł, (33,50 zł -50%)
• Mistrz analizy danych. Od danych do wiedzy. Wydanie II 99,00 zł, (49,50 zł -50%)

Spis treści

Extreme DAX. Take your Power BI and Fabric analytics skills to the next level - Second Edition eBook -- spis treści

• 1. DAX in Business Intelligence
• 2. Model design
• 3. Using DAX
• 4. Context en filtering
• 5. Security with DAX
• 6. Dynamically changing visualizations
• 7. My immediate neighbourgs
• 8. Alternative Calendars
• 9. Working with autoexists
• 10. Exploring the future: forecasting & future values
• 11. Inventory analysis
• 12. Selling platform pay-out
• 13. Personnel planning vs workload