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
Cookies make it easier for us to provide you with our services. With the usage of our services you permit us to use cookies.
Ok