Michiel Rozema – författare
Visar alla böcker från författaren Michiel Rozema. Handla med fri frakt och snabb leverans.
2 produkter
2 produkter
Extreme DAX
Take your Power BI and Microsoft data analytics skills to the next level
Häftad, Engelska, 2022
634 kr
Skickas inom 5-8 vardagar
Discover the true power of DAX and build advanced DAX solutions for practical business scenariosKey FeaturesSolve complex business problems within Microsoft BI tools including Power BI, SQL Server, and ExcelDevelop a conceptual understanding of critical business data modeling principlesLearn the subtleties of Power BI data visualizations, evaluation context, context transition, and filteringBook DescriptionThis book helps business analysts generate powerful and sophisticated analyses from their data using DAX and get the most out of Microsoft Business Intelligence tools.Extreme DAX will first teach you the principles of business intelligence, good model design, 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, forecasting, intercompany business, and data security. At each step, senior DAX experts will walk you through the subtleties involved in working with Power BI models and common mistakes to look out for as you build advanced data aggregations. You’ll deepen your understanding of DAX functions, filters, and measures, and how and when they can be used to derive effective insights. You’ll also be provided with PBIX files for each chapter, so that you can follow along and explore in your own time.What you will learnUnderstand data modeling concepts and structures before you start working with DAXGrasp how relationships in Power BI models are different from those in RDBMSesSecure aggregation levels, attributes, and hierarchies using PATH functions and row-level securityGet to grips with the crucial concept of contextApply advanced context and filtering functions including TREATAS, GENERATE, and SUMMARIZEExplore dynamically changing visualizations with helper tables and dynamic labels and axesWork with week-based calendars and understand standard time-intelligenceEvaluate investments intelligently with the XNPV and XIRR financial DAX functionsWho this book is forExtreme DAX is written for analysts with a working knowledge of DAX in Power BI or other Microsoft analytics tools. It will help you upgrade your knowledge and work with analytical models more effectively, so you’ll need practical experience with DAX before you can get started.
670 kr
Kommande
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.