Workday HCM Demo New Batches Starting from Tuesday... 01-11-2016
Search Course Here

Live Chat
SQL Server Analysis Services  Online Training

SQL Server Analysis Services


>Microsoft SQL Server Analysis Services, SSAS, is an online analytical processing (OLAP), data mining and reporting tool in Microsoft SQL Server. SSAS is used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables. Microsoft has included a number of services in SQL Server related to business intelligence and data warehousing. These services include Integration Services and Analysis Services. Analysis Services includes a group of OLAP and data mining capabilities.
  • All attendees should have prior experience with SQL Server 2012.
  • It is a 12 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

  • It is a 3 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
    Private Classroom arranged on request and minimum attendies for batch is 4.
course content
  • Introduction
  • What Is Microsoft Business Intelligence?
    • Define Business Intelligence
    • 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 Modeling
    • Understand Basic OLAP Modeling (star schema)
    • Understand Dimensional Modeling (stars and snowflakes)
    • Understand Measure (fact) and Cube Modeling
  • Introduction to SQL Server Data Tools (SSDT)
    • Create Data Sources
    • Create Data Source Views
    • Create Cubes by using the Cube Wizard
    • Understand the Development Environment
  • 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
  • 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 2012
  • 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
  • Introduction to Data Mining
    • Understand Data Mining Concepts
    • Review the Algorithms that SSAS Includes
    • Consider Data Mining Clients
    • Understand Mining Structure Processing
  • SSAS Administration
    • Implement SSAS Security
    • Implement XMLA Scripts in SSMS
    • Deploy and Synchronize Databases
    • Understand SSAS Database Backup and Restore
  • Advanced Administration and Optimization
    • Implement SSIS to Manage SSAS Databases
    • Explore Clustering
    • Explore Scalability Options
    • Understand Performance Tuning and Optimization
  • Introduction to SSAS Clients
    • Design Reports using Reporting Services
    • Design Reports by using Report Builder
    • Implement Excel 2007 Pivot Tables and Charts
    • Use Excel 2007 as a Data Mining Client
    • Review Microsoft Office SharePoint Server 2007
  • Conclusion
SQL Server Analysis Services videos will be updated soon
To Watch More Videos Click Here

Flash News

AngularJS New Batch Start From 28th OCT & 29th OCT.

Hadoop Dev New Batch Start From 29th OCT & 30th OCT.

IBM COGNOS TM New Batch Start From 30th OCT & 31th OCT.

Informatica Dev New Batch Start From 31th OCT & 01st Nov.

Mean Stack New Batch Start 01st Nov & 02nd Nov.

SAP BODS new Batch Starting From 02nd Nov & 03rd Nov.

SAP S/4 HANA New Batch Start From 03rd Nov & 04th Nov

Tableau New Batch Start From 04th Nov & 05th Nov


Workday HCM Demo Training

Demo Schedule : 09:30P.M EST / 08:30P.M CST / 06:30P.M PST on 31st OCT & 07:00A.M IST on 01st NOV
Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :