DataWarehousing Questions
What is a Data Warehouse?
A data warehouse is a storage of historical data for Data Analytics, such as reporting, analysis, Integration and data management. A data warehouse is a repository of data.Benefits of Data Warehouse?
It intergrates data and stores the data historicaly so the data can be analysis for performance, trends, predictions over a period of time
What is Business Intelligence?
Business Intelligence is presenting historical data in a meaningful way (often by using different data visualization techniques). Raw data stored in databases can turn into valuable information through the ETL Process.What is the difference between OLTP and OLAP?
OLTP is the transaction system that collects business data. Whereas OLAP is the reporting and analysis system on that data.OLTP systems are optimized for INSERT, UPDATE operations and therefore highly normalized. OLAP systems are deliberately denormalized for fast data retrieval through SELECT operations.
