DATA WAREHOUSING | BI

Best Data Warehousing Training classes by Industry Experts in Pune India

DATA WAREHOUSING – ETL & BI TOOLS 

In computing, a data warehouse or enterprise data warehouse (DW, DWH, or EDW) is a database used for reporting and data analysis. It is a central repository of data which is created by integrating data from one or more disparate sources. Data warehouses store current as well as historical data and are used for creating trending reports for senior management reporting such as annual and quarterly comparisons.

In computing, Extract, Transform and Load (ETL) refers to a process in database usage and especially in data warehousing that:

Extracts data from outside sources
Transforms it to fit operational needs, which can include quality  levels
Loads it into the end target (database, more specifically operational  data store,         data mart, or data warehouse)

DATA WAREHOUSING SYLLABUS

Evolution of Datawarehousing – History
The need of Datawarehousing
Why Datawarehousing
What is Datawarehousing – The Definition

Subject -Oriented
Integrated
Non – Volatile
Time Varying

Datawarehousing Architecture

Data Source Layer
Data Extraction Layer
Staging Layer
ETL Layer
Data Storage Layer
Data Logic Layer
Data Presentation Layer
Metadata Layer
System Operation Layer

Dimension table
Fact table

Additive Facts
Semi Additive Facts
Non – Additive Fact
Cumulative
SnapShot

Attribute
Hierarchy
Types of Schema

Star Schema
Snow Flake Schema
Fact Constellation Schema

Slow Changing Dimension

SCD1 – Advantages/ Disadvantages
SCD2 – Advantages/ Disadvantages
SCD3 – Advantages/ Disadvantages

OLAP and OLTP

Difference between OLAP and OLTP
Types Of OLAP
Multi-Dimentional (MOLAP)
Relational(ROLAP)
Hybrid(HOLAP)

Courses which comes under Datawarehousing are following :-

Informatica | Cognos BI  | Cognos TM1 | Datastage | Datastage & Quality Stage |

Information Analyser | Abinitio | Microstrategy | BO | OBIEE | MSBI | Teradata |

Qlikview | ETL testing

 

Our Courses