Regional demand forecast

data

Objective

A supplier of medical instruments needed to forecast demand for its products in a particular region over twenty years.

Key challenges:

  • Calculating demand by region and diagnosis type
  • Creating an intuitive analysis interface for non-technical users
  • Dynamically generating user-defined reports
2

Technical solution

A compact decision support tool based on standard Microsoft Office components (Excel, Access, PowerPoint), capable of

  • Importing data from the client's systems
  • Calculating and presenting results on a regional map
  • Exporting selected results to a PowerPoint report
impact

Result

  • Interactive analysis tool provides an intuitive, graphical analysis interface
  • Drill down functionality allows analysis of data by sub-region by zooming into an area of interest on the map
  • User filtered data tables and graphs can be created for several different data cuts and analysis parameters