Program tracking for global initiative

data

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
2

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
impact

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)
Industry
Logistics
Tool type
Program tracking
Project duration
2 months
d2i effort
30 days
Data volume
10-30 KPIs per initiative
180 country locations
20 initiatives
Complex/large country data
Tools involved
Access
Excel