OPDEC - Operational Decision Software & Services header image
Data Integration & Reporting
The functional requirement to partition an office based upon the defined roles within the office (Business, Production, Quality Control, and Fleet Management) creates the unintended consequences of each group developing their own data sets tailored to their specific requirements. As a result, these individual data sets, while valid as a stand alone resource, cannot be seen along with the other data sets in an executive level summary.
Data Integration & ReportingIssue
  • Too much time and effort is spent trying to find data rather then analyzing the data to make decisions.
  • Excessive time is spent preparing briefings that when completed, are already outdated.
  • Multiple locations of data sets cause the duplication of data elements within an office and increase the chances of data corruption.
  • No top level visibility of the data sets.
  • Data interrelationships are not visible at the executive level.
Solution
  • Develop tools/processes that decrease preparation time
  • Establish mechanisms to verify the integrity and validity of data
  • Present the pertinent data elements from these separate data sets in a web-based control panel with controlled viewing rights.
Results
  • Increased operational and organizational efficiencies. Eliminates the collection of duplicate data elements.
  • Eliminates the same process being repeated for each separate data set. Does away with repetitive processes and thereby increasing user productivity.
  • Ability to present detailed as well as summary level data for various levels of office interests.
  • Flexible architecture to allow for requirement changes.
  • Centralizes all desired data into one source.
  • Assures program data security, integrity, and protection.
Summary
  • This modernized and powerful data reporting system will reduce repetitive requirements and enable summary viewing at all levels within the office.