Take advantage of SSAS to conduct a fast and thorough analysis of data from a warehouse. An SSAS cube allows you to cross-reference data from the warehouse according to join rules defined by the developer.
Duration
3 days
Schedule
9h to 16h
Regular fee
$1,495
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$1,345
Objectives of the training
To provide the knowledge and skills required to make effective use of MS SQL Server Analysis Services (SSAS).Targeted audience
Data warehouse developers.Prerequisite
Experience with data warehouse design (Course BD106).Trainers
Course architecture
Training eligible for SCALE AI grants
Key SSAS concepts: data sources, dimensions, cubes, the UDM model
- New features of SSAS architecture
- Implementing star and snowflake schemas
- Generating a cube
- Implementing advanced cube functionality
- SSAS administration
- Configuration of roles, groups and permissions
- SSAS management: performance optimization
- Managing partitions and Business Intelligence in real time
- Generating scripts with MDX
- Using data exploration solutions in SSAS
- Using data exploration tools
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quoteDuration
3 days
Schedule
9h to 16h
Regular fee
$1,495
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$1,345
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote