Free Sample
+ Collection

Microsoft SQL Server Analysis Services Demystified [Video]

Jen Stirrup

Design, implement, and deliver a successful business intelligence project with SQL Server Analysis 2012 Services
RRP $84.99

Want this title & more?

$12.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Video Details

ISBN 139781849689304
Course Length2 hours and 17 mins

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

Who This Video Is For

This video is for business intelligence developers and data analysts who do not have any SSAS multidimensional or tabular experience and who want to get started with the process of designing and implementing a project in SQL Server Analysis Services.

Table of Contents

SQL Server Analysis Prerequisites
Analysis Services Architecture
Dimensional Modeling Concepts
Business needs That Are Best Served by Analysis Services
SQL Server Management Studio
Understanding SQL Server Data Tools
Tabular Modeling
What Is a Tabular Model?
Key Glossary of Terms for Tabular Models
Relationships within a Tabular Model
Introduction to DAX
Calculated Columns versus Calculated Measures
Tabular Modeling for Analysis
Creating Calculated Columns
Creating a Calculated Measure
Creating KPIs
Creating Partitions
Creating Hierarchies
Tabular Modeling Management
Create Tabular Model Partitions and Hierarchies
Most Commonly Used DAX Expressions
Tabular Model Deployment – Cached Mode
Tabular Model Deployment – Production Mode
Tabular Model Backups
Multidimensional Modeling
Multidimensional Models and Their Best Uses
Multidimensional Model Types
Introduction to MDX
Advanced Use Cases of MDX
MDX versus DAX
Multidimensional Modeling for Analysis
Creating Multidimensional Model Dimensions
Creating Multidimensional Model Calculations
Creating Multidimensional Model Key Performance Indicators
Creating Multidimensional Attributes
Creating Multidimensional Model Partitions
Multidimensional Model Management
Multidimensional Measure Groups
Most Commonly Used MDX Expressions
Multidimensional Aggregation Designs
Multidimensional Model Process Options
Multidimensional Model Deployment Options
Visualizing Your Analysis Services Data
Visualizing Tabular Model Data with Power View
Visualizing Multidimensional Model Data with SSRS
Using Excel to Expose Your Tabular Data
Using Excel to Expose Your Multidimensional Data
Data Visualization Principles

What You Will Learn

  • Process, delete, and manage Analysis Services in Management Studio
  • Analyze data in a cube and write queries in MDX
  • Navigate around SQL Server Data Tools (SSDT) in order to build cubes and tabular models
  • Create multidimensional model Key Performance Indicators
  • Enrich your existing business data using DAX language to implement business rules using calculations
  • Improve the user experience by creating attributes within a dimension
  • Understand the difference between DAX and MDX in order to help you to determine the accuracy of the formula
  • Process and deploy the cube so that it optimally meets users needs

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.



Read More