Certhippo

CALL US
+1 302 956 2015 (USA)

Certhippo
Certhippo

571,823
Satisfied Learners

Certhippo

250,000+
Hours Classes

Certhippo

30,000+
Assignments

Certhippo

2,500+
Projects

All Course
Home   >    All Courses   >   Business Intelligence and Visualizations   >    Data Warehousing Certification Training

Data Warehousing Certification Training

SUPPORT NO. +1 302 956 2015 (USA)

Buy Now

A Self-Paced course designed to give you a head start into Data warehousing and train you on different concepts of Data warehousing along with the implementations of these concepts.

Why this course ?

ERwin is worldwide market leader in data modeling with 33% market share – IDC ReportData

warehouse management market to reach $17 billion by 2018 –  Global Industry AnalystsAn ETL Data

Warehouse Developer in the USA can earn $101,000 – indeed.com

Major corporations are investing huge amounts of money in order to derive more value from the data that they collect. This mean Business Intelligence and Data Warehousing tools like Erwin will see a huge upside due to rapid adoption. There will be huge demand for professionals with skills like Data modeling and expertise in ETL deployment. This can lead to huge jump in salaries for the right certified candidates.

  • 15K + satisfied learners. Reviews

Enroll now

Course Type

You will undergo self-paced learning where you will get an in-depth knowledge of various concepts that will be covered in the course.

Real-life Case Studies

Towards the end of the training, you will be working on a project where you will implement the techniques learnt during the course.

Assignments

Each class has practical assignments which shall be finished before the next class and helps you to apply the concepts taught during the class.

Lifetime Access

You get lifetime access to Learning Management System (LMS) where presentations, quizzes, installation guide & class recordings are there.

Forum

We have a community forum for all our customers that further facilitates learning through peer interaction and knowledge sharing.

   About The Course

This Data warehousing course enables participants with concepts of Data warehousing like Facts, Schema, Metadata, Normalization, Data transformation, Dimensional Modeling and ETL Concepts.

   Course Objectives

After the completion of Data warehousing course at Certhippo, you will be able to: 

1. Understand the concept and need of Data warehouse 

2. Implement concepts of dimension and fact table 

3. Implement data modeling, normalization and schema concepts 4. Model a Data warehouse 

5. Implement ETL jobs

   Who should go for this course?

This course is a foundation to anyone who aspires to become a Data warehouse Architect, a Data warehouse Developer or a Data warehouse Business Analyst in the field of Data warehousing and Business Intelligence. The following professionals can go for this course : 

1. BI /ETL Professionals

2. Project Managers 

3. Testing Professionals 

4. Mainframe Professionals 

5. Analytics Professionals 

6. Software Developers and Architects

   Pre-requisites

The pre-requisites for this course includes basic understanding of Databases.

   Why learn Data Warehousing?

As we move from intuition based decision making to factual decision making, it is increasingly important to capture data and store it in a way that allows us to make smarter decisions. This is where Data warehouse comes into picture. There is a huge demand for Data warehousing professionals and this course acts as a foundation which opens the door to a variety of opportunities in Business Intelligence space.

   Introduction to Data Warehouse

Learning Objectives - Discussing about the basic concepts of a data warehouse and why it is needed. Difference between an operational system and an analytical system, Datamarts. Approaches to build a data warehouse.

Topics -  
1. What is a data warehouse? - Definition and explanation of the four terms - subject oriented, integrated, non volatile and time variant

2. Need for a data warehouse 3. Difference between a database and a data warehouse. OLTP and OLAP? 4. Datamart - The smaller cousin of the data warehouse

5. ODS - Operational Data Store - Definition and explanation of 4 terms - Subject oriented, Integrated, Current, Volatile, Detailed

6. Benefits of ODS 7. Design approach - Top down approach, bottom up approach, Federated

   Dimension and Fact

Learning Objectives - Learning what a dimension and a fact is, the different types of dimensions and facts. Reporting concept of Hierarchy.

Topics - 
1. Dimensions and facts - What are dimensions and facts?

2. Types of dimensions - emphasis on SCD 1,2,3 implementations 3. Types of facts 4. What are hierarchies - Types of Hierarchies

   Normalization and Schemas

Learning Objectives - Organizing data in multiple tables. Understanding normalization and its different forms. Learning what is a schema and the different types of schemas along with meta data.

Topics - 
1. Normalization

2. Schemas - What is a schema. Types - Star, Snowflake, Galaxy 3. Significant role of meta data

   Modeling

Learning Objectives - Understanding principles of requirement gathering to build a warehouse and dimensional modeling.

Topics - 
1. Requirement gathering

2. Principles of dimensional modelling

3. Modeling - ER diagrams

   ETL in Detail

Learning Objectives - Understanding where will the data come from and how will the data come and Populating the warehouse.Learning concepts of Extracting data, Transforming data and Loading the data into different tables.

Topics - 
1. ETL Concept - Architectural components - like Source, Staging, Atomic, Dimension

2. Transformation - Data Validation, Data Accuracy, Data Type Conversion, Business Rule Application

3. Data Loading techniques.

   Project

Learning Objectives - Implementing a data warehouse Project.

Topics - Discuss a project, its problem statement, probable solutions, and implement one solution.

   Do you provide placement assistance?

Certhippo is the largest online education company and lots of recruitment firms contacts us for our students profiles from time to time. Since there is a big demand for this skill, we help our certified students get connected to prospective employers. We also help our customers prepare their resumes, work on real life projects and provide assistance for interview preparation. Having said that, please understand that we don't guarantee any placements however if you go through the course diligently and complete the project you will have a very good hands on experience to work on a Live project.

   Are there Pre-requisites for learning this course?

This is a simple scripting language and thus there is no need for any knowledge in Java

   What are the payment options?

You can pay by Credit Card, Debit Card or NetBanking from all the leading banks. We use a CCAvenue Payment Gateway. For USD payment, you can pay by Paypal. We also have EMI options available.

   Certification

  • At the end of your course, you will work on a real time Project. You will receive a Problem Statement along with a dataset to work. Once you are successfully through with the project (reviewed by an expert), you will be awarded a certificate with a performance based grading. If your project is not approved in 1st attempt, you can take additional assistance to understand the concepts better and reattempt the Project free of cost.