Knowledge Transfer Microsoft Certified Training Partner CTEC
Knowledge Transfer is a Microsoft Certified Gold Partner
Microsoft Certified Gold Training Partner
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
 
 Main Menu
 
Home
View Courses
Site Index
 
 


Developing SQL Data Models- Course 20768 Overview



  • Module 1: Introduction to Business Intelligence and Data Modeling

  • This module introduces key BI concepts and the Microsoft BI product suite.

    • Lessons

      • Introduction to Business Intelligence

      • The Microsoft business intelligence platform



    • Lab : Exploring a Data Warehouse

    • After completing this module, you will be able to:

      • Describe the concept of business intelligence

      • Describe the Microsoft business intelligence platform





  • Module 2: Creating Multidimensional Databases

  • This module describes the steps required to create a multidimensional database with analysis services.

    • Lessons

      • Introduction to multidimensional analysis

      • Creating data sources and data source views

      • Creating a cube

      • Overview of cube security



    • Lab : Creating a multidimensional database

    • After completing this module, you will be able to:

      • Use multidimensional analysis

      • Create data sources and data source views

      • Create a cube

      • Describe cube security





  • Module 3: Working with Cubes and Dimensions

  • This module describes how to implement dimensions in a cube.

    • Lessons

      • Configuring dimensions

      • Define attribute hierarchies

      • Sorting and grouping attributes



    • Lab : Working with Cubes and Dimensions

    • After completing this module, you will be able to:

      • Configure dimensions

      • Define attribute hierarchies.

      • Sort and group attributes





  • Module 4: Working with Measures and Measure Groups

  • This module describes how to implement measures and measure groups in a cube.

    • Lessons

      • Working with measures

      • Working with measure groups



    • Lab : Configuring Measures and Measure Groups

    • After completing this module, you will be able to:

      • Work with measures

      • Work with measure groups





  • Module 5: Introduction to MDX

  • This module describes the MDX syntax and how to use MDX.

    • Lessons

      • MDX fundamentals

      • Adding calculations to a cube

      • Using MDX to query a cube



    • Lab : Using MDX

    • After completing this module, you will be able to:

      • Describe the fundamentals of MDX

      • Add calculations to a cube

      • Query a cube using MDX





  • Module 6: Customizing Cube Functionality

  • This module describes how to customize a cube.

    • Lessons

      • Implementing key performance indicators

      • Implementing actions

      • Implementing perspectives

      • Implementing translations



    • Lab : Customizing a Cube

    • After completing this module, you will be able to:

      • Implement key performance indicators

      • Implement actions

      • Implement perspectives

      • Implement translations





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

  • This module describes how to implement a tabular data model in PowerPivot.

    • Lessons

      • Introduction to tabular data models

      • Creating a tabular data model

      • Using an analysis services tabular model in an enterprise BI solution



    • Lab : Working with an Analysis services tabular data model

    • After completing this module, you will be able to:

      • Describe tabular data models

      • Create a tabular data model

      • Be able to use an analysis services tabular data model in an enterprise BI solution





  • Module 8: Introduction to Data Analysis Expression (DAX)

  • This module describes how to use DAX to create measures and calculated columns in a tabular data model.

    • Lessons

      • DAX fundamentals

      • Using DAX to create calculated columns and measures in a tabular data model



    • Lab : Creating Calculated Columns and Measures by using DAX

    • After completing this module, you will be able to:

      • Describe the fundamentals of DAX

      • Use DAX to create calculated columns and measures in a tabular data model





  • Module 9: Performing Predictive Analysis with Data Mining

  • This module describes how to use data mining for predictive analysis.

    • Lessons

      • Overview of data mining

      • Using the data mining add-in for Excel

      • Creating a custom data mining solution

      • Validating a data mining model

      • Connecting to and consuming a data mining model



    • Lab : Perform Predictive Analysis with Data Mining

    • After completing this module, you will be able to:

      • Describe data mining

      • Use the data mining add-in for Excel

      • Create a custom data mining solution

      • Validate a data mining solution

      • Connect to and consume a data mining solution






 

View Printer Friendly Page

Course Schedule
  Start Date  City  Price  
 7/19/2017
 $1395
Enroll
 7/19/2017
 $1395
Enroll
 9/27/2017
 $1395
Enroll
 9/27/2017
 $1395
Enroll
 12/6/2017
 $1395
Enroll
 12/6/2017
 $1395
Enroll

To Inquire About Future Classes

Request a class date

if one is not scheduled.