Data Warehousing & Business Intelligence

Course Overview:

Data Warehousing and Business Intelligence is one of the hottest skills today, and is the cornerstone for reporting, data science, and analytics. This course teaches the fundamentals with examples plus a project to fully illustrate the concepts.

Course Content:

Introduction

♦ What is Data Warehousing?

♦ Data Warehousing Tools

♦ Schema Modeling Tools

♦ CA, ERwin,Dell Toad Data Modeler

♦ Oracle Data Modeler

♦ ETL Tools

♦ IBM Data Stage

♦ Data Warehousing categories

♦ What is BI - Business Intelligence

♦ BI Tools &Classification of BI Tools.

Data Warehouse Architecture:

♦ Relational Vs Analytical. 

♦ OLTP, OLAP, OLAP categories

♦ Data Warehouse Vs Data Mart

♦ Data Warehouse Architecture, 

♦ Source System, ETL Extraction, Transformation

♦ What is a cube

♦ Benefits of cube

Data Warehouse  Dimension & Fact Table

♦ Dimension Table

♦ Dimension Table Categories

♦ Fact Table

♦ Fact Table Granularity & Fact Table categories

Data Modeling

♦ Data Normalization Rules

♦ De-Normalization

♦ Dimensional Modeling

Building Data Warehouse with Erwin

                      ♦ Source System Understanding

                      ♦ Future Data Requirement and Understanding

                      ♦ Designing and Developing Dimension Table

                     ♦ Designing and Developing Fact Table Designing and Developing ER Model With ERwin,

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

                     ♦ Open source ETL Talend DI

                     ♦ Open Studio -Difference between Licensed

                     ♦ 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

                      ♦ 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.

                      ♦ 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

                     ♦ Designing and Developing the Staging Area

                     ♦ Finalizing the Dimension Modeling Type, Designing and Developing Dimension Modeling.

We can assure a 100% job guarantee and Placement. Contact us for Free - Demo.