Developing Data Models using SQL Server Analysis Services


This 3-day instructor led course provides students with creating a managing data models in Microsoft SQL Server. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, measure groups and learn how to use MDX and DAX.

Accredited course for Continuing Education of Pedagogical Staff

Course length: 3 days (8:30 - 16:00)

List price: 17 700 CZK (without VAT)

This course has no dates set. If you are interested in setting a new one, please contact

PDF to download Expand allCollapse all

  • Students will be able to

    • Describe the components, architecture, and nature of a BI solution
    • Create a multidimensional database with Analysis Services
    • Implement dimensions in a cube
    • Implement measures and measure groups in a cube
    • Use MDX Syntax and customize a cube
    • Implement a Tabular Data Model in SQL Server Analysis Services
    • Use DAX to enhance a tabular model
    • Use data mining
  • Course requirements

    • SQL language
    • Basic knowledge of the Microsoft Windows operating system
  • This course is intended for

    This course is intended for end users, Database Administrators, Database Developers, and BI professionals. 

  • Literature

    All participants will receive internal OKsystem materials.

  • Hardware

    Classrooms are equipped with high-performance computers with Internet access and the possibility of wireless connection.

  • Syllabus

    Module 1: Introduction to Business Intelligence and Data Modeling

    • Lesson: Introduction to Business Intelligence
    • Lesson: The Microsoft business intelligence platform
    • Lab: Exploring a Data Warehouse

    Module 2: Creating Multidimensional Databases

    • Lesson: Introduction to multidimensional analysis
    • Lesson: Creating data sources and data source views
    • Lesson: Creating a OLAP cube
    • Lesson: Overview of cube security
    • Lab: Creating a multidimensional database

    Module 3: Working with Cubes and Dimensions

    • Lesson: Configuring dimensions
    • Lesson: Define attribute hierarchies
    • Lesson: Sorting and grouping attributes
    • Lab: Working with Cubes and Dimensions

    Module 4: Working with Measures and Measure Groups

    • Lesson: Working with measures
    • Lesson: Working with measure groups
    • Lab: Configuring Measures and Measure Groups

    Module 5: Introduction to MDX

    • Lesson: MDX fundamentals
    • Lesson: Adding calculations to a cube
    • Lesson: Using MDX to query a cube
    • Lab: Using MDX

    Module 6: Customizing Cube Functionality

    • Lesson: Implementing key performance indicators
    • Lesson: Implementing actions
    • Lesson: Implementing perspectives
    • Lesson: Implementing translations
    • Lab: Customizing a Cube

    Module 7: Implementing a Tabular Data Model by Using Analysis Services

    • Lesson: Introduction to tabular data models
    • Lesson: Creating a tabular data model
    • Lesson: Using an analysis services tabular model in an enterprise BI solution
    • Lab: Working with an Analysis services tabular data model

    Module 8: Introduction to Data Analysis Expression (DAX)

    • Lesson: DAX fundamentals
    • Lesson: Using DAX to create calculated columns and measures in a tabular data model
    • Lab: Creating Calculated Columns and Measures by using DAX

    Module 9: Performing Predictive Analysis with Data Mining

    • Lesson: Overview of data mining
    • Lesson: Using the data mining add-in for Excel
    • Lesson: Creating a custom data mining solution
    • Lesson: Validating a data mining model
    • Lesson: Connecting to and consuming a data mining model
    • Lab: Perform Predictive Analysis with Data Mining

Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.