Sql Analysis Services – Sql Business Intelligence

Introduction

The SQL Server Analysis Services for Business Intelligence course is for candidates looking to gain knowledge and skills. Candidates will learn how to create OLAP Cubes with XMLA scripts. The trainer will give candidates an insight in how to extend dimension relationships.

Pre-Requisites

The candidate should have the following previous experience:

• Relational databases

Who should attend?

• This course should be attended by candidates who are looking to develop their knowledge with the SQL Server Analysis Services for Business Intelligence course.

What will you learn?

• How to create OLAP Cubes with XMLA scripts
• How to extend dimension relationships
• How to use MDX to build solutions
• How to apply indicators for performance
• How to apply data-mining techniques
• How to deploy a cube
• How to create a cube
• How to use the Aggregation design wizard to build Aggregations
• How to configure dimension relationships

Course Outline

• Introduction
• Dimensions
• Modifying the cube
• Creating the cube
• Hierarchies
• Relationships
• Dimesons
• Model database
• MDX analysis
• Monitoring performance
• Data mining
• Conclusion