Matteo Golfarelli
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.
- Applix Inc. The TM1 platform: Taking business performance management to a new dimension. http://www.applix.com, 2005.Google Scholar
- S. Armstrong and R. Brodie. Forecasting for marketing. In G. Hooley and M. Hussey, editors, Quantitative methods in marketing, pages 92--119. Int. Thompson Business Press, 1999.Google Scholar
- P. Baybutt. Major hazards analysis - an improved process hazard analysis method. Process Safety Progress, 22(1):21--26, 2003.Google ScholarCross Ref
- H.K. Bhargava, R. Krishnan, and R. Müller. Electronic commerce in decision technologies: A business cycle analysis. Int. Jour. of Electronic Commerce, 1(4):109--127, 1997. Google ScholarDigital Library
- S. Chaudhuri and V. Narasayya. Autoadmin what-if index analysis utility. SIGMOD Rec., 27(2):367--378, 1998. Google ScholarDigital Library
- B. Chen, L. Chen, Y. Lin, and R. Ramakrishnan. Prediction cubes. In Int.Google Scholar
- R.G. Coyle. System Dynamics Modelling: A Practical Approach. Chapman & Hall, London, 1996.Google Scholar
- R. Fischer. Business Planning With SAP SEM. SAP Press, 2005.Google Scholar
- J.W. Forrester. Industrial Dynamics. MIT Press, Cambridge, MA, 1961.Google Scholar
- C. Fossett, D. Harrison, and H. Weintrob. An assessment procedure for simulation models: a case study. Operations Research, 39(5):710--723, 1991. Google ScholarDigital Library
- M. Golfarelli, D. Maio, and S. Rizzi. The Dimensional Fact Model: A conceptual model for data warehouses. Int. Jour. of Cooperative Inf. Syst., 7(2-3):215--247, 1998.Google ScholarCross Ref
- J. Kleijnen. Sensitivity analysis and optimization in simulation models: design of experiments and case studies. In Proc. Winter Simulation Conf., 1995. Google ScholarDigital Library
- J. Kleijnen, S. Sanchez, T. Lucas, and T. Cioppa. State-of-the-art review: A user's guide to the brave new world of designing simulation experiments. INFORMS Jour. on Computing, 17(3):263--289, 2005. Google ScholarDigital Library
- R. Klosterman. The What if? collaborative support system. Environment and Planning, B: Planning and Design, 26:393--408, 1999.Google ScholarCross Ref
- N.-S. Koutsoukis, G. Mitra, and C. Lucas. Adapting on-line analytical processing for decision modelling: the interaction of information and decision technologies. Decis. Support Syst., 26(1):1--30, 1999. Google ScholarDigital Library
- I. Lee and M. Gahegan. What-if analysis for point data sets using generalised Voronoi diagrams. In Proc. Int. Conf. on GeoComputation, Greenwich, UK, 2000.Google Scholar
- M. Leonard. Large-scale automatic forecasting with inputs and calendar events. In Proc. Workshop on Temporal Data Mining, San Francisco, US, 2001.Google Scholar
- L.F. Luna-Reyes and D.L. Andersen. Collecting and analyzing qualitative data for system dynamics: methods and models. System Dynamics Review, 19(4):271--296, 2004.Google ScholarCross Ref
- A. Natrajan. Consistency Maintenance in Concurrent Representations. PhD thesis, Dep. Computer Science, Univ. of Virginia, 2000. Google ScholarDigital Library
- A. Philippakis. Structured what if analysis in DSS models. In Proc. HICSS, pages 366--370, 1988. Google ScholarDigital Library
- H. Qudrat-Ullah. Structural validation of system dynamics and agent-based simulation models. In Proc. European Conf. on Modelling and Simulation 2005.Google Scholar
- E.B. Roberts. Managerial Applications of System Dynamics. Pegasus Communications, 1999.Google Scholar
- S.R. Srinivasan, S. Ramakrishnan, and S.E. Grasman. Incorporating cannibalization models into demand forecasting. Marketing Intelligence & Planning, 23(5):470--485, 2005.Google ScholarCross Ref
Index Terms
- Designing what-if analysis: towards a methodology
Recommendations
Generating What-If Scenarios for Time Series Data
SSDBM '17: Proceedings of the 29th International Conference on Scientific and Statistical Database ManagementTime series data has become a ubiquitous and important data source in many application domains. Most companies and organizations strongly rely on this data for critical tasks like decision-making, planning, predictions, and analytics in general. While ...
Discovering Analytical Preferences for Personalizing What-If Scenarios
Progress in Artificial IntelligenceAbstractIn this paper, we expose a hybridization methodology for helping to overcome the pitfalls of conventional What-If analysis process design and development by discovering the best recommendations for What-If analysis scenarios’ parameters using OLAP ...
The Tradeoff of Delta Table Merging and Re-writing Algorithms in What-If Analysis Application
APWeb/WAIM '09: Proceedings of the Joint International Conferences on Advances in Data and Web ManagementWhat-if analysis can provide more meaningful information than classical OLAP. Multi-scenario hypothesis based on historical data needs efficient what-if data view support. In general, delta table for what-if analysis is more general than other solutions ...
Comments