Program tracking for global initiative

Objective

A logistics client needs to collect monthly KPIs from 180 country locations and create scorecards for central office review.

Key challenges:

• Data must be submitted by e-mail (no intranet connectivity for some users)
• Data needs to be pre-populated by central office monthly
• Large amount of country data, but most country users do not have access to a database application

Technical solution

• Password protected Excel files allow data entry based on user level. Files are sent back and forth between countries and regional headquarters
• Rigid version control (based on monthly schedules, embedded in tool) is used to ensure consistency over time
• Import and export features to allow data collection and distribution of centrally available data

Result

• Central Access-based tool manages consolidated dataset and creates scorecard reports automatically
• Excel-based interface collects and organizes country data, using a database back-end (no separate database software is needed)