Article

Designing what-if analysis: towards a methodology

Authors:

Matteo Golfarelli,

Andrea ProliAuthors Info & Claims

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

Pages 51 - 58

https://doi.org/10.1145/1183512.1183523

Published: 10 November 2006 Publication History

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.

References

[1]

Applix Inc. The TM1 platform: Taking business performance management to a new dimension. http://www.applix.com, 2005.

[2]

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.

[3]

P. Baybutt. Major hazards analysis - an improved process hazard analysis method. Process Safety Progress, 22(1):21--26, 2003.

[4]

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.

Digital Library

[5]

S. Chaudhuri and V. Narasayya. Autoadmin what-if index analysis utility. SIGMOD Rec., 27(2):367--378, 1998.

Digital Library

[6]

B. Chen, L. Chen, Y. Lin, and R. Ramakrishnan. Prediction cubes. In Int.

[7]

R.G. Coyle. System Dynamics Modelling: A Practical Approach. Chapman & Hall, London, 1996.

[8]

R. Fischer. Business Planning With SAP SEM. SAP Press, 2005.

[9]

J.W. Forrester. Industrial Dynamics. MIT Press, Cambridge, MA, 1961.

[10]

C. Fossett, D. Harrison, and H. Weintrob. An assessment procedure for simulation models: a case study. Operations Research, 39(5):710--723, 1991.

Digital Library

[11]

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.

[12]

J. Kleijnen. Sensitivity analysis and optimization in simulation models: design of experiments and case studies. In Proc. Winter Simulation Conf., 1995.

Digital Library

[13]

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.

Digital Library

[14]

R. Klosterman. The What if? collaborative support system. Environment and Planning, B: Planning and Design, 26:393--408, 1999.

[15]

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.

Digital Library

[16]

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.

[17]

M. Leonard. Large-scale automatic forecasting with inputs and calendar events. In Proc. Workshop on Temporal Data Mining, San Francisco, US, 2001.

[18]

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.

[19]

A. Natrajan. Consistency Maintenance in Concurrent Representations. PhD thesis, Dep. Computer Science, Univ. of Virginia, 2000.

Digital Library

[20]

A. Philippakis. Structured what if analysis in DSS models. In Proc. HICSS, pages 366--370, 1988.

Digital Library

[21]

H. Qudrat-Ullah. Structural validation of system dynamics and agent-based simulation models. In Proc. European Conf. on Modelling and Simulation 2005.

[22]

E.B. Roberts. Managerial Applications of System Dynamics. Pegasus Communications, 1999.

[23]

S.R. Srinivasan, S. Ramakrishnan, and S.E. Grasman. Incorporating cannibalization models into demand forecasting. Marketing Intelligence & Planning, 23(5):470--485, 2005.

Cited By

Gumede NHattingh T(2025)De-densifying the black hole – what if professional discretion strongly influences corporate social responsibility?European Business Review10.1108/EBR-11-2023-0347Online publication date: 14-Feb-2025
https://doi.org/10.1108/EBR-11-2023-0347
Cummins LSommers AMittal SRahimi SSeale MJabour JArnold T(2024)Explainable Anomaly Detection: Counterfactual driven What-If Analysis2024 IEEE 6th International Conference on Cognitive Machine Intelligence (CogMI)10.1109/CogMI62246.2024.00028(144-151)Online publication date: 28-Oct-2024
https://doi.org/10.1109/CogMI62246.2024.00028
Pröll BSchwinger WKapsammer ERetschitzegger WSchönböck JLechner M(2023)Towards a Digital Platform for Goal-oriented and Competence-based Bundling of Volunteering2023 18th Iberian Conference on Information Systems and Technologies (CISTI)10.23919/CISTI58278.2023.10211528(1-4)Online publication date: 20-Jun-2023
https://doi.org/10.23919/CISTI58278.2023.10211528
Show More Cited By

Index Terms

Designing what-if analysis: towards a methodology
1. Applied computing
  1. Operations research
    1. Decision analysis
2. Information systems
  1. Information systems applications
    1. Decision support systems

Recommendations

Generating What-If Scenarios for Time Series Data
SSDBM '17: Proceedings of the 29th International Conference on Scientific and Statistical Database Management

Time 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 Intelligence
Abstract
In 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 Management

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

Information & Contributors

Information

Published In

cover image ACM Conferences

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

November 2006

110 pages

ISBN:1595935304

DOI:10.1145/1183512

