Why Organizations going for DataWarehousing Today!

As we know that every effort is worth spending, so is the case with the DW implementations going all over the world in most of the big Enterprises by some of the Leading IT giants.

To a beginner, it seems to a waste of time as everything is available on the Database End.

But with the time, a layman can be made to understand the underlying importance of the Business Intelligence paradigm that the Data Warehousing brings along with it.

These huge Data Warehouses stores the data in a manner suitable for the Business Reporting that helps the management to take Executive Decisions based on the reports/dashboards submitted to them by these intelligence systems.

***Read about Star Schema and Snowflake Schema

It also makes the data abstraction and analysis easier and faster to cater to the needs of the higher management of any emerging organization to deal with the ever increasing competition in the market of their respective domains.

Approaches to Data-Warehousing:
1. Top Down   - Inmon Approach
2. Bottom Up  - Kimball Approach

• Common ETL (Extract, Transform and Load) Tools are:
  • Informatica PowerCenter
  • IBM DataStage
  • SAP BODS
  • Oracle ODI
  • Ab-Initio

Data-Warehouse Lays down the Strong Foundation for the Business Intelligence

• Common BI (Business Intelligence) Tools are:
  • Legacy
    1. IBM Cognos
    2. SAP BusinessObjects BI Platform
    3. Oracle OBIEE
  • Modern
    1. Tableau Desktop/Public
    2. Qlik View/Sense
    3. Tibco Spotfire
    4. Microsoft Power BI
    5. Google Data Studio