Mastering Data Modeling Course

New Batch Details
CourseDateTimingsDurationTrainerTraining Options

Data and Dimensional Modeling Course

  • Introduction

Data Modeling Course

Introduction

  • Importance and Characteristics
  • Normalization
  • Entity Relationships
  • Subtypes-Super types

Data modeling in detail

  • Conceptual Data Model
  • Logical Data Model
  • Physical Data Model
  • Entity Relationship Diagram

Normalization

  • Importance of Normalization
  • Normalization in detail (1NF, 2NF, 3NF…)

Data Modeling Project

  • ERWin Installation
  • Project Description
  • Project Guide

Erwin Tool

  • Erwin tool demonstration
  • Erwin reference material

Dimensional Modeling

  • Introduction
  • Benefits of Dimensional Modeling
  • Comparison with E-R Modeling
  • Fact Tables
  • Dimension Tables

Dimensional Modeling Concepts

  • Dimensions
    • Conformed Dimension
    • Grain
    • Sparsity
    • Degenerate Dimensions
    • Role Playing Dimensions
    • Junk Dimensions
    • Date and Time Dimensions
    • Denormalized Flatted Dimensions
    • Null Attributes in Dimensions
    • Multiple Hierarchies in Dimensions
  • Outrigger, Bridge and Hierarchy
    • Fixed Hierarchies
    • Variable Depth Hierarchies

Slowly Changing Dimensions

  • Type 0
  • Type 1
  • Type 2
  • Type 3
  • Type 4
  • Type 6

Late arriving and Missing Dimensions

Fact Tables

  • Introduction
    • Transaction Fact Tables
    • Periodic Snapshot Fact Tables
    • Accumulating Snapshot Fact Tables
  • Factless Fact Table
    • Factless fact table for Events
    • Adding a Fact
    • Factless fact table for Conditions, Coverage or Eligibility
  • Fact table for each process

Dimensional Modeling Design Basic Concepts

  • Grouping and Breaking Dimensions
  • Type-Specific stars
    • The Single-Star Approach
    • Drawbacks of the Single-Star Approach
    • Core and Custom Stars
  • Derived Schema
    • Uses cases of Derived Schemas
    • The Cost of Derived Schemas
    • Types of Derived Schemas
  • Date Confusion
  • Data Security at Data Model

Dimensional Model Design Advanced Concepts

  • Designing Dimensional Models from ER Model or Requirement
  • Dimensional Model Design in Detail
  • Design Deliverables

Dimensional Modeling Design Case Studies

  • Retail Case Study
  • Telecom Case Study

Reference Material

  • Matrix Template
  • SCD Type2 Example

Hi, fill the details our team will help you.

    Course





    Please fill the details our team will call you back.

      Course





      Azure

      Data Engineering Course

      New Batch

      17th-Feb-2025

      8:00 PM - 9:00 PM IST

      Please fill the details our team will call you back.