BI architecture
BI is all about delivering timely and relevant information to the right level of audience, which helps them to make an appropriate decision. In this section, we will learn about BI architecture and the components involved in it.
Components of BI architecture
Source system: This is any stored data that will be used for BI projects. It could be a database, mainframe system or flat files, or any other system that stores Online Transaction Processing (OLTP) data. This is where data is stored in its raw form.
ETL: This process then pulls the data from the source system and prepares it for the data warehouse. It involves three steps:
- Extract: The process of reading data from source systems
- Transform: The process of converting data from its previous form to the form it needs to be in, either by combining data from multiple sources or by applying business rules and logic
- Load: The process of writing data into the target database, that is, the data warehouse
Data warehouse: This is...