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. There is an urgent need 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 profiling initiative on six data sources.
TECHNICAL ENVIRONMENT
- Informatica Data Explorer 8.0
- Microsoft SQL Server
RESULTS
The many benefits that this client realized from Data Blueprint’s solution include:
- Identified approximately $5 billion of equipment does not tie out between two critical operational systems
- Approximately $531 million of SAC 3 items have duplicated serial numbers
Data Blueprint is engaged to assist on a larger, more inclusive data profiling, cleansing, and integration project.