Madzy Stikkelorum – författare & böcker

Microsoft Power BI Visual Calculations

Simplifying DAX

AvJeroen ter Heerdt,Madzy Stikkelorumm. fl.

Häftad, Engelska, 2025

377 kr

Skickas inom 7-10 vardagar

Seasoned experts Jeroen ter Heerdt, Madzy Stikkelorum, and Marc Lelijveld help you master visual calculations in Power BI for transformative data insights Microsoft Power BI Visual Calculations: Simplifying DAX is a comprehensive guide that demystifies the innovative feature of visual calculations in Power BI. Jeroen, a Principal Product Manager at Microsoft, Madzy, a Data Analytics Consultant, and Marc, a Microsoft Data Platform MVP, bring their extensive expertise to this book, offering you a practical approach to mastering visual calculations. The book is designed to simplify DAX, making it accessible to beginners and empowering you to transform raw data into actionable insights. You will learn to implement visual calculations, understand their benefits, and apply them effectively in real-world scenarios, ultimately enhancing your ability to make data-driven decisions.

By reading this book, you will:

Understand the fundamentals of visual calculations in Power BI Create your first visual calculation with step-by-step guidance Explore advanced concepts like resetting context in visual calculations Compare visual calculations with other Power BI calculation options Master the performance characteristics of visual calculations Utilize specific functions designed for visual calculations Implement practical use cases like running sums and moving averages Enhance visual calculations with regular DAX expressions Optimize operational processes using data-driven insights Unlock the full potential of Power BI for strategic decision-making

About This Book

For Power BI users who want to simplify DAX and unlock the full potential of visual calculations without the usual complexities For business executives, managers, and data enthusiasts looking to transform raw data into actionable insights for strategic decision-making

Extreme DAX

Take your Power BI and Fabric analytics skills to the next level

AvMichiel Rozema,Madzy Stikkelorumm. fl.

Häftad, Engelska, 2026

633 kr

Skickas inom 5-8 vardagar

Master advanced DAX in Power BI and Microsoft Fabric to build scalable semantic models, solve complex business problems, and deliver high-impact analytics using real-world scenarios and proven techniques.Key FeaturesSolve complex business problems with advanced DAX in Power BI and FabricBuild scalable semantic models using modern data modeling best practicesMaster evaluation context, calculation groups, and advanced DAX techniquesBook DescriptionThis book helps experienced analysts unlock the full potential of DAX in Power BI and Microsoft Fabric to build scalable, production-ready analytics solutions.You’ll begin by strengthening your understanding of semantic models, data modeling, and evaluation context—the foundation of reliable analytics. Instead of isolated examples, the book uses real-world scenarios such as inventory analysis, benchmarking, and data security to show how advanced DAX calculations are applied in practice.As you progress, you’ll master advanced techniques including context transition, table functions, calculation groups, field parameters, and custom calendars. You’ll also explore analytical methods such as regression and goal-seeking to generate deeper insights from your data.With step-by-step guidance and practical PBIX examples, you’ll learn how to design efficient models, avoid common pitfalls, and implement reusable calculations. By the end, you’ll be able to create advanced DAX measures and high-performance Power BI solutions for complex analytical requirements.What you will learnUnderstand semantic models and data modeling principlesMaster DAX evaluation context and context transitionBuild advanced DAX measures and calculationsUse table functions and filtering techniques like TREATASImplement calculation groups and field parametersCreate custom calendars and time intelligence solutionsApply regression and goal-seeking techniquesSecure data with attribute-level controlsWho this book is forExtreme DAX is written for analysts with some practical experience with DAX in Power BI, Fabric, or other Microsoft analytics tools. It will help you to upgrade your knowledge and work with analytical models more effectively. It explains new features that were recently added to the DAX language by not only introducing concepts but discussing sophisticated business scenarios as well. This way, Extreme DAX will inspire you to apply advanced DAX techniques in your own analytics projects.