| When Information Technology (IT) has set the | | | | saving! Let's have a look at a few more benefits of |
| foundation for organizational performance, at the | | | | having a data warehouse in organizational settings: |
| same time the increasing processing power and | | | | - With data warehousing, an organization can provide |
| upliftment in analytical tools and techniques resulted in | | | | a common data model for different interest areas, |
| the advancement of a product called data | | | | regardless of the data's source. It becomes easier |
| warehouse. Data warehouse refers to a set of new | | | | for the organization to report and analyze |
| concepts and tools that is being incorporated | | | | information. |
| together to evolve into a technology. Where or | | | | - With data warehousing, a number of inconsistencies |
| when is it important? Well, data warehousing | | | | can be found. These inconsistencies can be resolved |
| becomes instrumental when you want to get | | | | before loading of information, which makes the |
| information on all the techniques of designing, | | | | reporting process much easier and simpler. |
| maintaining, building and retrieving data! | | | | - Having a data warehouse means having the |
| In other words, data warehousing is an organized and | | | | information under the control of the user or |
| resourceful method of managing and reporting | | | | organization. |
| scattered data throughout an organization. It is | | | | - Since a data warehouse is different from |
| generated with the purpose to support the decision | | | | operational systems, it helps in retrieving data without |
| making process within an organization. As Bill Inmon, | | | | slowing down the operational system. |
| who coined the term defines "A warehouse is a | | | | - Data warehousing is instrumental in enhancing the |
| subject-oriented, integrated, time-variant and | | | | value of operational business applications and |
| non-volatile collection of data in support of | | | | customer relationship management systems. |
| management's decision making process." | | | | In fact, data warehouses evolved in a need to help |
| For over the last two decades, organizations have | | | | organizations with their management and business |
| been confident about the support of data | | | | analysis to meet different demands that could not be |
| warehousing. Why not? There are solid reasons for | | | | met with their operational systems. However, this |
| organizations to consider a data warehouse, as it | | | | does not mean each and every project would be |
| comes across as a critical tool for maximizing their | | | | successful with the help of data warehousing. |
| investment in the information that is being collected | | | | Sometimes the complicated techniques and erroneous |
| and stored over a long period of time. The salient | | | | data employed in the process may cause errors and |
| feature of a data warehouse is that it records, | | | | failure. |
| collects, filters and provides with the basic information | | | | Data warehouses came into the picture of |
| to different systems at higher levels. A very basic | | | | organizational settings in the late 1980s and early |
| benefit of having a data warehouse is- with a data | | | | 1990s and ever since this type of distinctive |
| warehouse it becomes very easy for an organization | | | | computer database has been helping organizations in |
| to counter all the problems faced during providing | | | | supporting decision-making information for |
| key information to concerned person without | | | | management or departments. |
| hampering the ongoing production system. It is time | | | | |