Data Analysis and Data Modeling Training

Data Analysis And Data Modeling Training_main

SQL

  • Introduction to SQL
  • SQL Operators
  • SQL Constraints
  • SQL JOINS
  • SQL Aggregate Functions
  • SQL Sub Queries
  • SQL Index, View and Stored Procedure
  • SQL Normalization
  • SQL Analytic Functions

Data warehouse

  • Introduction to Data warehouse
  • OLTP
  • OLAP
  • Fact and Dimension
  • Data warehouse Schema
  • Star and Snowflake Schema
  • EDW Environment
  • Staging Area
  • ETL mechanism
  • E-R Model
  • Dimensional Model
  • Slowly Changing Dimension

Data Analysis

  • Introduction to Data Analysis
  • Understanding Data analysis process
  • Understanding how to convert raw data into information useful information
  • Data inspection
  • Data Cleansing
  • Data transformation
  • Meta Data Management

 Data Profiling

  • Data Profiling Introduction
  • Data Profiling using manual method
  • Data Profiling using database scripts
  • Data Profiling using data profiling tool

 Mapping Document

  • Purpose of mapping document
  • Creating mapping document between source and target databases

Data Modeling Concepts

  • Data Modeling Development Cycle
  • Data Modeling Standards
  • Steps to Create a Data Model
  • Data Modeler Role
  • Enterprise Data Modeling
  • Conceptual Data Modeling
  • Logical Data Modeling
  • Physical Data Modeling
  • Data Modeling Reports using Erwin
  • Logical V/s Physical Data Modeling
  • Relational Data Modeling / OLTP
  • Dimensional Data Modeling / OLAP
  • Relationships
  • Data Model Versioning
  • Working with Data Models
  • What Is An Entity?
  • What Is An Attribute?
  • What Is A Relationship?
  • What Is A Foreign Key?
  • Creating a Data Model
  • Enhance Your Data Model
  • Splitting a Logical/Physical Data Model
  • Derive a New Model
  • Reverse Engineering
  • Forward Engineering
  • Creating New Design Layers
  • Splitting a Model
  • Deriving a Model
  • Naming Standard

Send Enquiry

Your Name (required)

Your Email (required)

Your Phone No. (required)

Subject

Your Message