MS304: Implementing SSAS Tabular Cube

MS304: Implementing SSAS Tabular Cube

 

Overview, 

Looking for faster and easier access to data insights? Take a deep dive into in-memory databases, known as tabular models, supported by SQL Server Analysis Services (SSAS) tools in SQL Server 2012 and SQL Server 2014. Learn to enrich the data model to meet analytical requirements, get the details on DAX queries for custom reporting, and hear tips and techniques for near real-time solutions.

 

Agenda, 

01 | Introduction to Developing a Tabular Model in SQL Server Data Tools (SSDT)

Analysis Services Tabular Overview

Tabular Model Architecture and Installation

Workign with Tabular Model

02 | Designing the Data Model in Tabular

Creating a New Tabular Solution
Importing from Power Pivot
Deploying Tabular Solutions

03 | Enriching the Data Model with Calculated Measures and Data Analysis in DAX

Developing Analytical Calculations
Introduction to DAX Patterns
Building Data Model for Interactivity

04 | Overview of Querying Data Model with DAX

Introduction to DAX Syntax
Writing DAX Queries Outside SSMS
Using DAX Queries in Practical

05 | Administering and Securing Tabular Model

Administering Tabular Model
Securing Tabular Server
Securing Tabular Model

06 | Near Real-Time Strategy in Tabular Model

Understanding Near Real Time Requirements
Tabular Model Modes Overview
Deciding which Mode to Use

07 | Gotchas, Tips, and Tricks in Tabular Model Development

Understanding Limitations of Tabular Model
Using Change Management Tools
Visualizing Tabular Based Data

08 | Wrap Up and Next Step