Data Warehousing & Business Intelligence
A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources. It separates analysis workload from transaction workload and enables an organization to consolidate data from several sources.
In addition to a relational database, a data warehouse environment includes an extraction, transportation, transformation, and loading (ETL) solution, an online analytical processing (OLAP) engine, client analysis tools, and other applications that manage the process of gathering data and delivering it to business users.
In simple terms, A data warehouse is a:
Subject-oriented – integrated - time varying - non-volatile collection of data in support of the management's decision-making process.
Collection of data in support of the management's decision-making process.
A data warehouse is a centralized repository that stores data from multiple information sources and transforms them into a common, multidimensional data model for efficient querying and analysis.
Data Warehousing |
SQL |
ETL Tools |
|
Reporting Tools |
ETL TOOLS | REPORTING TOOLS |
---|---|
INFORMATICA | OBIEE |
ODI | COGNOS |
TERRADATA | BUSINESS OBJECTS |
DATASTAGE | HYPERION |
MS-BI [SSIS] | MS-BI [SSRS] |
MICROSTRATEGY |
For more info, Please reach us @ +91 998 666 9999 or click here