MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition by Sherry Li

Key FeaturesUpdated for SQL Server 2016, this book helps you take advantage of the new MDX commands and the new features introduced in SSASPerform time-related, context-aware, and business related-calculations with ease to enrich your Business Intelligence solutionsCollection of techniques to write flexible and high performing MDX queries in SSAS with carefully structured examplesBook DescriptionIf youre often faced with MDX challenges, this is a book for you. It will teach you how to solve various real-world business requirements using MDX queries and calculations.Examples in the book introduce an idea or a problem and then guide you through the process of implementing the solution in a step-by-step manner, inform you about the best practices and offer a deep knowledge in terms of how the solution works. Recipes are organized by chapters, each covering a single topic. They start slowly and logically progress to more advanced techniques.In case of complexity, things are broken down. Instead of one, there are series of recipes built one on top of another. This way you are able to see intermediate results and debug potential errors faster.Finally, the cookbook format is here to help you quickly identify the topic of interest and in it a wide range of practical solutions, that is – MDX recipes for your success.What you will learnGrasp the fundamental MDX concepts, features, and techniquesWork with setsWork with Time dimension and create time-aware calculationsMake analytical reports compact, concise, and efficientNavigate cubesMaster MDX for reporting with Reporting Services (new)Perform business analyticsDesign efficient cubes and efficient MDX queriesCreate metadata-driven calculations (new)Capture MDX queries and many other techniquesAbout the AuthorTomislav Piasevoli is a Business Intelligence (BI) specialist with years of experience working with Microsoft SQL Server Analysis Services (SSAS). He successfully implemented many still-in-use BI solutions, helped numerous people on MSDN forum, achieved the highest certification for SQL Server Analysis Services (SSAS Maestro), and shared his expertise in form of MDX cookbooks.Tomislav currently works as a consultant at Piasevoli Analytics company (www.piasevoli.com) together with his brother Hrvoje. They specialize in Microsoft SQL Server Business Intelligence platform, SSAS primarily, and offer their BI skills worldwide.In addition to his regular work, Tomislav manages to find the time to present at local conferences or to write an article or two for local magazines. His contribution to the community has been recognized by Microsoft honoring him with the Most Valuable Professional (MVP) award for six consecutive years (2009-2015).Sherry Li is an Analytic Consultant who works for a major financial organization with responsibilities in implementing data warehousing, Business Intelligence, and business reporting solutions. She specializes in automation and optimization of data gathering, storing, analyzing and providing data access for business to gain data-driven insights. She especially enjoys sharing her experience and knowledge in data ETL process, database design, dimensional modeling, and reporting in T-SQL and MDX. She has co-authored two books, the MDX with SSAS 2012 Cookbook and MDX with Microsoft SQL Server 2016 Analysis Services Cookbook, which have helped many data professionals advanced their MDX skill in a very short time. Sherry Li maintains her blog at bisherryli.com.Table of ContentsElementary MDX TechniquesWorking with SetsWorking with TimeConcise ReportingNavigationMDX for ReportingBusiness AnalysesWhen MDX is Not EnoughMetadata - Driven CalculationsOn the Edge