Data Analytics

Data analytics empowers stakeholders to use organizational data to improve decision making, increase productivity, and realize significant cost savings.

Case Study: Enabling Increased Transparency Using Oracle Business Intelligence

Background

A federal agency used a legacy reporting system that attempted to pull data from multiple systems into a SQL Server database while using a Microsoft Access database interface. Data was often structured for one specific report requirement, making it difficult to reconcile figures and generate consistent results.

The Challenge

The technical environment was not conducive to addressing ad hoc requests or providing transparency to the public in an efficient manner. The system lacked the ability to store the data in an accessible way and track changes over time, making it difficult to reproduce past fiscal year reports without significant manual intervention.

The agency needed to provide more accurate and timely transparency into their operations for their internal and external constituents. They required a business intelligence system across their enterprise that provided the flexibility required to meet government-mandated reporting needs, management decision making, and address public inquiries.

The Solution

Within nine months, Salient CRGT developed a new Enterprise Reporting System (ERS) to increase efficiency and productivity, and improve measurability and accountability. This system supports budget planning and management for the Agency and their stakeholders.

We selected a complete stack of Oracle Business Intelligence and Data Warehouse products, including Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Data Integrator (ODI), and Oracle 11g database to develop and deploy the new system. We successfully consolidated data from every major operational system at the agency into a single, unified system. The new system consists of 35 interactive dashboards spanning six unique subject areas, replacing over 300 static legacy reports.

The system refreshes the data nightly through ODI ETL processes with all pertinent data being tracked and versioned. The system is able to leverage ODI and OBIEE tools to monitor, track, and alert support staff to issues or anomalies in the regular data loading process.

The Impact

The agency can address requests for information from the public faster and these requests require fewer agency resources. Previously it took days to answer a request–now the baseline data can be reported in a matter of minutes. This near real-time access to data benefits the internal executive team, enabling them to make better decisions concerning agency operations.

This new system has reduced the number of reports from more than 300 to 35 by using a guided analysis approach within OBIEE that facilitates drilling down through the data. This has improved the user experience and the flexibility needed for ad hoc report creation.