SSAS 2014, Part 09 of 10: Cube and Tabular Processing

The Tabular Model can be used to efficiently retrieve data. This course discusses how cube automation and tabular processing can be done on Dimensions and Measure groups. It also covers how storage and retrieval of the tabular model works for both back ups and restoration and finishes up with optimization and best practices of tabular storage.

Lesson 1:

• Cube Processing
• Processing in Project
• Dimension Processing
• Cube Processing
• Demo: Process in Project
• Script XMLA
• Job Scheduling
• Demo: Job Scheduling
• Demo: Jobs
• Cube Storage
• Cube Storage - Warnings
• Demo: Cube Storage.

Lesson 2:

• Tabular Processing
• Tabular Processing Script
• Job Scheduling
• Demo: Processing Options
• Backups
• Backup Supporting Information
• Demo: Backup
• Optimization Techniques
• Design Efficiently
• Query Performance.