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)

Why Radical Technologies

100% Placement Guarantee for the Right Candidate

10+ Years Real Time Experienced Trainers

Learn from Industry Experts, Hands-on labs

Flexible Options: online, instructor-led, self-paced

14+ Years of Industry Recognitions

1 Lakh+ Students Trained

50,000+ Students Placed

Guaranteed 5+ Interview Calls

Top MNCs - Associated with 800+ Recruiters

Free Internship Project & Certification

Monthly Job Fair - Virtual as well as Physica

5000+ Reviews & Ratings

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 :-

Qlikview | ETL testing

Online Batches Available for the Areas-