Online Dimensional Data Modeling Training

Online Dimensional Data Modeling Training | Data Warehouse Training | Data Mart Training

Course Description:

The dimensional data modeling training explains how to design Data Ware House and Data Marts from OLTP data models using Erwin, Power Designer & Oracle SQL Data Modeler!

To get more information about this training program, send an email to Training@LearnDataModeling.Com 0r call us @ 91-9080157239.

Course Information:
  • Mode of Training: Online Through GotoMeeting.
  • Course Fee: $125 (One hundred and seventy five US Dollars) per person
  • Mode of Payment: To USA Savings Account or India Savings Account or through www.Xoom.com
  • Total no. of theoretical/Practical classes: At least 10 Hours
  • Instructor: Neelesh (US Employee) & Antony (Owner of LearnDataModeling.com)
  • Office: USA and Chennai
Course Requirements:
  • Internet connection
  • Lap Top or Desk Top
Tools:
  • Erwin
  • Power Designer
  • Oracle SQL Data Modeler
  • MS Word, MS Excel
  • My SQL
  • Windows Operating System
Training Certificates:
  • Will be provided.

Course Syllabus

Part 1 – Dimensional Data Modeling (OLAP):
  • Need for Strategic Information
  • Examples of Business Objectives
  • Characteristics of Information
  • Operational Systems – OLTP
  • Examples of Operational Systems
  • Decision Support Systems – OLAP
  • Operational VS Decision Support
Part 2 – Introduction to Data Warehouse:
  • Data Warehouse Definition
  • Data Marts
  • Data Warehouse and Data Mart
  • Pioneer of Data Warehousing (Inmon)
  • Bill Inmon’s Approach (HUB and Spoke Architecture)
  • Pros and Cons of Inmon’s Approach
  • Pioneer of Data WareHousing (Ralph Kimball)
  • Ralph Kimball’s Approach (Bus Architecture)
  • Pros and Cons of Kimball’s Approach
  • What is ETL?
  • Things to learn for mapping/Data mapping
Part 3 – Business Intelligence:
  • OLAP
  • Dimensional Modeling
Part 4 – Different types of Fact Tables:
  • Transactional Facts
  • Snapshot or inventory
  • Factless Facts
  • Semi Additive and Non Additive Facts
Part 5 – Dimension Tables:
  • Dimension Types
  • Degenerate Dimensions
  • Denormalized Flattened Dimensions
  • Snowflaked Dimensions
  • Role-Playing Dimensions
  • Junk Dimensions
  • Outrigger Dimensions
Part 6 – Designing Star Schema:
  • Putting Building Blocks Together
  • Dimensional Model
  • Dimensional (Star) Schema
  • Declare the grain of Business Process
  • 4 Steps Dimensional Model Design Process
    • Identify Business Process
    • Identify Grain
    • Identify Dimensions
    • Identify Facts
Part 7 – Slowly Changing Dimension Techniques:
  • Type 0: Retain Original
  • Type 1: Overwrite
  • Type 3: Add New Attribute
  • Type 4: Add Mini-Dimension
  • Type 5: Add Mini-Dimension and Type 1 Outrigger
  • Type 6: Add Type 1 Attributes to Type 2 Dimension
  • Type 7: Dual Type 1 and Type 2 Dimensions
Part 7 – Big Data Data Modeling:
  • Design data model of large volumes of Data (Large Volumes of Data) with RDBMS structure

 

To get more information about this training program, send an email to Training@LearnDataModeling.Com 0r call us @ 91-9080157239.

(Visited 279 times, 1 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *