A data warehouse’s integrity transcends operational system changes such as installing a new traffic or billing system. Because it acts as a repository for multiple transactional systems, it is a relatively easy task to change an operational system from which a data warehouse extracts data. Once your data warehouse is established, the historical data within it remains intact through any operational system conversion. Therefore, as your business needs grow and change your data warehouse remains the single trusted and auditable SOURCE for your historical facts regardless of where they originated from.
The Media Data Warehouse and Business Intelligence system is complimentary to any operational systems already in place. A modern Data Warehouse is the securable repository for all your historical transactional data and consequently should be an important component of your Sarbanes Oxley compliance procedures.
BIAnalytix is an advanced Data Warehouse and Business Intelligence system built on a SQL Server Analysis Services warehouse platform. It makes extensive use of the security framework built into SSAS to ensure that the warehouse is only accessible by authorized personnel. The BIAnalytix warehouse is, by design, read only and is therefore a reliable source of snapshots of your organization’s data exactly as it was when it was extracted from any of your operational systems including throughout your conversions from a legacy to a new generation operational system.