Microsoft Business Intelligence - Analysis Services 2008 - Workshop 3 Days

Microsoft Business Intelligence - Analysis Services 2008 - Workshop 3 Days

 

  • Analysis Services 2008 Registration

    Sale Date Ended

    INR 5499
    Sold Out

Invite friends

Contact Us

Page Views : 1073

About The Event

Course Outline

  • Creating Multidimensional Analysis Solutions
    • Developing Analysis Services Solutions
    • Creating Data Sources and Data Source Views
    • Creating a Cube 
    • Assignment for cube creation and processing
  • Creating Advanced Measures and Calculations  
    • Using Aggregate Functions
    • Using MDX to Retrieve Values from a Cube
    • Creating Calculated Members
    • Calculation Scripting
    • Creating and Implementing KPIs
  • Advanced Dimension Design
    • Dimension Usage
    • Creating Reference Dimensions
    • Creating a Fact Dimension
    • Creating a Many-to-Many Dimension 

Advanced Design 

  • Working with Cubes and Dimensions
    • Configuring Dimensions
    • Defining Attribute Hierarchies
    • Sorting and Grouping Attributes
    • Assignment for grouping, sorting , formatting , Hierarchies
  • Interacting with a Cube
    • Implementing Actions
    • Implementing Translations
    • Using Write-back to Modify Analysis Services Data
    • Assignment pertaining to all the topics listed in this section
  • Retrieving Data from Analysis Services
    • Creating and Implementing Perspectives
    • Creating MDX Queries
    • Accessing Analysis Services Using Excel 
  • Implementing Security
    • Understanding Roles
    • Securing Administrative Access
    • Securing Data Access
  • Designing Aggregations
    • Understanding Aggregation Design
    • Using the Aggregation Design Wizard
    • Using the Usage-Based Optimization Wizard 

Production Management 

  • Managing Partitions and Database Processing
    • Working with Storage
    • Managing Analysis Services Processing
    • Working with Partitions
  • Managing Deployment
    • Deployment Overview
    • Deployment Mechanics
    • Deployment Using Business Intelligence       
    • Development Studio
    • Deployment Using the Deployment Wizard
    • Understanding Deployment Scripts
    • Migrating Databases and Disaster Recovery
  • Advanced Monitoring and Management Tools
    • Monitoring Analysis Services Using Windows Reliability And Performance Monitor
    • Monitoring Analysis Services Using SQL Server Profiler
    • Analysis Services Dynamic Management Views 


Certification Preparation and Tips:

Exam 70-448:
TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-448&locale=en-us#tab2

 

Venue Map