Client: Major U.S. Military Branch
Service: Data Quality, Data Profiling
Industry: Government; Defense
Business Case
This client’s Global Combat Support System (GCSS) was working to improve combat effectiveness of the operating forces and to support emerging doctrines and war fighting strategies. An urgent need exists to better label and track equipment in order to positively impact war fighting efforts and reduce data anomalies and errors. A technical initiative was created to address and direct efforts relating to data profiling, data cleansing, data integration and data governance.
Solution
During an initial short term engagement, Data Blueprint successfully conducted a data quality and data profiling initiative. The business value provided by our solution included:
- A cost-effective, repeatable process for identifying potential data health issues
- Data quality remediation plans that can be easily prioritized and resourced using the metrics generated by our approach
- Potential reductions in cost and risk realized by implementing necessary data quality controls discovered during the data profiling phase
- Potential reduction in the cost of system migrations due to the automated approach
Technical Environment
- Informatica Data Explorer 8.0
- Microsoft SQL Server
Results
The many benefits that this client realized from Data Blueprint’s solution include:
- Identification of approximately $5 billion of equipment that does not tie out between two critical operational systems
- Realization that approximately $531 million of SAC 3 items have duplicated serial numbers
As a result of the success of this project, Data Blueprint was engaged to assist on a larger, more inclusive data profiling, cleansing, and integration project.
