Data Modeling /Data Architecture Course Contant

Data Modeling Course

Part 1 : Data Modeling Concepts

Normal Forms
Primary Key, Foreign Key, Unique Key, System Key, Business Key
Data modeling overview
Need and advantage of Data Models
Data Modeling Tools
Role of a Data Modeler
Data modeling life cycle
Conceptual Data Model
Logical Data Model
Physical Data Model
Difference between Logical Data Model and Physical Data Model
Data modeling standards and abbreviations
Cardinality
Erwin Tutorial
Creation of Logical Data Model
Entities, Attributes and Relationships
Identifying and Non Identifying relationships
Use of NSM file
Generate the Data Dictionary
Erwin reports
How to convert Logical Data Model into Physical Data Model
Case Studies -> Car Hire, Help Desk, Hotel Reservation
Quiz


Part 2 ; Dimensional Data Modeling Concepts

OLTP Data Models: Online Transaction Processing Systems
What is OLTP System and how it works ?
OLTP V/s OLAP data Models ?
What is Dimensional Modeling ? Example of the Dimensional model with Sales management business process and the business questions related to process/.
What is a Dimension Table? What is Fact table?
Case Study for the Dimensional Model -> Car Parking
Slowly changing dimensions
Star Schema
Snow flake Schema
Difference between Start Schema and Snow Flake schema
Fact Constellation
Conformed Dimensions
Case Study for SCD and Galaxy Schema TESCO Super Market
Surrogate Keys
Aggregate Tables
Fact less Fact table
Junk Dimension
Degenerated Dimensions
Additive, Non Additive and Semi Additive Facts
OLAP MOLAP HOLAP DOLAP
Quiz


Part 3 : Data warehousing and Data Mart Concepts

What is Data warehouse?
What are the characteristics of a typical Data warehouse?
What is the overall end to end process to create the Data warehouse?
Difference between the dependent and independent data warehouses
What are data marts?
What are the approaches to create the Data Marts?
Case Study -> Data warehouse
Quiz


Part 4 : ETL Concepts with illustration thru ETL Tool

What is ETL
Data Sources and Data Types
Data Mapping
ETL Process
Incremental and Initial load
Data Extraction
Sample ETL Tools
Example of Dirty Data
What is Data Cleansing?
Steps in Data cleansing: Parsing, Correcting, Standardizing, Matching, Consolidating
Data Staging
Data Transformation
Data Loading
Metadata
Quiz
Introduction to Data stage
Data stage designer
Data stage Run Director
Parallel Jobs
Introduction to Data stage stages

Part 5 : Business Intelligence and Master Data Management Concepts
Business Metadata
Technical Metadata
BI Overview
OLAP
KPI
BI dashboard
What is MDM ?
Best practices for MDM ?
How to maintain Master List?
Why should I manage Master Data ?