Introduction to Data warehousing and Business Intelligence
What is the big buzz about DWBI? I am sure we always here about Data warehousing and Business Intelligence every were we travel in the IT and Business world. For some it is fuzzy on exactly how it works and whether we need it.
Data warehouses are widely used within the largest and most complex businesses in the world. It is all depends on the type and growth of the business. A Data warehouse is not a must for every organization. DW/BI is beneficial to those companies which are matured in their business and they are trying to dig deep to open more opportunities to reap the benefits. Though BI is in vogue it need not be a trend. The reason is, building and maintaining a DW/BI environment can be costly and it is not necessary there will be a definite ROI in the short run. An unplanned and underutilized BI can be expensive for companies.
The utilization of DWBI has grown dramatically in the past decade and parallel to that technology added value and speed to the process. This proves that, use of this technology will grow dramatically in the next few years.
DWBI had a positive impact in the challenging times for making better decision running the business. A good decision-making becomes critical in testing economy and low business. 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 by different vendors available in the market today and companies of different 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 special 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 main source of information for report generation, analysis, and presentation through ad hoc reports, portals, and dashboards.
What is Data Warehouse?:
Defining a Data warehouse is very simple. 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.