Introduction to Data Warehouse and Business Intelligence
What is a Data Warehouse?
Defining a Data warehouse is very simple. A data warehouse is a data repository were all relevant Enterprise data is stored and provides as a single source for the Enterprise reports, analysis, and presentation through ad-hoc reports, canned reports, portals, and dashboards.
What is Business Intelligence?
Business Intelligence provides the ability to answer critical business questions by utilizing the data from different sources for analysis, trends, alerts, and feedback in an easy to understand format for quick and effective decision making.
Data Warehousing and Business Intelligence:
A real Business Intelligence passes through a Data warehouse and utilizes the data-stored for information, knowledge, and plans that produce effective business actions. So, Business Intelligence is a combination of process, technology, and a tool. Means, Business Intelligence encompasses Data warehouse, Tools, and Visual knowledge management.
DWBI had a positive impact in the challenging times for making better decision running the business. Good decision-making becomes critical in the testing economy and low market. Data warehouse provides relevant data for making best decisions. The best possible source for the data is a well-designed data warehouse.
Building a data warehouse 80’s and 90’s was a difficult and expensive task. Many early adopters found it to be costly, time-consuming, resource intensive and risky. Building a Data warehouse without tools is very expensive in the long run and slows to be productive to produce results. Fortunately, there are many products and tools from different vendors available in the market today and companies of varying size can pick and choose the product that fits their need.
The concept of data warehousing is simple. Data is extracted periodically from the applications that support business processes and copied onto specially dedicated database servers. There it can be validated, reformatted, reorganized, summarized, restructured, and supplemented with data from disparate sources. The resulting data warehouse becomes the primary source of information for report generation, analysis, and presentation through ad hoc reports, portals, and dashboards.