Designing what-if analysis: towards a methodology

  • Authors:
  • Matteo Golfarelli;Stefano Rizzi;Andrea Proli

  • Affiliations:
  • University of Bologna - Italy;University of Bologna - Italy;University of Bologna - Italy

  • Venue:
  • DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
  • Year:
  • 2006

Quantified Score

Hi-index 0.00

Visualization

Abstract

In order to be able to evaluate beforehand the impact of a strategical or tactical move, decision makers need reliable previsional systems. What-ifanalysis satisifies this need by enabling users to simulate and inspect the behavior of a complex system under some given hypotheses, called scenarios. Though a few commercial tools are capable of performing forecasting and what-if analysis, and some papers describe relevant applications in different fields, no attempt has been made so far to comprehensively address methodological and modeling issues in this field. This paper is a preliminary work in the direction of devising a structured approach to designing what-if applications in the BI context. Its goal is to summarize the main lessons we have learnt by facing real what-if projects, and to discuss the related research issues. We also provide a methodological framework for design and discuss its application to a case study.