According to Wikipedia, a data warehouse is a database used for data reporting and data analysis in support management, decision making process and identifying new opportunities. The data warehouse keeps on evolving in line with the changes of business needs. The data warehousing information delivery process which is used to deliver the data warehouse is therefore very important.
Data Warehousing Strategy
When it comes to data warehousing, there is a need to have an overall strategy for managing data assets .A strategy should therefore have the following details
- It should show what data should be collected.
- How long the data should be kept. This helps to determine what data is no longer needed.
- Where to store the data. The data which is constantly used should be stored within reach and the remaining data can be archived.
- Data privacy and security should be kept. There is a need to determine who can access your data and the level of detail they should see.
- Where can the data be accessed. If there are restrictions to data access within certain borders then the company should ensure that it doesn’t go against government restrictions.
- What data can be displayed, for example details such as social security numbers might be withheld for security purposes.
- The amount of data to be retained in the warehouse. Nowadays, it is essential to retain data in detail to meet the company’s needs.
- It is also essential to know who owns the data element.
- What data should reside in the warehouse and how often it should be loaded.
- Data virtualisation.
The success of any data warehouse depends on the strength of the information delivery tools. The strength of these tools is measured by their effectiveness and if they are usable. If they are effective, users will come to the data warehouse often. Data warehouse can be seen as investments that require a business process to generate the expected project profits.
Organisations are faced with various challenges in the process of delivering information to their users hence the need for an efficient information delivery mechanism .some of these challenges include;
- Providing information to all those who impact key business processes these include employees,partners,suppliers,managers,customers and even citizens
- Delivering the information to these people the way they want it.
- Implement a secure personalised and organised approach to business intelligence that delivers information broadly throughout the organisation.
- Increase user ability to interact with information, even from mobile devices such as smart phones and tablets.
- Enable faster development and deployment of BI applications.
- Use of standard web based technologies to meet growing demands for information.
During the requirements definition phase, there are several steps that are taken
- Users tell you the information they want to get from the data warehouse.
- You record these requirements in the requirements definition document.
- You provide all the features that the users require in the information delivery component.
Area of Data Warehousing Information Delivery affected by Business Requirements
Below are data warehousing information delivery areas that are affected by various business requirements.
- Queries and reports
- Types of analysis
- Information distribution
- Decision support applications
- Growth and expansion
A data warehouse is the foundation for a successful business intelligence program. It is therefore necessary to have an efficient data warehousing information delivery system in any organisation.