| 1 | 12 | ||||||||||||||||||||
| 2 | |||||||||||||||||||||
| 3 | 15 | 16 | 17 | ||||||||||||||||||
| 14 | |||||||||||||||||||||
| 4 | 18 | ||||||||||||||||||||
| 5 | |||||||||||||||||||||
| 11 | 13 | ||||||||||||||||||||
| 19 | |||||||||||||||||||||
| 6 | |||||||||||||||||||||
| 7 | |||||||||||||||||||||
| 8 | |||||||||||||||||||||
| 9/10 | |||||||||||||||||||||
1. Where data is processed in small, fixed-size batches rather than processing the data all at once.
2. The process of identifying and correcting or removing errors, inconsistencies, and inaccuracies in data stored in the data warehouse.
3. A software tool or platform that facilitates the automation and management of the Extract, Transform, Load process.
4. The process of ensuring the accuracy, completeness, and quality of the extracted and transformed data.
5. The capability of a system to provide multidimensional analysis of data in a data warehouse.
6. Processing data in large blocks at scheduled intervals.
7. The process of discovering patterns, insights, and valuable information from large datasets stored in the data warehouse.
8. The process of identifying and capturing changes made to data in real time, enabling real time updates to data warehouses.
9. The first step in the Extract, Transform, Load (ETL) process, which involves retrieving data from various sources, such as databases, files, or APIs.
10. The process of retrieving or pulling data from the source systems or applications.
11. A central table in a data warehouse that contains the primary measures or metrics of a business process.
12. The analysis of data as soon as it is acquired, often used to make immediate decisions or respond to events as they happen.
13. A smaller, specialized subset of a data warehouse that is focused on a particular business function or department.
14. The third and final step in the ETL process, which involves transferring the transformed data into the target database, data warehouse, or application.
15. A technology-driven process for analyzing data and presenting actionable information to help corporate executives, business managers, and other end-users make more informed business decisions.
16. The process of collecting, organizing, and storing data to be retrieved and analyzed later.
17. The second step in the ETL process, which involves converting and restructuring the extracted data into a format suitable for the destination system or application.
18. The graphical representation of information and data, using visual elements such as charts, graphs, and maps, to facilitate understanding and decision-making in business intelligence.
19. The delay between data being generated and being available for reporting and analysis in a data warehouse.