Published date: June 28, 2016 | 7:55 am | Posted by: SQLSchool
  • Location: Hyderabad, Hyderabad, Telangana, India

SQL School provides Interactive and Practical LIVE Online Trainings on T-SQL, SQL DBA and MSBI (SSIS, SSAS, SSRS). All sessions are completely PRACTICAL. No PPTs nor Screenshots during live sessions. We also provide Study and Practice Material.

Course Highlights for SQL Server Analysis Services (SSAS) Online Training:

Data Warehousing Principles and need for SSAS

Introduction to SSAS & Architecture

Understanding SSAS Components – Multidimensional and Tabular

OLAP Cubes and Data Warehouse Design

SSAS Cube Design Techniques

Advanced SSAS Design and Hierarchies

Multidimensional Cube Development Process

Tabular Cube Development Process

MDX Syntax, Functions, Uses and Rules

Defining Named Sets and Aggregates in MDX

SSAS KPIs and Functions – Multidimensional

SSAS KPIs and Functions – Tabular

SSAS Transactions and Types

XMLA Uses and Limitations

Partition Management and OLAP Storage Models

SSAS Audits and Usage Based Optimization (UBO)

Managing Multidimensional and Tabular OLAP Databases

Security Management with SQL Server Data Warehouses

Proactive Caching and Performance Tuning

OLAP Storage Models and Deployment Rules

Importing SSAS Projects and Reverse Engineering Techniques

Onsite Deployments and Cube uploads

Mining Extensions and Mining Algorithms

Performance Counters and SSAS Monitors

Migration Procedures and Upgradations

SSAS with SSIS Packaging

For complete SSAS course content -

Duration: 2 weeks, every day for 1.5 hours and all sessions are completely practical. One Case Study will be dealt during the sessions. All sessions are on LIVE environment.

We also provide SSIS and SSRS LIVE Online Trainings along with Real Time Case Studies. For free Demo and further training details, please contact us.

SQL School Training Institute

Office: (+91) 040 64577244

Mobile: (+91) 0 9666440801

Address: 108/2RT, Road No 1, SR Nagar, Land Mark: Beside Bus Stop, Hyderabad, India.

Ad ID: 25793

Share by email Share on Facebook Share on Twitter Share on Google+ Share on LinkedIn Pin on Pinterest

Contact seller Share

Useful information

  • Avoid scams by acting locally or paying with PayPal
  • Never pay with Western Union, Moneygram or other anonymous payment services
  • Don't buy or sell outside of your country. Don't accept cashier cheques from outside your country
  • This site is never involved in any transaction, and does not handle payments, shipping, guarantee transactions, provide escrow services, or offer "buyer protection" or "seller certification"

Related listings