O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft SQL Server Analysis Services Demystified

Video Description

Embark on the exciting journey of test automation, execution, and reporting in Test Studio with this practical tutorial

About This Video

  • Learn how to make the correct design choice between multidimensional and tabular models according to your project requirements

  • Learn the key implementation features of Analysis Services cubes and how to visualize data

  • An essential two hour course to get you familiar and productive with the basics of data analysis

  • In Detail

    Microsoft SQL Server is an enterprise database server with a multitude of technologies within it. SQL Server 2012 Analysis Services is one of those technologies that empowers users to analyze business data quickly and easily. However, designing cubes in Analysis Services can be a complex task: it's all too easy to make mistakes early on in development that lead to serious problems when the cube is in production. Learning the best practices for cube design before you start your project will help you avoid these problems and ensure that your project is a success.

    This practical video course teaches you how to make design decisions, manage multidimensional and tabular models, and finally visualize data to successfully deliver a business intelligence project.

    Microsoft SQL Server Analysis Services Demystified gives viewers an insight into the best practices for designing and building Microsoft Analysis Services 2012 cubes.

    Packed with real world tasks, this video course starts by helping you make design decisions, recognizing that this maximizes the successful delivery of a business intelligence project. You then get a walkthrough of the key concepts and terms that are common to both the multidimensional and tabular models of Analysis Services. Next, you will move onto key technical implementations of Analysis Services cubes, such as hierarchies, natural and unnatural relationships, and essential MDX expressions. Finally, you will learn about visualizing the data in DAX and MDX in order to expose the data accurately using Excel, Reporting Services, and Power View.

    This video course is an invaluable tutorial for anyone who is planning to use Microsoft Analysis Services 2012 in a business intelligence project.

    Table of Contents

    1. Chapter 1: SQL Server Analysis Prerequisites
      1. Analysis Services Architecture 00:03:12
      2. Dimensional Modeling Concepts 00:03:10
      3. Business needs That Are Best Served by Analysis Services 00:03:14
      4. SQL Server Management Studio 00:03:20
      5. Understanding SQL Server Data Tools 00:03:20
    2. Chapter 2: Tabular Modeling
      1. What Is a Tabular Model? 00:04:27
      2. Key Glossary of Terms for Tabular Models 00:04:23
      3. Relationships within a Tabular Model 00:03:12
      4. Introduction to DAX 00:03:10
      5. Calculated Columns versus Calculated Measures 00:03:04
    3. Chapter 3: Tabular Modeling for Analysis
      1. Creating Calculated Columns 00:03:14
      2. Creating a Calculated Measure 00:03:15
      3. Creating KPIs 00:03:05
      4. Creating Partitions 00:05:29
      5. Creating Hierarchies 00:04:34
    4. Chapter 4: Tabular Modeling Management
      1. Create Tabular Model Partitions and Hierarchies 00:03:08
      2. Most Commonly Used DAX Expressions 00:03:03
      3. Tabular Model Deployment – Cached Mode 00:03:11
      4. Tabular Model Deployment – Production Mode 00:04:02
      5. Tabular Model Backups 00:03:28
    5. Chapter 5: Multidimensional Modeling
      1. Multidimensional Models and Their Best Uses 00:03:09
      2. Multidimensional Model Types 00:02:54
      3. Introduction to MDX 00:03:07
      4. Advanced Use Cases of MDX 00:03:35
      5. MDX versus DAX 00:03:27
    6. Chapter 6: Multidimensional Modeling for Analysis
      1. Creating Multidimensional Model Dimensions 00:03:55
      2. Creating Multidimensional Model Calculations 00:03:20
      3. Creating Multidimensional Model Key Performance Indicators 00:03:11
      4. Creating Multidimensional Attributes 00:03:32
      5. Creating Multidimensional Model Partitions 00:03:40
    7. Chapter 7: Multidimensional Model Management
      1. Multidimensional Measure Groups 00:03:31
      2. Most Commonly Used MDX Expressions 00:03:15
      3. Multidimensional Aggregation Designs 00:03:40
      4. Multidimensional Model Process Options 00:03:55
      5. Multidimensional Model Deployment Options 00:03:21
    8. Chapter 8: Visualizing Your Analysis Services Data
      1. Visualizing Tabular Model Data with Power View 00:03:09
      2. Visualizing Multidimensional Model Data with SSRS 00:03:05
      3. Using Excel to Expose Your Tabular Data 00:03:50
      4. Using Excel to Expose Your Multidimensional Data 00:03:34
      5. Data Visualization Principles 00:02:59