20768: Developing SQL Data Models (MOC20768)


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


    15, 16 en 17 januari 2018

    12, 13 en 14 februari 2018

    19, 20 en 21 maart 2018

    23, 24 en 25 april 2018

    7, 8 en 9 mei 2018

    9, 10 en 11 juni 2018

    Andere data?


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

    Andere locatie?

    SKU: MOC20768 Categorieën: , , Tag:
    Meer weten over een training of advies? Bel met onze opleidingsadviseurs 085 02 01 070 of gebruik het contactformulier.