Course code: MOC 2791« Back

Microsoft SQL Server 2005 – Analysis Services – Implementing and Maintaining

This three-day course is intended for everyone who wants to learn how to use the new data analysis tools that SQL Server 2005 offers.

This course has been removed from our portfolio
This section contains overview of retired courses which don’t belong to GOPAS course offer any more or were replaced by new course versions.
For more information about possibility to buy retired courses contact our customer services department (__Klientskyservis@gopas.cz) or business department (__Obchod@gopas.cz).

AffiliateDurationCatalogue priceHandbook priceITB
Praha3 18 450 CZK included in course price 30
Brno3 18 450 CZK included in course price 30
Bratislava3 525,00 EUR 189,00 EUR 30

Who is the course for

This three-day course is intended for everyone who wants to obtain the maximum from operational data by analytical processing using the new data analysis tools that SQL Server 2005 offers.

What we teach you

  • You will learn about various analysis services
  • You will learn how to create data cubes
  • You will learn how to create dimensions and relationships between them
  • You will learn how to use hierarchies and aggregation
  • You will learn how to manage data cubes

    Required skills

  • Familiarity with the principles of relations databases
  • Knowledge of SQL language
  • Familiarity with object-oriented programming and .NET architecture

    Teaching methods

    Expert instruction with practical examples, computer practice

    Teaching materials

    Books published by the specialist publishers.

    Course Outline

    We start with analysis services

    • Business Intelligence and Data Warehouse
    • OLAP and SSAS - which is which
    • Creating your first cube

    Data cube design fundamentals

    • Dimensions - standard, time and parent-child
    • Measures and measure groups
    • Aggregation and hierarchy - use and optimisation

    Advanced properties of data cubes

    • MDX - creating and designing queries, creating KPIs
    • Dimensions relationships, metadata
    • Interactive cube

    Cube management

    • Security
    • Managing areas and processing
    • Managing the production environment

    Previous courses

    no preceding courses

    Next courses

    no following course
    Tištěná příručka MOC 2791

    Price:
    4950 CZK
    Tištěná příručka MOC 2791

    Price:
    189 EUR
    The prices are without VAT.