New Batch Details
Course | Date | Timings | Duration | Trainer | Training 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