In today’s business environment, it’s no longer optional to have a single, enterprise-wide and integrated view of financial and investment data – it’s mandatory. New regulatory requirements such as Sarbanes-Oxley, International Accounting Standards (IAS), Anti-Money Laundering (AML), and Basel II Accords for financial institutions mandate that data across the enterprise be centralized, integrated, accurate, and auditable.

The practice of data warehousing is steadily pushing analytics from the executive level down to the tactical and operational levels throughout the enterprise. Data warehousing has become a mission critical facet of businesses simply because its absence or degradation impacts the ability of an organization to focus on achieving its fiscal responsibilities and revenue generation goals.

QED Data Mart

By extracting all data relevant to the business decision-making processes from the Q2 production system and protecting the production environment from the impact of organizational data mining and data analysis, the QED DataMart promotes data centricity and enables organizations to easily share data across their enterprises. The QED DataMart aggregates and summarizes enterprise investment data in a dimensional model – a hierarchical composition of facts presented using multiple views across dynamic dimensions. The extraction process copies relevant data from Q2, scrubbing the data to remove anomalies, inconsistencies, and unnecessary information, and enriches the data by translating numeric codes and acronyms into easy-to-understand textual information.

The QED DataMart has a simpler database structure that enhances an organization’s ability to perform routine data analysis and complex data mining without causing degradation to time-sensitive operational business processes, such as data entry and data communications. Additionally, the QED DataMart protects the integrity and security of proprietary investment data by selectively separating data for analysis into an ODBC-compliant environment specifically designed for access by a variety of reporting tools such as Oracle Discoverer, Microsoft Access, Crystal Reports, and Brio.