SSAS

Introduction to SSAS

Need of OLAP Databases and DW
OLTP vs. OLAP

SSAS: Tabular & Multidimensional

DWH Architecture & OLAP

Cubes and Measures

Identifying Facts and Dimensions

Identifying Measures and Aggregates

Identifying Attributes and Hierarchies

DWH Design Principles

Staging operations and usages

SSAS Usage

Data Source and Data Source Views

Manipulating structures in DSV

Named Calculation and Named Queries

Building Entity Relationships

Deciding DWH Schema

Dimension Wizard and Attributes

Creating Dimensions and Builds

Attributes and Member Names

Choosing Dimension Templates

Applying Time Dimensions

Need for Hierarchies and Limitations

Attribute Relations and Uses

Building Levels and Hierarchies

Need for Composite Attribute Keys

Creating empty Dimensions

Cube Wizard and Relations

Cube Design, Identifying Cube Entries

Measures and Additives

Creating Measure Groups

Cube Customizations and Options

Cube Design Options

Dimension Usage

Building Fact Less Dimensions

Calculations and Conditional Colors

MDX Scripting for Calculations

Calculation Sets and Options

Defining KPIs and Goals using MDX

Perspectives using MDX Expressions

SSAS Actions with MDX and XMLA

Cube Partitions

Storage Models

Aggregations

MDX Functions, FILTERS and JOINS

MDX Language Syntax & Statements

MDX Functions & JOINS

Conditional MDX JOINS

Cube and Dimension Writebacks

MDX Transactions & Limitations

Deployment

Deployment Options and Pre-requisites

Deployment Process and Tools

Creating OLAP (SSAS) Databases

Processing Options and stages

Managing Deployment Process