Data Analytics

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

Case Study: Business Objects Development and Modification

The Challenge

A large federal procurement organization established a Business Intelligence Enterprise Data Warehouse (BIEDW) to support reporting and analysis, and promote more informed decision making using data from agency financial and operational systems. They sought to more closely integrate their BIEDW and fully leverage their Business Objects investment through an Agile project approach.

The Solution

Salient CRGT uses an innovative approach to address the nuances of BIEDW development, ensuring that projects are robust, flexible, and adaptable, and have completeness of vision. We follow Agile methodology principles to design an iterative development lifecycle that considers evolving requirements and heavily relies on user input. Our project management incorporates quality management to create a more integrated data warehouse through better data quality and governance.

During the 12-month period of performance, Salient CRGT created a technical solution plan that included identification of internal and external data sources, and outlined the development of ETL processes to connect these data sources. To better serve their more than 1,500 users, and support of 1,200 reporting and ETL objects, we worked closely with the Office of the Chief Information Officer (OCIO) to develop new, and modified existing, Business Objects universes to provide data to users in a useful context. Specifically, this meant designing and creating source code and databases, converting data, and performing quality, regression, and acceptance testing.

The team also developed Business Objects reports and interactive dashboards for the system users to complete their work more efficiently. Salient CRGT created a test and implementation plan to validate that the update dashboard and reporting solutions met the requirements and goals of the customer and external users.

The Impact

Salient CRGT transitioned from a previous contractor’s Waterfall development methodology to an Agile Scrum methodology for all of its custom application and Business Intelligence development tasks. The Salient CRGT Team is led by a Certified Scrum Master, who is responsible for day-to-day coordination of team tasks and communication with designated OCIO Project Manager. Under the Waterfall method, the estimation process used to determine project scope and cost periodically resulted in unreliable estimates. Working from Salient CRGT’s best practices and drawing from previous project experiences, we implemented a new rough order of magnitude (ROM) estimation process. The ROM estimation process relies on Salient CRGT’s experience with Business Intelligence Agile development and a 360-degree feedback, resulting in development of realistic and accurate estimates.