Data Warehousing and BI Certification Training
Secure enrollment now
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
Mode of Teaching
Live Interactive
- 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)