Skip to main content

Semantic Cockpit: An Ontology-Driven, Interactive Business Intelligence Tool for Comparative Data Analysis

  • Conference paper
Advances in Conceptual Modeling. Recent Developments and New Directions (ER 2011)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 6999))

Included in the following conference series:

Abstract

Business analysts frequently use Cockpits or Dashboards as front ends to data warehouses for inspecting and comparing multi-dimensional data at various levels of detail. These tools, however, perform badly in supporting a business analyst in his or her business intelligence task of understanding and evaluating a business within its environmental context through comparative data analysis. With important business knowledge either unrepresented or represented in a form not processable by automatic reasoning, the analyst is limited in the analyses that can be formulated and she or he heavily suffers from information overload with the need to re-judge similar situations again and again, and to re-discriminate between already explained and novel relationships between data. In an ongoing research project we try to overcome these limitations by applying and extending semantic technologies, such as ontologies and business rules, for comparative data analysis. The resulting Semantic Cockpit assists and guides the business analyst due to reasoning about various kinds of knowledge, explicitly represented by machine-processable ontologies, such as organisation-internal knowledge, organisation external domain knowledge, the semantics of measures and scores, knowledge about insights gained from previous analysis, and knowledge about how to act upon unusually low or high comparison scores. This paper outlines the architecture of the Semantic Cockpit and introduces its core ideas by a sample use case.

SemCockpit is a collaborative research project funded by the Austrian Ministry of Transport, Innovation, and Technology in program ‘FIT-IT Semantic Systems and Services’. The project started in March 2011 and will end in August 2013.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Baader, F., Sattler, U.: Description logics with aggregates and concrete domains. Inf. Syst. 28(8), 979–1004 (2003)

    Article  MATH  Google Scholar 

  2. Calvanese, D., Kharlamov, E., Nutt, W., Thorne, C.: Aggregate queries over ontologies. In: ONISW 2008: Proceeding of the 2nd International Workshop on Ontologies and Information Systems for the Semantic Web, pp. 97–104. ACM, New York (2008)

    Google Scholar 

  3. Golfarelli, M., Maio, D., Rizzi, S.: The dimensional fact model: A conceptual model for data warehouses. Int. J. Cooperative Inf. Syst. 7(2-3), 215–247 (1998)

    Article  Google Scholar 

  4. Khouri, S., Bellatreche, L.: A methodology and tool for conceptual designing a data warehouse from ontology-based sources. In: Song II, Y., Ordonez, C. (eds.) DOLAP, pp. 19–24. ACM, New York (2010)

    Google Scholar 

  5. Nebot, V., Llavori, R.B., Pérez-Martínez, J.M., Aramburu, M.J., Pedersen, T.B.: Multidimensional integrated ontologies: A framework for designing semantic data warehouses. J. Data Semantics 13, 1–36 (2009)

    Article  Google Scholar 

  6. Niemi, T., Niinimäki, M.: Ontologies and summarizability in olap. In: SAC, pp. 1349–1353 (2010)

    Google Scholar 

  7. Pardillo, J., Mazón, J.-N., Trujillo, J.: Extending ocl for olap querying on conceptual multidimensional models of data warehouses. Inf. Sci. 180(5), 584–601 (2010)

    Article  Google Scholar 

  8. Romero, O., Abelló, A.: A framework for multidimensional design of data warehouses from ontologies. Data Knowl. Eng. 69(11), 1138–1157 (2010)

    Article  Google Scholar 

  9. Sell, D., da Silva, D.C., Beppler, F.D., Napoli, M., Ghisi, F.B., dos Santos Pacheco, R.C., Todesco, J.L.: Sbi: a semantic framework to support business intelligence. In: Duke, A., Hepp, M., Bontcheva, K., Vilain, M.B. (eds.) OBI. ACM International Conference Proceeding Series, vol. 308, p. 11. ACM, New York (2008)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2011 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Neumayr, B., Schrefl, M., Linner, K. (2011). Semantic Cockpit: An Ontology-Driven, Interactive Business Intelligence Tool for Comparative Data Analysis. In: De Troyer, O., Bauzer Medeiros, C., Billen, R., Hallot, P., Simitsis, A., Van Mingroot, H. (eds) Advances in Conceptual Modeling. Recent Developments and New Directions. ER 2011. Lecture Notes in Computer Science, vol 6999. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-24574-9_9

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-24574-9_9

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-24573-2

  • Online ISBN: 978-3-642-24574-9

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics