Presentation of the BI solution: MS SQL Server
Multidimensional modeling – OLAP
Architecture of Analysis Services
Development environment: BIDS (Business Intelligence Development Studio)

Workshop: Setting up the environment, overview

Basic concepts
Data sources and views
Dimension design: define, sort, group
Cube design: measures, settings, relationships

Workshop: Creation of a multi-dimensional analysis solution

Presentation of the MDX language (Multi-Dimensional eXpressions)
Syntax and queries

Lab: MDX queries to perform calculations in a cube

Configure actions
Implement translations
Manage data storage (ROLAP, MOLAP, HOLAP)
Manage cube security

Workshop: Customization of a cube – management of access rights

Deployment and update of a cube
Data mining solutions: presentation, implementation
Consultation of a cube with third-party tools (Report Builder, Excel, …)

Workshop: Deployment of a cube and consultations