Original Date: 08/20/2001
Revision Date: 12/14/2006
Best Practice : Operations Data Warehouse
In 1996, Lockheed Martin Naval Electronics & Surveillance Systems-Surface Systems developed the Operations Data Warehouse. This consolidated electronic database provides vital real-time, business critical operations data and metrics to engineers and managers.
Lockheed Martin Naval Electronics & Surveillance Systems-Surface Systems (NE&SS-SS) previously used an antiquated method of weekly downloading and printing of Production and Inventory Optimization System manufacturing data. The need for report flexibility, timeliness, and ease of data capture drove the company to develop a data warehouse software system. Developed in 1996 and deployed in 1997, the Operations Data Warehouse truly thrived in 2000 when countless user-defined, ad-hoc queries became a staple of management review for critical events.
The Operations Data Warehouse is an extremely powerful program that hosts endless data query possibilities for the user. It provides a repository of detailed and summarized data, drawn (weekly or daily) from operational or legacy systems, and is designed for analysis and decision support purposes. By viewing all data through one trusted data collection/distribution program, users are assured data consistency. Access to captured data provides capabilities to monitor production trends, desktop access to reports, and continued growth in information reporting and analysis. All data is easily manipulated via Microsoft Office (e.g., Excel, Access) and can be electronically transmitted to suppliers and customers to further reduce issue cycle times. The utilization of Hummingbird BI/Query (formerly Andyne GQL) proved to be powerful, but expensive to license for all users due to Lockheed Martin NE&SS-SS’ overestimation of ad-hoc report generation. Pertinent information is available via the web for business-wide access, thereby further enabling productivity.
Since implementing the Operations Data Warehouse, Lockheed Martin NE&SS-SS has eliminated several tons of paper reports which had been generated weekly. The database provides vital real-time, business critical operations data to engineers and managers. Additional data capture reports are easily acquired through this user-friendly tool.
For more information see the
Point of Contact for this survey.