General Chair:
Il-Yeol Song
Drexel University
,
Program Chair:
Panos Vassiliadis
University of Ioannina, Greece

Copyright © 2006 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 10 November 2006

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tag

what-if analysis

Qualifiers

Article

Conference

CIKM06

Sponsor:

CIKM06: Conference on Information and Knowledge Management

November 10, 2006

Virginia, Arlington, USA

Acceptance Rates

Overall Acceptance Rate 29 of 79 submissions, 37%

Upcoming Conference

CIKM '25

Sponsor:
sigir
sigir

The 34th ACM International Conference on Information and Knowledge Management

November 10 - 14, 2025

Seoul , Republic of Korea

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

43
Total Citations
View Citations
1,733
Total Downloads

Downloads (Last 12 months)76
Downloads (Last 6 weeks)13

Reflects downloads up to 01 Mar 2025

Other Metrics

View Author Metrics

Citations

Cited By

Gumede NHattingh T(2025)De-densifying the black hole – what if professional discretion strongly influences corporate social responsibility?European Business Review10.1108/EBR-11-2023-0347Online publication date: 14-Feb-2025
https://doi.org/10.1108/EBR-11-2023-0347
Cummins LSommers AMittal SRahimi SSeale MJabour JArnold T(2024)Explainable Anomaly Detection: Counterfactual driven What-If Analysis2024 IEEE 6th International Conference on Cognitive Machine Intelligence (CogMI)10.1109/CogMI62246.2024.00028(144-151)Online publication date: 28-Oct-2024
https://doi.org/10.1109/CogMI62246.2024.00028
Pröll BSchwinger WKapsammer ERetschitzegger WSchönböck JLechner M(2023)Towards a Digital Platform for Goal-oriented and Competence-based Bundling of Volunteering2023 18th Iberian Conference on Information Systems and Technologies (CISTI)10.23919/CISTI58278.2023.10211528(1-4)Online publication date: 20-Jun-2023
https://doi.org/10.23919/CISTI58278.2023.10211528
Groner RBellmann PHöppner SThiam PSchwenker FTichy MVieira MCardellini VDi Marco ATuma P(2023)Predicting the Performance of ATL Model TransformationsProceedings of the 2023 ACM/SPEC International Conference on Performance Engineering10.1145/3578244.3583727(77-89)Online publication date: 15-Apr-2023
https://dl.acm.org/doi/10.1145/3578244.3583727
Ben Rabia MBellabdaoui A(2023)Collaborative intuitionistic fuzzy-AHP to evaluate simulation-based analytics for freight transportExpert Systems with Applications10.1016/j.eswa.2023.120116225(120116)Online publication date: Sep-2023
https://doi.org/10.1016/j.eswa.2023.120116
Polyzoidou EPapagiannaki ENikolaidis NAmpatzoglou AMittas NArvanitou EChatzigeorgiou AManolis GManganopoulou E(2023) SmartCLIDE design pattern assistant: A decision‐tree based approach Software: Practice and Experience10.1002/spe.318953:6(1304-1331)Online publication date: 11-Feb-2023
https://doi.org/10.1002/spe.3189
E-Fatima KKhandan RHosseinian-Far ASarwar DAhmed H(2022)Adoption and Influence of Robotic Process Automation in Beef Supply ChainsLogistics10.3390/logistics60300486:3(48)Online publication date: 12-Jul-2022
https://doi.org/10.3390/logistics6030048
Zhang CWang XZhao CRen YZhang TPeng ZFan XMa XLi Q(2022)PromotionLens: Inspecting Promotion Strategies of Online E-commerce Via Visual AnalyticsIEEE Transactions on Visualization and Computer Graphics10.1109/TVCG.2022.3209440(1-11)Online publication date: 2022
https://doi.org/10.1109/TVCG.2022.3209440
Bellini PBilotta SPalesi ANesi PPantaleo G(2022)Vehicular Traffic Flow Reconstruction Analysis to Mitigate Scenarios With Large City ChangesIEEE Access10.1109/ACCESS.2022.322918310(131061-131075)Online publication date: 2022
https://doi.org/10.1109/ACCESS.2022.3229183
Renna APetrelli MCarrese SBertocci R(2021)An Innovative Simulation Agent-Based Model for the Combined Sea-Road Transport as a DSSSustainability10.3390/su13191077313:19(10773)Online publication date: 28-Sep-2021
https://doi.org/10.3390/su131910773
Show More Cited By

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Figures

Tables

Media

View Table of Conten