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

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)

Embedded plausibility checks in data entry tool ensures data quality

Strict roll-out and consolidation schedule is supported by tight version management end-to-end