Warehouse Architect Case Study

1475 Words3 Pages

Success Factors: Defining “Good” solutions from the viewpoints of Warehouse Architects

In today's fast paced world, data warehouse plays an important role in all sectors including financial, IT, retail and many more. Over the past decade data warehouse has been used to derive business solutions and increase productivity for potential success. After analysing various success factors to define a good solution the main factors noted and discussed in this review are those involving the system process, information quality and organisational impacts. Success of a warehouse architect depends on many organizational factors which include data warehouse, ETL, data modelling, security and business intelligence. By taking into account all these factors …show more content…

In many ways this can be considered one of the most crucial factors of success, because if the information provided was not of ideal quality the decisions and consequences of the data processing will be unfruitful. Unless data can be confidently be said to be of high quality, it is not possible to measure it using other success factors. Quality entails being able to understand the data, any information obtained is useless unless the architect can draw thoughts and conclusions on the basis the data is accurate and …show more content…

The main components of a data warehouse are the data source, data storage and the end users. The data is extracted from an external source and is passed through an ETL process, which converts the data into an output suitable for analysis. In order for this process to achieve the expected results the data staging process must be done correctly to ensure the needs of the organisation are met. By doing so the chances of a successful system are much higher.

ETL refers to Extract Transform and Load. Data is extracted from relational databases, flat files and also from non-relational databases including information management systems, virtual storages and other external sources. Once the data is extracted it is then processed to meet the needs of the client. During the process the data is cleaned and reaches the load by ensuring it meets the need of the server. It is crucial the ETL designer has discussed the process with the client organisation to ensure the solutions aimed are liable to increase

Open Document