Prioritising data items for business analytics: Framework and application to human resources

The popularity of business intelligence (BI) systems to support business analytics has tremendously increased in the last decade. The determination of data items that should be stored in the BI system is vital to ensure the success of an organisation's business analytic strategy. Expanding conventional BI systems often leads to high costs of internally generating, cleansing and maintaining new data items whilst the additional data storage costs are in many cases of minor concern – what is a conceptual difference to big data systems. Thus, potential additional insights resulting from a new data item in the BI system need to be balanced with the often high costs of data creation. While the literature acknowledges this decision problem, no model-based approach to inform this decision has hitherto been proposed. The present research describes a prescriptive framework to prioritise data items for business analytics and applies it to human resources. To achieve this goal, the proposed framework captures core business activities in a comprehensive process map and assesses their relative importance and possible data support with multi-criteria decision analysis.

[1]  Justus D. Naumann,et al.  Empirical investigation of systems development practices and results , 1984, Inf. Manag..

[2]  Alexander Schwartz,et al.  Decision Analysis And Behavioral Research , 2016 .

[3]  Ilkka Tuomi,et al.  Data is more than knowledge: implications of the reversed knowledge hierarchy for knowledge management and organizational memory , 1999, Proceedings of the 32nd Annual Hawaii International Conference on Systems Sciences. 1999. HICSS-32. Abstracts and CD-ROM of Full Papers.

[4]  Arkalgud Ramaprasad,et al.  Design, development and implementation of a global information warehouse: a case study at IBM , 1998, Inf. Syst. J..

[5]  Sandie Wong,et al.  Tales from the frontline: the experiences of early childhood practitioners working with an 'embedded' research team. , 2009, Evaluation and program planning.

[6]  R. Keeney,et al.  Advances in Decision Analysis: Practical Value Models , 2007 .

[7]  W. Edwards,et al.  Decision Analysis and Behavioral Research , 1986 .

[8]  Ward Edwards,et al.  SIMPLICITY IN DECISION ANALYSIS: AN EXAMPLE AND A DISCUSSION , 1983 .

[9]  Jaelson Brelaz de Castro,et al.  DWARF: an approach for requirements definition and management of data warehouse systems , 2003, Proceedings. 11th IEEE International Requirements Engineering Conference, 2003..

[10]  Efraim Turban,et al.  Business Intelligence: Second European Summer School, eBISS 2012, Brussels, Belgium, July 15-21, 2012, Tutorial Lectures , 2013 .

[11]  Vicente Liern,et al.  Soft computing-based aggregation methods for human resource management , 2008, Eur. J. Oper. Res..

[12]  J. E. de Steiguer,et al.  AHP as a means for improving public participation: a pre-post experiment with university students , 2005 .

[13]  August-Wilhelm Scheer,et al.  Business Process Excellence , 2002 .

[14]  Andrea De Mauro,et al.  What is big data? A consensual definition and a review of key research topics , 2015, AIP Conference Proceedings.

[15]  Erik Brynjolfsson,et al.  Three-Way Complementarities: Performance Pay, Human Resource Analytics, and Information Technology , 2012, Manag. Sci..

[16]  Jac Fitz-enz,et al.  The New HR Analytics: Predicting the Economic Value of Your Company's Human Capital Investments , 2010 .

[17]  Jose-Norberto Mazón,et al.  Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms , 2007, Data Knowl. Eng..

[18]  Thilini Ariyachandra,et al.  Data warehouse governance: best practices at Blue Cross and Blue Shield of North Carolina , 2004, Decis. Support Syst..

[19]  Paulo B. Góes,et al.  Business Intelligence and Analytics Education, and Program Development: A Unique Opportunity for the Information Systems Discipline , 2012, TMIS.

[20]  John R. Doyle,et al.  A comparison of three weight elicitation methods: good, better, and best , 2001 .

[21]  Gordon Miller,et al.  Decision Making: Descriptive, Normative, and Prescriptive Interactions , 1990 .

[22]  W. Edwards How to Use Multi-Attribute Utility Measurement for Social Decision Making , 1976 .

[23]  G. Parra,et al.  Mayer Schönberger, Viktor; Cukier, Kenneth. Big Data: A Revolution That Will Transform How We Live, Work and Think. London: John Murray, 2013 , 2015 .

[24]  Dursun Delen,et al.  Data, information and analytics as services , 2013, Decis. Support Syst..

[25]  Richard J. Ormerod Putting Soft OR Methods to Work: Information Systems Strategy Development at Sainsbury's , 1995 .

[26]  John W. Boudreau,et al.  Retooling HR: Using Proven Business Tools to Make Better Decisions About Talent , 2010 .

