|
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 - http://sqlschool.com/SSAS-Online-Training.html
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
contact@sqlschool.com
Office: (+91) 040 64577244
Mobile: (+91) 0 9666440801
Flat No: 302, Sai Manor Complex, X Roads, SR Nagar, Hyderabad, India.
http://sqlschool.com/
|
