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

You will learn

Microsoft SQL Analysis Services Multidimensinal 2012/2014 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 "Business Intelligence Grundlæggende" and "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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • KPI
  • Actions
  • Perspectives

Module 7 - Storage and Processing


This module describes multidimensional storage and processing. Proactive caching, designing aggregations, and partitioning is also discussed.
  • 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.
  • 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.
  • Tools for deployment
  • Backup/Restore
  • Automating and scheduling Management

Kontaktoplysninger

Adresse
Amagertorv 21
1160 København K