Enabling self-service BI: A methodology and a case study for a model management warehouse

David Schuff, Karen Corral, Robert St Louis, Greg Schymik

Research output: Contribution to journalArticle

3 Citations (Scopus)

Abstract

The promise of Self-Service Business Intelligence (BI) is its ability to give business users access to selection, analysis, and reporting tools without requiring intervention from IT. This is essential if BI is to maximize its contribution by radically transforming how people make decisions. However, while some progress has been made through tools such as SAS Enterprise Miner, IBM SPSS Modeler, and RapidMiner, analytical modeling remains firmly in the domain of IT departments and data scientists. The development of tools that mitigate the need for modeling expertise remains the “missing link” in self-service BI, but prior attempts at developing modeling languages for non-technical audiences have not been widely implemented. By introducing a structured methodology for model formulation specifically designed for practitioners, this paper fills the unmet need to bring model-building to a mainstream business audience. The paper also shows how to build a dimensional Model Management Warehouse that supports the proposed methodology, and demonstrates the viability of this approach by applying it to a problem faced by the Division of Fiscal and Actuarial Services of the US Department of Labor. The paper concludes by outlining several areas for future research.

Original languageEnglish (US)
Pages (from-to)1-14
Number of pages14
JournalInformation Systems Frontiers
DOIs
StateAccepted/In press - Nov 22 2016

Fingerprint

Business Intelligence
Competitive intelligence
Model Management
Warehouses
Methodology
Industry
Analytical Modeling
Miners
Modeling Language
Expertise
Viability
Division
Maximise
Personnel
Formulation
Modeling
Demonstrate
Business
Model

Keywords

  • Analytics
  • Business intelligence
  • Model management
  • Modeling
  • Self-service

ASJC Scopus subject areas

  • Theoretical Computer Science
  • Software
  • Information Systems
  • Computer Networks and Communications

Cite this

Enabling self-service BI : A methodology and a case study for a model management warehouse. / Schuff, David; Corral, Karen; St Louis, Robert; Schymik, Greg.

In: Information Systems Frontiers, 22.11.2016, p. 1-14.

Research output: Contribution to journalArticle

@article{92a0bc1b8b484e2095ed71cf33fadf06,
title = "Enabling self-service BI: A methodology and a case study for a model management warehouse",
abstract = "The promise of Self-Service Business Intelligence (BI) is its ability to give business users access to selection, analysis, and reporting tools without requiring intervention from IT. This is essential if BI is to maximize its contribution by radically transforming how people make decisions. However, while some progress has been made through tools such as SAS Enterprise Miner, IBM SPSS Modeler, and RapidMiner, analytical modeling remains firmly in the domain of IT departments and data scientists. The development of tools that mitigate the need for modeling expertise remains the “missing link” in self-service BI, but prior attempts at developing modeling languages for non-technical audiences have not been widely implemented. By introducing a structured methodology for model formulation specifically designed for practitioners, this paper fills the unmet need to bring model-building to a mainstream business audience. The paper also shows how to build a dimensional Model Management Warehouse that supports the proposed methodology, and demonstrates the viability of this approach by applying it to a problem faced by the Division of Fiscal and Actuarial Services of the US Department of Labor. The paper concludes by outlining several areas for future research.",
keywords = "Analytics, Business intelligence, Model management, Modeling, Self-service",
author = "David Schuff and Karen Corral and {St Louis}, Robert and Greg Schymik",
year = "2016",
month = "11",
day = "22",
doi = "10.1007/s10796-016-9722-2",
language = "English (US)",
pages = "1--14",
journal = "Information Systems Frontiers",
issn = "1387-3326",
publisher = "Springer Netherlands",

}

TY - JOUR

T1 - Enabling self-service BI

T2 - A methodology and a case study for a model management warehouse

AU - Schuff, David

AU - Corral, Karen

AU - St Louis, Robert

AU - Schymik, Greg

PY - 2016/11/22

Y1 - 2016/11/22

N2 - The promise of Self-Service Business Intelligence (BI) is its ability to give business users access to selection, analysis, and reporting tools without requiring intervention from IT. This is essential if BI is to maximize its contribution by radically transforming how people make decisions. However, while some progress has been made through tools such as SAS Enterprise Miner, IBM SPSS Modeler, and RapidMiner, analytical modeling remains firmly in the domain of IT departments and data scientists. The development of tools that mitigate the need for modeling expertise remains the “missing link” in self-service BI, but prior attempts at developing modeling languages for non-technical audiences have not been widely implemented. By introducing a structured methodology for model formulation specifically designed for practitioners, this paper fills the unmet need to bring model-building to a mainstream business audience. The paper also shows how to build a dimensional Model Management Warehouse that supports the proposed methodology, and demonstrates the viability of this approach by applying it to a problem faced by the Division of Fiscal and Actuarial Services of the US Department of Labor. The paper concludes by outlining several areas for future research.

AB - The promise of Self-Service Business Intelligence (BI) is its ability to give business users access to selection, analysis, and reporting tools without requiring intervention from IT. This is essential if BI is to maximize its contribution by radically transforming how people make decisions. However, while some progress has been made through tools such as SAS Enterprise Miner, IBM SPSS Modeler, and RapidMiner, analytical modeling remains firmly in the domain of IT departments and data scientists. The development of tools that mitigate the need for modeling expertise remains the “missing link” in self-service BI, but prior attempts at developing modeling languages for non-technical audiences have not been widely implemented. By introducing a structured methodology for model formulation specifically designed for practitioners, this paper fills the unmet need to bring model-building to a mainstream business audience. The paper also shows how to build a dimensional Model Management Warehouse that supports the proposed methodology, and demonstrates the viability of this approach by applying it to a problem faced by the Division of Fiscal and Actuarial Services of the US Department of Labor. The paper concludes by outlining several areas for future research.

KW - Analytics

KW - Business intelligence

KW - Model management

KW - Modeling

KW - Self-service

UR - http://www.scopus.com/inward/record.url?scp=84996561877&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84996561877&partnerID=8YFLogxK

U2 - 10.1007/s10796-016-9722-2

DO - 10.1007/s10796-016-9722-2

M3 - Article

AN - SCOPUS:84996561877

SP - 1

EP - 14

JO - Information Systems Frontiers

JF - Information Systems Frontiers

SN - 1387-3326

ER -