Over 70 practical recipes to analyze multi-dimensional data in SQL Server 2016 Analysis Services cubes About This Book Updated for SQL Server 2016, this book helps you take advantage of the new MDX commands and the new features introduced in SSAS Perform time-related, context-aware, and business related-calculations with ease to enrich your Business Intelligence solutions Collection of techniques to write flexible and high performing MDX queries in SSAS with carefully structured examples Who This Book Is For This 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 Learn Grasp the fundamental MDX concepts, features, and techniques Work with sets Work with Time dimension and create time-aware calculations Make analytical reports compact, concise, and efficient Navigate cubes Master MDX for reporting with Reporting Services (new) Perform business analytics Design efficient cubes and efficient MDX queries Create metadata-driven calculations (new) Capture MDX queries and many other techniques In Detail If 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-step manner, inform you about the best practices and offer a deep knowledge in terms of how the solution works. Recipes are
Tomislav Piasevoli is a Business Intelligence (BI) Specialist with years of experience with Microsoft SQL Server Analysis Services (SSAS) and Data Warehousing (DW) in general. He successfully implemented many still-in-use DW/BI solutions, achieved the highest certification for SQL Server Analysis Services (SSAS Maestro) and shared his expertise in form of the book "MDX with SQL Server 2008 R2 Analysis Services: Cookbook" and its sequel, "MDX with SSAS 2012 Cookbook", both published by Packt Publishing Ltd.
As the Principal Consultant of Piasevoli Analytics Ltd company (www.piasevoli.com) Tomislav helps clients in various industries to run their business better by making use of their data and by optimizing their processes. Besides dimensional modelling, cube design and MDX, which are his core specialties, his work activities often include one or more of the following: data analysis, data integration and transformation, reporting as well as business-related consultations.
In addition to his regular work, Tomislav presents at local conferences and user groups, writes articles for magazines and finds pleasure in his children and hobbies. His contribution to the community was recognized by Microsoft honoring him with the Most Valuable Professional (MVP) award for 6 consecutive years.
Sherry Li has worked with Microsoft SQL Server Business Intelligence stacks for many years. She lives in Phoenix, Arizona where she works as a Data Analytic Consultant for a major financial organization with responsibilities in implementing data warehouse, Business Intelligence, and data analytic solutions. In an environment of large amounts of data from multiple sources, she specializes in data integration, system performance tuning for ETL and data query, dimensional modeling, cube design and build, and reporting and data analytics in MDX and T-SQL. Sherry Li maintains her blog at bisherryli.com.
