Data Warehousing and Business Intelligence:
A real Business Intelligence passes through a Data warehouse and utilizes the data-stored for information, knowledge, and plans that produce effective business actions. So, Business Intelligence is a combination of process, technology, and a tool. Means Business Intelligence encompasses Data warehouse, Tools, and Visual knowledge management.
Among all, the Date warehouse plays a vital role by providing data to the high-profile tools for user interaction. The background role of Data Warehouse hides its significance because BI solution vendors do not emphasize its role.
Technically speaking, it is not necessary to have a Data warehouse to create a BI environment. However, it is the experience BI world is that without a Data Warehouse the Visual tools can develop silos, confusion, inaccurate representation of data and scattered reports & projects.
Data Warehouse Fundamentals:
Data Warehousing is a process of creating a permanent repository by collecting the data from operational data sources. This Data warehouse stores or duplicates the data stored in the Enterprise but, the data residing in the Data warehouse is a historical snapshot and refined for Enterprise Analytics and reports.
Data Warehouse typically:
o Resides on dedicated servers or computers
o Runs on a database management system
o Retains historical data from the source
o Data Warehouse consolidates data.
o Built on a data model that facilitates faster data entry and data retrieval
ETL Extract Transform and Load:
ETL means Extract Transform and Load. ETL is a process combined with technology. Using this process data is extracted from all sources, and depending on the user requirements the data is transformed for reporting needs, and finally, data loaded into the Data warehouse.