Training For MS SSAS

SSAS Training Course Content

SSAS Training In Pune

Course Info

SSAS Training In Pune & SSAS Training In Vishrantwadi

SSAS Training at enosislearning.com is carefully designed to involve Datawarehouse Implementation, OLAP Data Modelling, Cube Development, Dimension Modelling, MDX Programing, DAX Expressions, MDX & DAX Reports, Data Mining with Forecasts and Tuning and Debugging operations. Classes are completely practical and interactive with one real-time Case Study.

Program Objectives

  • Leverage SQL Server Analysis Services to produce BI solutions
  • Create OLAP cubes and automate maintenance with XMLA scripts
  • Extend hierarchies and exploit advanced dimension relationships
  • Build custom solutions with MDX
  • Implement key performance indicators to monitor business objectives
  • Make smarter business decisions with data-mining techniques

Enosis Learning Advantage

  • More than 6 Years of experience in SSAS Training
  • Trained 40+ Students so far.
  • Strong Theoretical & Practical Knowledge
  • SSAS certified Professionals
  • Certified Trainers from the IT industry with rigorous understanding of specialized domain.
  • Lecture contents prepared by Industry expert
  • Live Projects to work on with IT industry standards.
  • Focus on cross cultural and various onshore and offshore client oriented trainings
  • Weekly workshop from industry experts
  • An innovative teaching methodology delivers in- depth knowledge with quality tailored programs that maximize a return on your investment.
  • Strategic Association for global certification

Eligibility

  • SQL Server T-SQL Queries
  • Tuning to join this Real-time Practical SSAS Training Course.

Program Structure

The course will have regular classroom Lectures, Practical Sessions, Seminars, Tutorials, Case Studies, Assignments and Exams.

Duration

3 Months

Syllabus

INTRODUCTION TO SSAS

  • Introduction to SSAS
  • Understand the Cube Structure
  • Deploy and View a Sample Cube
  • View a Cube by using Excel
  • View a Cube by using SQL Reporting Services

OLAP MODELLING

  • Understand Basic OLAP Modeling(star schema)
  • Understand Dimensional Modeling (stars and snowflakes)
  • Understand Measure (Fact) and Cube Modeling
  • Model with SQL Server Business Intelligence
  • Development Studio (BIDS)

USING SSAS IN BIDS

  • Understand the Development Environment
  • Create Data Source
  • Create Data Source Views
  • Create Cubes by using the Cube Wizard

INTERMEDIATE SSAS

  • Learn how to Create Key Performance Indicators(KPIs)
  • Discover how to Create Perspectives
  • See how to Create Translations for Cubes and Dimensions
  • Review the three SSAS Action Object Types: Regular, Drillthrough, and Reporting

INTRODUCTION TO DATA MINING

  • Understand Data Mining Concepts
  • Review the Algorithms that SSAS Includes
  • Consider Data Mining Clients
  • Understand Mining Structure Processing

ADVANCED SSAS

  • Work with Multiple Fact Tables and the Dimension usage Subtab in BIDS
  • Explore Advanced Dimension Types
  • Learn how to use the Business Intelligence Wizard
  • Understand Writeback in Dimensions
  • Review Semi-Additive Measures in OLAP Cubes

CUBE STORAGE AND AGGREGATION

  • View Aggregation Designs
  • Customize Aggregation Designs
  • Implement Proactive Caching
  • Use Relational and SSAS Partitions
  • Customize Cube and Dimension Processing

INTRODUCTION TO MDX QUERIES

  • Understand Basic MDX Syntax
  • Use the MDX Query Editor in SSMS
  • Understand Common MDX Functions and Tasks
  • Review MDX Functions New to SSAS 2008

MDX EXPRESSIONS

  • Understand the Calculation Subtab
  • Learn how to add Calculated Members
  • Explore how to add MDX Script Commands
  • Discover how to add .NET Assemblies