MSBI SSAS Course Content

SQL Server 2014 Analysis Services

OLAP Modeling
    Modeling source schemas-stars and snowflakes
    Understanding dimensional modeling-Dimensions (Type 1, 2, or 3) or rapidly changing
    Understanding fact (measures) and cube modeling

Using SSAS in BIDS/Data Tools
    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 BIDS

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, writeback 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

Beginning MDX (All Basics)
    Basic syntax
    Using the MDX query editor in SQL Server Management Studio
    Most-used Functions & Common tasks
    New MDX functions

Intermediate MDX
    Adding calculated members
    Adding scripts
    Adding named sets

SSAS Administration
    Best practices – health monitoring
    XMLA scripting (SQL Mgmt Studio)
    Other Documentation methods
    Security – roles and permissions

SSAS Deployments

Thanks
SQL Srinivas
91-9059361460