SQL Server Analysis Services (SSAS) Multidimensional Model Basic (conducted in English) kursus

You will learn

Microsoft SQL Analysis Services Multidimensinal is a key product among Microsoft's business intelligence tools.

Microsoft SQL Server Analysis Services Multidimensional is a tool used to handle and store data in multidimensional format (cubes) and offers superior performance and analytical capabilities. The Course in Analysis Services (SSAS) focus on creating and manage Microsoft SQL Server Analysis Services solutions.
  • Create a SQL Server Analysis Services Multidimensional Solution
  • Create Data Sources and Data Source Views
  • Create Cubes
  • Create and configure Dimensions
  • Create and configure Measures and Measure Groups
  • Handle advanced Relationships and Dimension Types
  • Create simple Calculations in Cubes with MDX
  • Create KPI
  • Create Actions
  • Configure Security
  • Deployment and Management

You get

During the course
  • Teaching by the most experienced instructor team in our cozy and fully updated classrooms located in the center of Copenhagen.
  • A course that consists of a both theory and practical exercises. We know the importance of having practical exercises and hands-on is always in focus during the courses.
  • A course material you can use as an encyclopedia after the course and downloads of course exercises.
  • All meals, which includes breakfast, fresh coffee, tea, fruit, soft drinks, lunch in an Italian restaurant on Gråbrødretorv, cake, candy and off cause Wi-Fi to your devices.
  • A course certificate as a proof of your new skills.


After the course
  • Access to our free hotline service, which means that you up to a year after the completing of the course can contact us if you have questions regarding subjects from the course.
  • We have a unique satisfaction guarantee in order to ensure you the complete benefit from the course.

Get the best benefit from the course

We expect that you have attended our "SQL Basic course” or have acquired similar experience about business intelligence, dimensional data modelling and SQL.

This Analysis Services (SSAS) course is a part of 4D's unique collection of English conducted courses in the Business Intelligence category.

Course Details

Module 1 - Introducing Microsoft SQL Server Analysis Services Multidimensional
This module describes Microsoft SQL Server Analysis Services and the concepts of data warehouses and business intelligence.

The following will be coverd:
  • Data Warehouses and Data Marts
  • Describing Microsoft SQL Server Analysis Services
  • Installing Microsoft SQL Server Analysis Services

Module 2 - Microsoft SQL Server Analysis Services Solutions and Projects
This module introduces SQL Server Data Tools and Microsoft SQL Server Analysis Services multidimensional solutions. Data Sources and Data Source Views is also introduced and discussed in this module.

The following will be coverd:
  • Microsoft SQL Server Analysis Services Mulridimensioan Solutions ini SQL Server Data Tools
  • Data sources
  • Data Source Views
  • Creating a simple Cube

Module 3 – Working with Dimensions
This module describes how to create and configure dimensions and dimension hierarchies in an Microsoft SQL Server Analysis Services multidimensional data model.

The following will be coverd:
  • Creating Dimensions
  • Attributes
  • Hierarchies
  • Attribute Relationships

Module 4 – Measures and Measure Groups
This module describes measures and measure groups. It also explains how you can use them to define fact tables and associate dimensions with measures.

The following will be coverd:
  • Measures
  • Measure Groups
  • Additive, Semi-additive and Non-additive measures
  • Advanced Data modelling

Module 5 – Calculations with MDX
This module describes the fundamentals of MDX and explains how to build calculations, such as calculated members and named sets.

The following will be coverd:
  • MDX Fundamentals
  • Simple Calculations
  • Named Sets

Module 6 – Enhancing a Cube
This module describes how to enhance a cube with Key Performance Indicators (KPIs), actions, and perspectives, and how to use these in client tools.

The following will be coverd:
  • KPI
  • Actions
  • Perspectives

Module 7 - Storage and Processing

This module describes multidimensional storage and processing. Proactive caching, designing aggregations, and partitioning is also discussed.

The following will be coverd:
  • MOLAP, ROLAP and HOLAP
  • Proactive Caching
  • Designing Aggregations
  • Partitions
  • Processing

Module 8 – Planning and implementing Security
This module describes the Microsoft SQL Server Analysis Services security framework. The module describes how to implement security on different levels in a multidimensional data model.

The following will be coverd:
  • Introducing Security in Microsoft SQL Server Analysis Services
  • Security on the Server Level
  • Database Roles
  • Security on Dimension and Cell Level
  • Dynamic Security

Module 9 - Deployment and Management
This module describes the process of deploying Microsoft SQL Server Analysis Services solutions from the development environment to the production environment. Managing the deployed solution is also described.

The following will be coverd:
  • Tools for deployment
  • Backup/Restore
  • Automating and scheduling Management

Hvad siger vores kunder om os?

Se vores google reviewsPå Google Bussiness har vi en score på 4,8 af 5 fordelt på 256 reviews

Se vores facebook Reviews

På Facebook har vi en score på 5 af 5 fordelt på 162 reviews

 

 

Se alle vores reviews 

 

 

Hold dig opdateret med vores nyhedsbrev

Modtag nyheder, gode tilbud, tips og tricks med vores månedlige nyhedsbrev.

Vi har både et Office/Adobe nyhedsbrev og et nyhedsbrev for vores tekniske Microsoft kurser.

Her bor vi

Hovedindgang
Kejsergade 2, 3 sal
1155 København K
Kursusindgang
Kejsergade 2, 3 sal
1155 København K
Åbningstider
Mandag: 08.30 - 15.30
Tirsdag: 08.30 - 15.30
Onsdag: 08.30 - 15.30
Torsdag: 08.30 - 15.30
Fredag: 08.30 - 15.30

 

Kontaktoplysninger

 
Kejsergade 2, 3 sal
1155 København K