Diagram of data warehouse architecture
Advantages of a data warehouse to an organization.
01. Saves times
A data warehouse standardizes preserves, and stores data from distinct sources, aiding the consolidation and integration of all the data. Since critical data is available to all users, it allows them to make informed decisions on key aspects. In addition, executives can query the data themselves with little to no IT support, saving more time and money.
02. Provides a competitive advantage
Data warehouses help get a holistic view of their current standing and evaluate opportunities and risks, thus providing companies with a competitive advantage.
Possible factors that affect the success or failure of large IT investments taking this data warehousing project
Possible factors that affect the success or failure of large IT investments taking this data warehousing project
01. Business Requirements:
Developing a data warehouse without first determining strategic business requirements is a sure recipe for failure. The best source for these requirements is the enterprise strategic plan and the performance measures identified in the plan. These become the basis for the enterprise information architecture as well as the data warehouse architecture and design An enterprise should never undertake system development efforts, particularly engineering a data warehouse, without first determining its strategic business and information requirements.
02. Sponsorship and Involvement
Enterprise executives and managers must sponsor data warehouse development. Equally important, all potential users must be involved in data warehouse engineering. Without both management sponsorship and near-universal involvement, enterprise-wide data warehouse projects usually fail.
03. The team has the right skillset
Without the right skills dedicated to the team, the project will fail. The emphasis is on “dedicated to the team.” It does little good to have skills somewhere in the organization if they are unavailable to the project. The critical roles should be reporting directly to the project manager. Matrix management does not allow the project manager to control these resources. Without this control, there are no guarantees that the people will be available when needed.
What the IT manager of the organization should do to avoid any possible failure of the proposed data warehouse.
What the IT manager of the organization should do to avoid any possible failure of the proposed data warehouse.
01. IT manager should select skilled developers & engineers to the project group.
IT manager always try and select all the project members who has relevant technology & design knowledge and the relevant experience.
02. IT manager should supervise and guides all the tasks that engineers and developers are doing.
The engineer should supervise and guide the project step by step. Managers can have weekly meetings to see the progress and the issues they have, then they can solve the issues as a group.
03. Gather the business requirements correctly.
IT managers should appoint good business analysts to gather the actual business requirement. Always manager should collect and gather extract requirement to avoid the issues and to save the time of the project. It will lead to do the project high efficiency.
04. Identify Risk Factors
When planning the project IT manager should do a respective analysis to identify the risk of this data warehouse project. Then manager should plan the project accordingly with giving the best solution to avoid all those risks.
