SSAS

SQL DESCRIPTION

 

 



SQL SERVER ANALYSYS SERVICES

     Introduction to Data Warehousing Concepts

  • What is Data Warehousing?
  • Need for Data warehousing
  • OLTP Databases Vs. DW
  • Multi-dimensionality
  • Star Schema

    Introduction to Analysis Services

  • Need for SSAS
  • Fundamentals of Analysis Services 2005 and 2008
  • Architecture of SSAS
  • FASMI Rules
  • Configuration of SSAS
  • SSAS and SQL Server Browser Service
  • Integration with SQL Server Components
  • Analysis Services Components Overview

   Designing Analysis Services Projects

  • Data Preparation
  • Starting an Analysis Services Project
  • Hierarchies and Attributes
  • Dimension Design
  • Cube Design
  • Basic Browsing

   Advanced SSAS Design

  • MDX Queries
  • Creation of Sub Cubes
  • Partitions and Aggregations
  • Slowly Changing Dimensions (SCD)
  • Perspectives
  • Permissions and Roles

   Managing Analysis Services

  • Analysis Services Configuration
  • Deployment Options
  • Processing Types
  • Browsing Cubes
  • Security Management
  • Importing SSAS Project

 

 



For more details please contact here............
USA Contact:-+1-914-885-1413  ||  +1-949-209-8994 India Contact:-+91-40-60504560  ||  +1-914-885-1413 Email:-Info@globalitfamily.com



For more details please contact here............
USA Contact:-+1-914-885-1413  ||  +1-949-209-8994 India Contact:-+91-40-60504560  ||  +1-914-885-1413 Email:-Info@globalitfamily.com


Take a Free Demo class

Submit your enquire here

© 2013 : Global IT Family. All Rights Reserved