[27]  Michael Armstrong,et al.  Armstrong's Handbook of Human Resource Management Practice , 2020 .

[28]  Wayne F. Cascio,et al.  Investing in People: Financial Impact of Human Resource Initiatives , 2008 .

[29]  Martin J. Eppler,et al.  A Classification and Analysis of Data Quality Costs , 2004 .

[30]  Giles Slinger,et al.  Will Organization Design Be Affected by Big Data? , 2014 .

[31]  J. Mingers,et al.  Rational analysis for a problematic world revisited : problem structuring methods for complexity, uncertainty and conflict , 1989 .

[32]  C. B. E. Costa,et al.  Facilitating bid evaluation in public call for tenders: a socio-technical approach , 2002 .

[33]  Ward Edwards,et al.  How to Use Multiattribute Utility Measurement for Social Decisionmaking , 1977, IEEE Transactions on Systems, Man, and Cybernetics.

[34]  David Loshin Data Requirements Analysis , 2011 .

[35]  James C. Wetherbe Executive Information Requirements: Getting It Right , 1991, MIS Q..

[36]  T. Saaty How to Make a Decision: The Analytic Hierarchy Process , 1990 .

[37]  Liang Zhong Shen,et al.  Design and Implementation of ETL in Police Intelligence Data Warehouse System , 2011 .

[38]  Martin Utley,et al.  Moving improvement research closer to practice: the Researcher-in-Residence model , 2014, BMJ quality & safety.

[39]  Giri Kumar Tayi,et al.  Enhancing data quality in data warehouse environments , 1999, CACM.

[40]  Neil F. Doherty,et al.  Operational research from Taylorism to Terabytes: A research agenda for the analytics age , 2015, Eur. J. Oper. Res..

[41]  Viktor Mayer-Schnberger,et al.  Big Data: A Revolution That Will Transform How We Live, Work, and Think , 2013 .

[42]  David L. Olson Managerial Issues of Enterprise Resource Planning Systems , 2003 .

[43]  Michael P. Busch,et al.  Methodological guidelines for reducing the complexity of data warehouse development for transactional blood bank systems , 2013, Decis. Support Syst..

[44]  James C. Wetherbe,et al.  Decision impelling differences: An investigation of management by exception reporting , 1981, Inf. Manag..

[45]  Cheng F. Lee,et al.  Financial Analysis, Planning & Forecasting:Theory and Application , 2016 .

[46]  Sushil Kumar,et al.  Analytic hierarchy process: An overview of applications , 2006, Eur. J. Oper. Res..

[47]  Adir Even,et al.  Economics-Driven Data Management: An Application to the Design of Tabular Data Sets , 2007, IEEE Transactions on Knowledge and Data Engineering.

[48]  C JonesMary,et al.  Factors influencing business intelligence (BI) data collection strategies , 2012, DSS 2012.

[49]  Jose-Norberto Mazón,et al.  A hybrid model driven development framework for the multidimensional modeling of data warehouses! , 2009, SGMD.

[50]  Chih-Hung Tsai,et al.  Research on using ANP to establish a performance assessment model for business intelligence systems , 2009, Expert Syst. Appl..

[51]  Wenhong Luo,et al.  INFORMS and the Analytics Movement: The View of the Membership , 2011, Interfaces.

[52]  Maria Goddard,et al.  Performance management and Operational Research: a marriage made in heaven? , 2002, J. Oper. Res. Soc..

[53]  Matteo Golfarelli,et al.  Beyond data warehousing: what's next in business intelligence? , 2004, DOLAP '04.

[54]  Dionysis Bochtis,et al.  Conceptual model of a future farm management information system , 2010 .

[55]  Theodor J. Stewart,et al.  Multiple criteria decision analysis - an integrated approach , 2001 .

[56]  L. Phillips,et al.  Faciliated Work Groups: Theory and Practice , 1993 .

[57]  Hirofumi Matsuo,et al.  Human resource planning in knowledge-intensive operations: A model for learning with stochastic turnover , 2001, Eur. J. Oper. Res..

[58]  C. B. E. Costa,et al.  MACBETH — An Interactive Path Towards the Construction of Cardinal Value Functions , 1994 .

[59]  Neelamadhab Padhy,et al.  The Survey of Data Mining Applications And Feature Scope , 2012, ArXiv.

[60]  H Gu,et al.  The effects of averaging subjective probability estimates between and within judges. , 2000, Journal of experimental psychology. Applied.

[61]  R. Scheines,et al.  Organizational Behavior and Human Decision Processes , 1977 .

[62]  Carlos A. Bana e Costa,et al.  Transparent prioritisation, budgeting and resource allocation with multi-criteria decision analysis and decision conferencing , 2007, Ann. Oper. Res..

