Warehouse design and updating

15 Feb

Knowing where the original data resides and just as importantly, the availability of that data, is crucial to the success of the project.Developing a disaster recovery plan while gathering requirements, ensures that the organization is prepared to respond quickly to direct and indirect threats to the data warehouse.Once the business requirements are set, the next step is to determine the physical environment for the data warehouse.Good Business Intelligence (BI), allows your organization to query data obtained from trusted sources and use the answers to gain a competitive edge in your industry.The first step to achieving effective BI is a well-designed warehouse.

The OLAP engine and data can be the best in class, but if users are not able to use the data, the data warehouse becomes an expensive and useless data repository.For most end users, the only contact they have with the data warehouse is through the reports they generate.Either way, there are a few considerations to keep in mind to ensure the best experience for end users.Secure access to the data from any device - desktop, laptop, tablet, or phone should be the primary consideration.User analysis and reporting requirements must be identified as well as hardware, development, testing, implementation, and user training.

warehouse design and updating-65warehouse design and updating-90