Data Warehousing

A Data Warehouse stores a subset of the data from your transactional system. However, unlike a transactional system, which is optimized for accepting and processing orders, the Data Warehouse is optimized for reporting and analysis of large sets of data, affording the information consumer more flexibility while protecting the main system from performance issues often associated with running reports. Additionally the Data Warehouse can store large volumes of historical data, allowing the main system to be purged of seldom-used information. Old orders and invoices can be transferred to the Data Warehouse, reducing storage and processing requirements so your hardware lasts longer with fewer disruptive and costly upgrades.

Another major benefit of Data Warehousing is the ability to incorporate data from sources other than your transactional system. Budget and Finance spreadsheets can be imported into the Data Warehouse to enhance analysis capabilities. Rather than cutting and pasting spreadsheets monthly for error-prone analysis, the information will automatically be available daily so decisions can be made while the issues are still relevant.

At B.I. Advantage we specialize in developing Data Warehouses that require no user attention except for rotating backup tapes. In conjunction with the Cognos reporting and analysis tools, the Data Warehouse becomes the platform upon which to manage your business to higher profitability. Contact us to discuss how this technology can help your company.