Microsoft SQL Server Analysis Services (SSAS) Course

What Is Microsoft BI?

• Core concept BI is the cube or UDM

• Example cube as seen using Excel pivot table

• MS BI is comprehensive more than Analysis Services on SQL Server

• Demonstration of SQL Reporting Services with cube as data source

Using SSAS in BIDS

• Understanding the development environment

• Creating Data Sources and Data Source Views

• Creating cubes using the UDM and the Cube Build Wizard

• Refining Dimensions and Measures in BID

Intermediate SSAS

• KPIs

• Perspectives

• Translations cube metadata and currency localization

• Actions regular, drill-through and reporting

Advanced SSAS

• Using multiple fact tables

• Modeling intermediate fact tables

• Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, write back dimensions

• Modeling changing dimensions Dimension Intelligence w/ Wizard

• Using the Add Business Intelligence Wizards write-back, semi-additive measures, time intelligence, account intelligence

Cube Storage and Aggregation

• Storage topics basic aggregations, MOLAP

• Advanced Storage Design MOLAP, ROLAP, HOLAP

• Partitions relational and Analysis Services partitions

• Customizing Aggregation Design Processing Design

• Rapidly changing dimensions / ROLAP dimensions

• Welcome to the Real Time Proactive Caching

• Cube processing options

MDX

• Basic syntax

• Using the MDX query editor in SQL Server Management Studio

• Adding calculated members

• Adding scripts

• Adding named sets

SSAS Administration

• Best practices health monitoring

• XMLA scripting (SQL Mgmt Studio)

• Security roles and permissions

• Disaster Recovery backup / restore

Introduction to Reporting Clients

• Excel 2007/ Power pivot

• SQL RS & Report Builder

• SharePoint Performance Point Services 2010