[63]  T. Davenport,et al.  Competing on talent analytics. , 2010, Harvard business review.

[64]  Sue Holwell,et al.  Information, Systems and Information Systems: Making Sense of the Field , 1998 .

[65]  R. Likert “Technique for the Measurement of Attitudes, A” , 2022, The SAGE Encyclopedia of Research Design.

[66]  Richard J. Ormerod,et al.  Putting soft OR methods to work: Information systems strategy development at Palabora , 1998 .

[67]  Peter Checkland,et al.  Information systems and systems thinking: time to unite? , 1988 .

[68]  Jianhua Hu,et al.  Design and Implementation of an ETL Approach in Business Intelligence Project , 2011 .

[69]  Jerry Jackson,et al.  Are US utility standby rates inhibiting diffusion of customer-owned generating systems? , 2007 .

[70]  Laetitia Vermeulen-Jourdan,et al.  Synergies between operations research and data mining: The emerging use of multi-objective approaches , 2012, Eur. J. Oper. Res..

[71]  Mostafa Jafari,et al.  Evaluation model of business intelligence for enterprise systems using fuzzy TOPSIS , 2012, Expert Syst. Appl..

[72]  Theodor J. Stewart,et al.  Multiple Criteria Decision Analysis , 2001 .

[73]  Michael Vitale,et al.  The Wisdom of Crowds , 2015, Cell.

[74]  José Telhada,et al.  An Integrated Simulation and Business Intelligence Framework for Designing and Planning Demand Responsive Transport Systems , 2013, ICCL.

[75]  Richard J. Ormerod,et al.  Putting Soft OR Methods to Work: Information Systems Strategy Development at Richards Bay , 1996 .

[76]  Solomon Negash,et al.  Platforms for Business Intelligence , 2008 .

[77]  Laurie J. Kirsch,et al.  Requirements determination for common systems: turning a global vision into a local reality , 2006, J. Strateg. Inf. Syst..

[78]  Alan R. Hevner,et al.  Integrated decision support systems: A data warehousing perspective , 2007, Decis. Support Syst..

[79]  F. B. Vernadat,et al.  Decisions with Multiple Objectives: Preferences and Value Tradeoffs , 1994 .

[80]  Jeffrey M. Keisler,et al.  An Invitation to Portfolio Decision Analysis , 2011 .

[81]  David J. Weiss,et al.  SMARTS and SMARTER: Improved Simple Methods for Multiattribute Utility Measurement , 2008 .

[82]  J. Wyatt Decision support systems. , 2000, Journal of the Royal Society of Medicine.

[83]  Veda C. Storey,et al.  Business Intelligence and Analytics: From Big Data to Big Impact , 2012, MIS Q..

[84]  Wayne W. Eckerson Performance Dashboards: Measuring, Monitoring, and Managing Your Business , 2005 .

[85]  R. L. Keeney,et al.  Decisions with Multiple Objectives: Preferences and Value Trade-Offs , 1977, IEEE Transactions on Systems, Man, and Cybernetics.

[86]  Paolo Giorgini,et al.  GRAnD: A goal-oriented approach to requirement analysis in data warehouses , 2008, Decis. Support Syst..

[87]  B. Gilad,et al.  A systems approach to business intelligence , 1985 .

[88]  Wenhong Luo,et al.  The Analytics Movement: Implications for Operations Research , 2010, Interfaces.

[89]  Charles Anderson,et al.  The end of theory: The data deluge makes the scientific method obsolete , 2008 .

[90]  Eric Gossett,et al.  Big Data: A Revolution That Will Transform How We Live, Work, and Think , 2015 .

[91]  Xiaonan Li,et al.  Operations research and data mining , 2008, Eur. J. Oper. Res..

[92]  Alberto Abelló,et al.  A framework for multidimensional design of data warehouses from ontologies , 2010, Data Knowl. Eng..

[93]  Albert L. Lederer,et al.  Information systems software cost estimating: a current assessment , 1993, J. Inf. Technol..

[94]  Dov Dori,et al.  From conceptual models to schemata: An object-process-based data warehouse construction method , 2008, Inf. Syst..

[95]  Peter Checkland,et al.  A role for soft systems methodology in information systems development , 1995 .

[96]  Hsinchun Chen,et al.  Business Intelligence and Analytics: Research Directions , 2013, TMIS.

[97]  Avita Katal,et al.  Big data: Issues, challenges, tools and Good practices , 2013, 2013 Sixth International Conference on Contemporary Computing (IC3).

[98]  Tarun K. Sen,et al.  A Meta-Modeling Approach to Designing e-Warehousing Systems , 2005, J. Organ. Comput. Electron. Commer..

