Peakin

Menu
Register For Demo Session

Data Modelling

  1. Data Modelling: An Overview
  2. Data Model and its Importance
  3. Types of Data Modelling Techniques
  4. Data Modelling Tools
  5. Roles and Responsibilities of Data Modeller(OLTP,OLAP)
  6. Data Modelling Steps
  7. Data Model Quality
  8. Data System Development Life Cycle
  9. Models at Different Levels
  • Types of Data Models
  • Conceptual Model
  • Identifying Components
  • Context Diagrams
  • Review Procedure

9. Logical Model

  • Entity-Relationship Modelling
  • Entity And Entity Types
  • Attribute And Attribute Types
  • Relationships ,Cardinality ( State & Degree)
  • Model Components

10. Physical Model

  • Overview
  • Transformation From Logical to Physical
  • Steps to Build a Physical Model
  1. Steps to Create Data Model
  2. Normalization
  • Introduction
  • Informal Design
  • Forming Relations from Requirements
  • Potential Problems
    Update Anomaly
    • Deletion Anomaly
    • Addition Anomaly
  • Normalization Steps
  • Fundamental Normal Forms
  • First Normal Form
  • Second Normal Form
  • Third Normal Form
  • Boyce-Codd Normal Form
  • Fourth Normal Form
  • Fifth Normal Form
  1. Relationships and Cardinalities
  2. ER Diagrams
  3. Symbols in Data Model

Dimension Modelling

  1. Introduction
  2. Gathering Requirements
  3. Business Requirements
  4. Requirements Gathering Dos and Don’ts
  5. Benefits of Dimensional Modelling
  6. Comparison of Dimensional Modelling with E-R Modelling
  7. Steps To Build Dimension Model
  8. Dimensional Modelling Building Blocks
  9. Terminology of Dimension Modelling
  10. Keys in Dimensional Modelling
  • Surrogate Key
  • Natural/Business Key
  • Durable Key
  • Fact Surrogate Key
  1. Types of Dimension
  • Regular Dimension
  • Role Playing Dimension
  • Degenerate Dimension
  • Junk Dimension
  • Mini Dimension
  • Calendar Date Dimension
  • Snowflake Dimension
  • Outrigger Dimension
  • Conformed Dimension
  • Shrunken Dimension
  • Audit Dimension
  • Late Arriving Dimension

 

 

  1. Measures and its Types
  2. Types of Facts
  • Transaction Fact
  • Periodic Snapshot Fact
  • Accumulating Snapshot Fact
  • Factless Fact
  1. Slowly Changing Dimension
  • Type 0: Retain Original
  • Type 1: Overwrite
  • Type 2: Add a New Row
  • 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
  1. Dimension Hierarchy Techniques
  • Fixed Depth
  • Slightly Ragged Variable Depth
  • Ragged Variable Depth
  1. Types of Dimension Models
  • Star Schema
  • Snow Flake Schema
  1. Performance Considerations For Dimension Modelling
  2. Slicing And Dicing
  3. Drill Up And Drill Down
 

Data Modeling Tool

  1. Introduction
  2. Menus and Tool Bars
  3. Workspace Contents
  4. Naming Conventions
  5. Object Properties
  6. Relationship Properties
  7. Creation of Physical Model
  8. Creation Dimension Model
  9. Domains
  10. Defaults, Rules
  11. Reverse Engineering
  12. Model Merge
  13. Model Conversion
  14. Model Update
  15. Model Validations
  16. Model Reports
  17. DDL Script Generation
  18. Repository
  19. Version Management