20768: Developing SQL Data Models (MOC20768)

Logo TailorIT RGB

20768: Developing SQL Data Models (MOC20768)


20768: Developing SQL Data Models (MOC20768)

This three days course is directed at database professionals who fulfil a Business Intelligence (BI) developer role. This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS) and at creating tabular semantic data models for analysis with SSAS.


After following this course, the students are able to:

  • Describe the components, nature and architecture 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
  • Customize a cube
  • Implement a tabular database
  • Use DAX to query a tabular model
  • Use data mining for predictive analysis
  • Doelgroep

    The audience for this course is database professional who need to fulfil BI Developer role to create enterprise BI solutions.


    To participate in this course, the students needs basic knowledge of the Microsoft Windows operating system and its core functionality and working knowledge of Transact-SQL and relational databases.


    Classical and Tailor iT made training


    During this course the following topics will be covered:

    Module 1: Introduction to Business Intelligence and Data Modeling

    Module 2: Creating Multidimensional Databases

    Module 3: Working with Cubes and Dimensions

    Module 4: Working with Measures and Measure Groups

    Module 5: Introduction to MDX

    Module 6: Customizing Cube Functionality

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

    Module 8: Introduction to Data Analysis Expression (DAX)

    Module 9: Performing Predictive Analysis with Data Mining



    3 days

    € 1.395


    17, 18 en 19 februari 2020

    4, 5 en 6 december 2019

    Andere data?


    Breda, Tilburg, Amsterdam, Rotterdam, Utrecht, Eindhoven, Antwerpen, Zwolle

    Andere locatie?

    Meer weten over een training of advies? Bel met onze opleidingsadviseurs 085 02 01 070 of gebruik het contactformulier.