[99]  Xavier Franch,et al.  Adding semantic modules to improve goal-oriented analysis of data warehouses using I-star , 2014, J. Syst. Softw..

[100]  Graeme G. Shanks,et al.  Understanding corporate data models , 1999, Inf. Manag..

[101]  Gerald Feigin Supply Chain Planning and Analytics: The Right Product in the Right Place at the Right Time , 2011 .

[102]  Paul Farris,et al.  Cutting Edge Marketing Analytics: Real World Cases and Data Sets for Hands On Learning , 2014 .

[103]  Raimo P. Hämäläinen,et al.  On the convergence of multiattribute weighting methods , 2001, Eur. J. Oper. Res..

[104]  Richard J. Ormerod Putting soft OR methods to work: the case of IS strategy development for the UK Parliament , 2005, J. Oper. Res. Soc..

[105]  Stephen J. Andriole,et al.  Handbook of Decision Support Systems , 1989 .

[106]  Shamsul Chowdhury,et al.  Best practices in data warehousing to support business initiatives and needs , 2004, 37th Annual Hawaii International Conference on System Sciences, 2004. Proceedings of the.

[107]  Detlof von Winterfeldt,et al.  Advances in decision analysis : from foundations to applications , 2007 .

[108]  C. C. Waid,et al.  An Experimental Comparison of Different Approaches to Determining Weights in Additive Utility Models , 1982 .

[109]  Leonard L Fortuin,et al.  Performance Indicators — Why, Where and How? , 1988 .

[110]  R. Briggs,et al.  Association for Information Systems , 2009 .

[111]  Paul Beynon-Davies Strategic Data Planning , 2004 .

[112]  Juan Trujillo,et al.  A Trace Metamodel Proposal Based on the Model Driven Architecture Framework for the Traceability of User Requirements in Data Warehouses , 2011, CAiSE.

[113]  Jeffrey M. Keisler,et al.  Portfolio decision analysis : improved methods for resource allocation , 2011 .

[114]  Anna Sidorova,et al.  Factors influencing business intelligence (BI) data collection strategies: An empirical investigation , 2012, Decis. Support Syst..

[115]  Carlos A. Bana e Costa Les problématiques de l'aide à la décision : vers l'enrichissement de la trilogie choix-tri-rangement , 1996 .

[116]  Celina M. Olszak,et al.  Critical Success Factors for Implementing Business Intelligence Systems in Small and Medium Enterprises on the Example of Upper Silesia , Poland , 2013 .

[117]  Jayanthi Ranjan,et al.  Real time business intelligence in supply chain analytics , 2008, Inf. Manag. Comput. Secur..

[118]  Jörg H. Mayer,et al.  Six principles for redesigning executive information systems—findings of a survey and evaluation of a prototype , 2011, TMIS.

[119]  Michael J. Kavanagh,et al.  Human Resource Information Systems: Basics, Applications, and Future Directions , 2008 .

[120]  Sujin Kim,et al.  Information requirements of cancer center researchers focusing on human biological samples and associated data , 2007, Inf. Process. Manag..

[121]  Ralph L. Keeney,et al.  Value-Focused Thinking: A Path to Creative Decisionmaking , 1992 .

[122]  H. Marmanis,et al.  Spend Analysis: The Window into Strategic Sourcing , 2008 .

[123]  David Loshin,et al.  Business Intelligence: The Savvy Manager's Guide , 2003 .

[124]  Anjana Gosain,et al.  An approach to engineering the requirements of data warehouses , 2008, Requirements Engineering.

[125]  Rocco J. Perla,et al.  Ten Common Misunderstandings, Misconceptions, Persistent Myths and Urban Legends about Likert Scales and Likert Response Formats and their Antidotes , 2007 .

[126]  Simon French,et al.  Decision Behaviour, Analysis and Support , 2009 .

[127]  Mike. Grigsby Marketing Analytics: A Practical Guide to Real Marketing Science , 2015 .

[128]  T. Davenport,et al.  Data to Knowledge to Results: Building an Analytic Capability , 2001 .

[129]  J. Bratton,et al.  Human Resource Management: Theory and Practice , 1994 .

[130]  Mohan Thite,et al.  Human Resource Information Systems: Basics, Applications & Directions , 2009 .

[131]  Ralph L. Keeney,et al.  Common Mistakes in Making Value Trade-Offs , 2002, Oper. Res..

[132]  August-Wilhelm Scheer,et al.  Business Process Excellence: Aris in Practice , 2002 .

[133]  Vivek Choudhury,et al.  Information Specificity and Environmental Scanning: An Economic Perspective , 1997, MIS Q..

[134]  Alberto Abelló,et al.  Automatic validation of requirements to support multidimensional design , 2010, Data Knowl. Eng..