In this course, you will:

    *      Learn to define what Business Intelligence is and how it applies to a database.
    *      Understand how the cube structure works for viewing data information.
    *      View cubes using Excel 2007 and SQL Reporting Services.
    *      See how to create cube models using SQL Server Business Intelligence Development Studio (BIDS).
    *      Create Data Source, Data Source Views and then create cubes with the Cube Wizard.
    *      Learn how to create key performance indicators (KPIs).
    *      Work with changing and advanced dimension types.
    *      Use relational and SSAS partitions.
    *      Understand how to use MDX syntax for queries, functions and tasks.
    *      Learn data mining concepts and mining structure processing.
    *      Implement security, XMLA scripts, backups and restores for SSAS.

Prerequisites: This course does not require any prior experience with Analysis Server 2008. It is assumed that students have working experience with SQL Server 2005 or 2008; basic relational database concepts (e.g., tables, queries, and indexing); data transformation services; Excel 2007; and SharePoint Server 2007.