Radical Technologies
  • Starting Data Science and Analytics with Spark, Scala ,R and Python…Devops with- Chef Puppet Docker Ansible Salt Stack Jenkins Git Nagios Jira….VMWARE VCP 5.5 + 6.0 and 6.5 On Cisco UCS Server ….AWS | Salesforce | Openstack | Azure – Implementation,Migration  and  certification oriented Training …Windows SCCM And Server Deployment training with real time examples……Starting Training on Netapp Data Ontap Cluster Mode + 7.0 Mode…Appear for any RedHat Practical Exams at Any Time through KOALA-Redhat Systems…Discounted Oracle , Microsoft Exam Vouchers available….Exam Centres at Aundh & Kharadi in Pune, HSR Layout in Bangalore

  • COMBO COURSES

    RedHat Linux, Vitualization, Cloud, Hadoop,Datawarehousing Combo Courses with Discounted Price.....

    Readmore..

  • ONLINE TRAINING

    Radical Technologies provides best Online Training with Real-time Projects by Industry Experts....

    Online Schedule

  • BATCH SCHEDULE

    Best Classroom Training from Industry Consultants on High end Real-time Enterprise servers...

    Classroom Schedule

  • CERTIFICATIONS

    Authorized Exam Center for RedHat, Oracle, IBM, Microsoft, Cisco, Salesforce, AWS etc...

    Readmore..

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