Towards a customizable user-centered model for data analytics

Evidence-based governance and e-democracy both rely on the capability to analyze aggregated and statistical data. Recent studies report that existing analysis tools were never fully embraced by managers mainly because of their complexity for many analytical use cases. This is even more true for citizens, that do not have full control over underlying data and analysis models. In the present work, we propose an innovative user-centered approach for data analytics, that facilitates the interaction of users with statistical and aggregated measures, i.e. indicators. We provide an overview of the framework, discussing its main components and functionalities. In particular we focus on an ontology representing both atomic and compound indicators, that are provided with a calculation formula. We show how such a logic-based representation of indicators allows the implementation of powerful, automatic reasoning services, capable to provide a valuable support to users for performing analysis tasks.

[1]  Manuel Resinas,et al.  On the definition and design-time analysis of process performance indicators , 2013, Inf. Syst..

[2]  Ralph Kimball,et al.  The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling , 1996 .

[3]  Jia-Lang Seng,et al.  Data warehouse enhancement: A semantic cube model approach , 2007, Inf. Sci..

[4]  Leon Sterling,et al.  Solving Symbolic Equations with PRESS , 1982, J. Symb. Comput..

[5]  Viara Popova,et al.  Modeling organizational performance indicators , 2010, Inf. Syst..

[6]  Samson W. Tu,et al.  Supporting Collaborative Ontology Development in Protégé , 2008, SEMWEB.

[7]  Rafael Berlanga Llavori,et al.  Building data warehouses with semantic web data , 2012, Decis. Support Syst..

[8]  Vasant Honavar,et al.  Collaborative Ontology Building with Wiki@nt - A Multi-agent Based Ontology Building Environment , 2004, EON.

[9]  Michael H. Breitner,et al.  Ontology-Based Exchange and Immediate Application of Business Calculation Definitions for Online Analytical Processing , 2009, DaWaK.

[10]  Matteo Golfarelli,et al.  OLAP query reformulation in peer-to-peer data warehousing , 2012, Inf. Syst..

[11]  Claudia Diamantini,et al.  Collaborative Building of an Ontology of Key Performance Indicators , 2014, OTM Conferences.

[12]  Paola Velardi,et al.  The Usable Ontology: An Environment for Building and Assessing a Domain Ontology , 2002, SEMWEB.

[13]  James A. Hendler,et al.  TWC LOGD: A portal for linked open government data ecosystems , 2011, J. Web Semant..

[14]  Bernd Neumayr,et al.  Multi-level Conceptual Modeling and OWL , 2009, ER Workshops.

[15]  Shengping Liu,et al.  EIAW: Towards a Business-Friendly Data Warehouse Using Semantic Web Technologies , 2007, ISWC/ASWC.

[16]  Adam Pease,et al.  Agent-Mediated Knowledge Engineering Collaboration , 2003, AMKM.

[17]  Vassilios Peristeras,et al.  Linked Open Government Data [Guest editors' introduction] , 2012, IEEE Intell. Syst..

[18]  Rafael Berlanga Llavori,et al.  Building data warehouses with semantic data , 2010, EDBT '10.

[19]  Alberto Abelló,et al.  GEM: Requirement-Driven Generation of ETL and Multidimensional Conceptual Designs , 2011, DaWaK.

[20]  Andreas Harth,et al.  Transforming statistical linked data for use in OLAP systems , 2011, I-Semantics '11.

[21]  Barbara Ubaldi,et al.  Open Government Data , 2019, Government at a Glance: Latin America and the Caribbean 2020.

[22]  Christoph G. Schütz,et al.  Semantic Enrichment of OLAP Cubes: Multi-dimensional Ontologies and Their Representation in SQL and OWL , 2013, OTM Conferences.

[23]  Claudia Diamantini,et al.  Extending Drill-Down through Semantic Reasoning on Indicator Formulas , 2014, DaWaK.

[24]  Soon Ae Chun,et al.  Government 2.0: Making connections between citizens, data and government , 2010, Inf. Polity.

[25]  Ai Haojun,et al.  Application of linked open government data: state of the art and challenges , 2013 .

[26]  Torben Bach Pedersen,et al.  Using Semantic Web Technologies for Exploratory OLAP: A Survey , 2015, IEEE Transactions on Knowledge and Data Engineering.

[27]  Claudia Diamantini,et al.  Data Mart Reconciliation in Virtual Innovation Factories , 2014, CAiSE Workshops.

[28]  John Mylopoulos,et al.  Strategic business modeling: representation and reasoning , 2014, Software & Systems Modeling.