Data Warehouse

Have Queries? Ask us +91 72592 22234

Course Overview


Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on Data Warehouse which gives you the opportunity to interact with a Data Warehouse instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants.

Course Content


Introduction to Data Warehousing

  • Introduction to Data Warehouse
  • Basic concepts of a data warehouse
  • The architecture of data warehouse
  • Data Warehouse processes
  • Categories of Data Warehouse technology
  • Data Warehouse project and initiative types

Introduction to the Dimensional Model

  • Facts
  • Dimensions
  • Star schemas
  • Snowflakes

Project Management Deliverables

  • Data Warehouse strategy
  • Data Warehouse project scope
  • Managing a Data Warehouse project
  • Data Warehouse project plan
  • The iterative release model

Architectural deliverables

  • Requirements
  • Analysis
  • Design
  • Infrastructure
  • Implementation

Implementation, Operation and Expansion

  • Implementation Deliverables
  • Outcomes from design
  • Outcomes from analysis
  • Outcomes from deployment
  • Outcomes from construction
  • Operational Deliverables
  • Outcomes of usage
  • Service level agreements
  • Data Warehouse monitoring and governance

Normalization and Schema

  • Introduction to Normalization
  • What is a schema
  • Types of Schema

Maintaining the Data Warehouse

  • Incremental Data warehouse releases
  • Follow-up to DW
  • On-going assessment
  • Post mortem and lessons learned
  • Managing consultants
  • Managing the vendor
  • Getting started with data warehousing

ETL in Detail       

  • Concepts of ETL
  • Data Loading techniques
  • Transformation - Data Validation, Data Accuracy, Data Type Conversion, Business Rule Application

Modelling

  • Requirement gathering
  • Principles of dimensional modelling
  • Modelling - ER diagrams

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234