Why data ware housing:
Business - Run by information.
Information - derived from data.
Data - Given by operational systems and external sources.
More data are there
- Useful data may be in less quantity.
- May be more unwanted data.
- Trouble in accessing.
- No or lack of analyzing techniques.
Data warehousing consolidates and integrates information from many internal and external sources and arranges it in a meaningful format for making accurate business decisions.
Executives, managers, business analyst use this for predicting, forecasting the profit, trends and goals.
It is not just consolidation of operational database. It focuses on business intelligence, external data and time variant data so it is a unique kind of database.
Need for Data Warehousing:
Ø Better business intelligence for end users.
Ø Reduction in time to locate access and analyze.
Ø Consolidation of disparate information and information sources.
Ø Strategic advantages over competitors.
Ø Faster time to market, for products and services.
Ø Replacement of older, less-responsive decision support system.
Ø Reduction in demand on Information System to generate reports.
Ø Integrated, company wide view of high quality information from disparate database.
Ø Separation of operational systems and data for improved database.
Benefits of Data warehousing:
These capabilities empower the corporate………
· To formulate effective business, marketing and sales strategies.
· To precisely target promotional activity.
· To discover and penetrate new markets.
· To successfully compete in the marketplace from a position of informed strength.
· To build predictive rather than retrospective models.
· Increased productivity of corporate decision makers.
· Potential high returns on investment.
· Competitive advantage.
Data Warehouse-Technology aims on:
· Improved data quality.
· Assuming data integrity
· Assuring data consistency enabling complex data analysis.
THE MAIN GOAL OF DATAWARE HOUSE IS TO REPORT AND PRESENT INFORMATION IN A VERY USER FRIENDLY FORM
