Microsoft SSAS Online Training Hyderabad India

Click Here For Course Content.

SSAS: SQL Server Analysis Services Course Content


What Is Microsoft BI?


  • Core concept BI is the cube or UDM
  • Example cube as seen using Excel pivot table
  • MS BI is comprehensive  more than Analysis Services on SQL Server
  • Demonstration of SQL Reporting Services with cube as data source

Using SSAS in BIDS


  • 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 BID

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, write back 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

MDX


  • Basic syntax
  • Using the MDX query editor in SQL Server Management Studio
  • Adding calculated members
  • Adding scripts
  • Adding named sets

SSAS Administration


  • Best practices health monitoring
  • XMLA scripting (SQL Mgmt Studio)
  • Security roles and permissions
  • Disaster Recovery backup / restore

Introduction to Reporting Clients


  • Excel 2007/  Power pivot
  • SQL RS & Report Builder
  • SharePoint Performance Point Services 2010

Training Enquiry

If you are unable to reach our contact number, Please fill the above Enquiry Form, otherwise send an email to sudeeponlinetraining@gmail.com for quick response.