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
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