(SSAS) SQL Server Analysis Services Multidimension Mode

In this course, you will learn how to use Microsoft SQL Server Analysis Services (SSAS) to design and implement Multidimensional OLAP cubes to support Business Intelligence (BI) solutions. You will learn about the Microsoft SQL Server Visual Studio development environment (SQL Server 2008 Business Intelligence Development Studio (BIDS), SQL Server 2012/2016 Data Tools) for design, creation and deployment of SQL Server BISM (Business Intelligence Semantic Model) Multidimensional Mode projects, and SQL Server Management Studio for the management of Multidimensional databases. The course will take delegates through building a multidimensional cube in its simplest form through to extending the features within the cube by implementing MDX calculations, Key Performance Indicators (KPIs), Actions and Dimension/Cube Intelligence. The main emphasis of the course is on the design and creation of cubes, but basic administration and security of cubes are also covered. This course is suitable for delegates working with all versions of SQL Server from SQL Server 2008 through to SQL Server 2016.

Introduction To SQL Server Analysis Services (SSAS)

First Look at Multidimensional BISM

Understanding MDX

Data Sources and Data Source Views

Dimension Design

Cube Design

Advanced Dimension Design

Advanced Cube Design

Administration and Management

Designing Multidimensional BISM for Performance

Introduction to Data Mining, Multidimensional BISM, and Data Mining Add-Ins For Microsoft Office 2010/2013

Analysing Cubes With Microsoft Office Components

Other Features

Dates

London Greenwich

Monday 16 to Wednesday 18 October 2017

£1195

Book Now


Collections

Programming courses

Sql courses

Database courses