Private Onsite | 4 Days Classroom
Accelerated SQL Server 2012 Analysis Services.
Design, develop, and deploy effective analytical solution that are both scalable and secure using SQL Server 2012 Analytics Services (SSAS).
Main Benefits
Create effective SSAS solutions complete with calculations, actions, aggregations, and more.
Successfully manage and deploy SSAS solutions in a development/test/production environment.
Describe the process of building a business intelligence solution and identify where and how SSAS fits into the process.
Design SSAS solutions that are both scalable and secure.
Upcoming Dates
There are no scheduled classes for this course at the moment. Please, send us an information request to find out more.
Course Delivery Options
Private Onsite.
4 Days Classroom.
The course will take place in a classroom with no more than 20 students in order to maintain a good level of interactivity.
Pre-requisites
A basic understanding of relational design and theory is helpful, as is basic familiarity with Structured Query Language (SQL).
No prior experience with any version of SQL Server Analysis Services is required.
After this Course
SQL Server 2012 Analysis Services (SSAS) enables IT Professionals to rapidly build and deploy powerful analytical solutions that enable business users to analyze business data and achieve competitive advantage. SSAS enables rapid application development, increases performance and functionality, and reduces the costs and complexity of operation. The Analysis Services course focuses on teaching IT professionals the skills and best practices required to design and develop a well performing and successful analytical solution using SQL Server 2012 Analysis Services.
Module 0: Logical Query Processing
Module 1: Introduction to BI Applications
Module 2: Dimensional modeling
Module 3: Creating a BISM End-to-End: Undestanding the Process
Module 4: Multidimensional Model: Creating Dimensions and Cubes
Lab 04 A: Working with Data Source Views
Lab 04 B: Working with Dimensions
Lab 04 D: Building Cubes
Module 5: Multidimensional Model: Advanced Features
Lab 05 A: Calculations and KPIs
Lab 05 B: Actions and Perspectives
Lab 05 C: Translations
Module 6: Tabular Model: Building Models
Lab 06: Getting Started with SSAS Tabular Models
Module 7: Tabular Model: Advanced Features
Lab 07 A: Hierarchies, Calculations and KPIs
Lab 07 B: Perspectives and Visualization Options
Module 8: Storage Modes, Aggregation Designs, and Proactive Caching
Lab 08 A: Aggregations and Partitions
Lab 08 B: Partitions in the Tabular Model
Module 9: Security
Lab 09 A: Security in Multidimensional Models
Lab 09 B: Security in Tabular Models
Module 10: Scalability and Performance
Lab 10: Query Troubleshooting
Module 11: Basic Maintenance and administration
Lab 11 B: Deploying SSAS Databases (Tabular Model)
Do you want more info about these courses?
