Advanced search

M20768 Developing SQL Data Models Print

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. This course can also help a learner to prepare for the Exam 70-768.

Accredited course for Continuing Education of Pedagogical Staff

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


Date PlaceLanguagePrice (without VAT)Availability
04/13/2021 - 04/16/2021 Online cs 21 000 CZK
16 800 CZK
Free date Guaranteed date
05/25/2021 - 05/27/2021 Online cs 21 000 CZK
16 800 CZK
Free date
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
  • Course requirements

    • T-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 get original Microsoft student 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 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
OKsystem a.s.
We use cookies to optimize site functionality and deliver best results based on your interests. More info