The Challenge

The number of reports generated by the company’s reporting system made it difficult for users to find information and put a strain on IT resources. Ball Aerospace needed a self-service reporting solution that would make information easy to access with minimal IT support.

The Solution

Using Microsoft SQL Server, Neudesic developed an enterprise data warehouse that integrated multiple information sources. Neudesic leveraged its ETL Accelerator with SQL Server Integration Systems to develop processing standards, and then developed cubes to allow user customization. Drill through capabilities were also incorporated to provide transparency

The Benefit

  • Users are easily able to access information with Microsoft Excel
  • Financial information is updated on a daily basis and provides ‘point in time’ reporting
  • The new platform is highly supportable and extensible for future development