Showing posts with label MDX. Show all posts
Showing posts with label MDX. Show all posts

Tuesday, September 1, 2015

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