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  
 9/27/2017
 $1395
Enroll
 9/27/2017
 $1395
Enroll
 12/6/2017
 $1395
Enroll
 12/6/2017
 $1395
Enroll
 7/5/2018
 $895
Enroll

To Inquire About Future Classes

Request a class date

if one is not scheduled.



Comments on the Course

Now Available in MOC On-Demand

As a Microsoft Certified Managed Partner, KTCS is excited to be among the first to offer this new learning product and delivery option. Enroll in our Self Paced option above to being your MOC On-Demand Training.

What is MOC On-Demand Training?

MOC On-Demand is an IT training solution designed around your schedule, budget, and learning needs. With MOC On-Demand, you can grow your knowledge and understanding of technical subjects and Microsoft technologies at a time and place that is convenient for you. MOC On-Demand combines high-quality video, reading, live hands-on labs and knowledge checks in a self-paced format to help you build skills on Microsoft technologies as your schedule allows—all at once or five minutes at a time. The modular, self-directed course structure adapts to your learning needs and learning style.

Want more information? Call us 8664446548