Mail : training@ecorptrainings.com
India : +91-8143-111-555
USA : +1-703-445-4802
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

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




Live Chat
Support
SQL Server Analysis Services  Online Training

SQL Server Analysis Services

overview

>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.
prerequisties
  • All attendees should have prior experience with SQL Server 2012.
Duration
Online
  • It is a 12 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

Corporate
  • It is a 3 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
Classroom
    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
Videos
SQL Server Analysis Services videos will be updated soon
To Watch More Videos Click Here

Flash News


AngularJS New Batch Start From 09th OCT & 10th OCT.


Hadoop Dev New Batch Start From 10th OCT & 11th OCT.


IBM COGNOS TM New Batch Start From 11th OCT & 12th OCT.


Informatica Dev New Batch Start From 12th OCT & 13th OCT.


Mean Stack New Batch Start 13th OCT & 14th OCT.

SAP BODS new Batch Starting From 14th OCT & 15th OCT.

SAP S/4 HANA New Batch Start From 15th OCT & 16th OCT
.

Tableau New Batch Start From 16th OCT & 17th OCT

PUBLIC DEMO

(1) Workday Technical Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th OCT & 07:00A.M IST on 14th OCT

(2) SAP MII Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th OCT & 07:00A.M IST on 14th OCT

SOLVE YOUR QUERIES ONLINE
Email :
Rediff Bol :
ecorptrainings@rediffmail.com
Google Talk :
ecorptrainings@gmail.com
MSN Messenger :
ecorptrainings@hotmail.com
Yahoo Messenger :
ecorptrainings@yahoo.com
Skype Talk :
ecorptrainings