MBSI Microsoft Business Intelligence Online Beginner level by Palium

Introduction to Analysis Services
Introduction
Business Intelligence Queries
Architecture Options
Database Developments
Development, Management and Client Tools
Summary

Dimensional Model Development
Introduction
Dimension wizard
Dimension designer
Unknown member
Attribute properties
Date dimension
User Hierarchies
Parent child hierarchy
Attribute relationship
Translation
Summary

Cube Development
Data Source and Data Source Views
Computed and Named Queries
Building Entity Relationships
Deciding Data Warehouse Schema
Creating Dimensions and Builds
Attributes and Member Names
Choosing Dimension Templates
Applying Time Based Dimensions
Need for Hierarchies and Limitations
Attribute Relations and Uses
Building Levels and Hierarchies
Need for Composite Attribute Keys

KPI Calculations and Partitioned Aggregations
Identifying Cube Entries for FASMI Rules
Measures and Additives (Full and Semi)
Defining Measure Groups and Measures
Cube Customizations and Options
BI Enhancements and Granularity
Building Fact Less Cube Dimensions
Calculations and Conditional Colors
MDX Scripting for Calculations
Defining KPIs and Goals using MDX
Perspectives using MDX Expressions
SSAS Actions with MDX and XMLA
Need for Cube Partitions and Query Binding
Local and Remote Server Partitions
Need for Storage Models MOLAP and ROLAP
Generation of Aggregations on Partitions
Storage Modes and Proactive Caching
Hierarchies and Relations in Tabular Mode

Security
Overview
User Security
Dimension Security
Cell Security
Administrator Security
Service amount configuration