All Categories
Over 70 practical recipes to analyze multi-dimensional data in SQL Server 2016 Analysis Services cubesAbout This BookUpdated 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 examplesWho This Book Is ForThis book is for anyone who has been involved in working with multidimensional data. If you are a multidimensional cube developer, a multidimensional database administrator, or a report developer who writes MDX queries to access multidimensional cube, this book will help you. If you are a power cube user or an experienced business analyst, you will also find this book invaluable in your data analysis. This book is for you are interested in doing more data analysis so that the management can make timely and accurate business decisions.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 techniquesIn DetailIf you're 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