PTR logo

Training Course

(SSAS) SQL Server Analysis Services Multidimensional Mode

In this course, you will learn the basics of cloud computing focusing on the core features of cloud technologies, including cloud deployment models, networking concepts, storage types, and cloud design.

Overview

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 Data Tools versions 2012 through to 2017) 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 2012 through to SQL Server 2017. This course can be offered in a face to face classroom and virtual setting.

Prerequisites

This course does not require any prior experience with Analysis Services 2008/2012/2014/2016/2017. It is assumed that delegates have working experience with SQL Server 2005, 2008, 2012, 2014, 2016 or 2017 and basic relational database concepts such as tables, queries, and indexing.

Details

Book Now

PTR FAQs

See our FAQs or get in contact for more information on any of our services, solutions, or to start your PTR journey.

Ready to take your business to the next level?

Reach out to our team of experts and learn more about our consultancy and training services.