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

Join for free to read