Data Warehousing and BI Certification Training

Syllabus

Introduction to Data Warehouse & Business Intelligence

• What is Data Warehousing

• Data Warehousing Tools

• Schema Modeling Tools

• Dell Toad Data

• Modeler

• Oracle Data Modeler

• ETL Tools: Informatica Power Center, Talend DI Open Studio, IBM Data Stage, SAS, Data Warehousing categories.

• What is BI - Business Intelligence?

• BI Definition, BI Tools, Classification of BI Tools.

Data Warehouse Architecture

• Relational Vs Analytical

• What are - OLTP, OLAP, OLAP

• categories - MOLAP, ROLAP, HOLAP

• Data Warehouse Vs Data Mart

• Dependent and Independent Data Mart

• Data Warehouse Architecture

• Source System

• ETL Extraction

• Transformation

• What is a cube?

• Benefits of cube?

• How to create the cube?

• How to deploy a cube?

• How to create a report using a cube?

Data Warehouse Dimension & Fact Tables

• DIMENSION TABLE - What is a Dimension Table?

• Dimension table categories

• FACT TABLE - What is Fact Table?

• Fact Table Granularity

• Fact Table categories.

Data Modeling

• What is Data Normalization?

• Data Normalization Rules - 1NF, 2NF, 3NF, Data De-Normalization, Dimensional Modeling

• What is DM?, Principles, Benefits, Type and Technique.

Building Data Warehouse with Erwin

• Source System Understanding

• Future Data Requirement and Understanding

• Designing and Developing Dimension Table

• Designing and Developing Fact Table Designing

• Developing ER Model With Erwin

• Designing and Developing Entity Relationship Modeling.

Introduction to Open Source ETL Tool Talend DI Open Studio 5.x

• Open source ETL Talend DI Open Studio

• Difference between Licensed and Open Source ETL Tools

• What are Licensed and Open Source ETL Tools

• Working with ETL Transformation in Talend Open DI Studio.

Building ETL Project With Talend DI Open Studio 5.x

• Building ETL Project Talend DI Open Studio

• Understanding the Data Source System which will be a future Data Requirement

• Identify Business Requirement Gathering

• Building the ETL Talend Technical Design Document

• Building an ETL Project.

Introduction to Data Visualization BI Tool Tableau 9.x

• Data Visualization BI Tool : Tableau 9.x-Introduction to Data Visualization with Tableau

• Exploring Data Visualization with Tableau

• What is Data Visualization?

• Exporting Data and Working With Tableau.

Building Data Visualization BI Project With Tableau 9.x

• Building Data Visualization BI Project With Tableau 9.x

• BI Reporting Understanding

• Report and Dashboard Template Document

• Tableau Design and Development Database Source Connection.

An Integrated Data Warehousing & BI Project

• An Integrated Data Warehousing & BI Project

• Developing a Data Warehouse and BI Project

• Identify the Business Requirement Gathering

• Report and Dashboard Template Document

• Designing and Developing Models

• Designing and Developing the Staging Area

• Finalizing the Dimension Modeling Type

• Designing and Developing Dimension Modeling.

Complimentary sessions on communication presentation and leadership skills.

Benefits from the course

• Become an expert in Data Warehousing and Business Intelligence techniques covering concepts like DW Architecture, Data Modeling, ERwin, ETL fundamentals,Business Reporting and Data Visualisation.

• Upon completion of this course, you would have a clear idea about, all the concepts related to the Data Warehouse, that should be sufficient to help you start off with the next step of becoming an ETL developer or Administering the Data warehouse environment with the help of various tools to help a company to overcome various challenges.

​

Prerequisite:

• Basic knowledge of SQL,General Relational Database(oracle),Microsoft windows GUI, Basic Unix, Windows Command line.

Prerequisites

• Basic knowledge of SQL,General Relational Database(oracle),Microsoft windows GUI, Basic Unix, Windows Command line.

Course Duration:

30 Hours

Class Hours:

2 Hours Daytime slots or 3 Hours week end Slots (May change)

Video Clip