Abstract

The classic conceptual modeling around business processes followed by the ‘bus matrix’ methodology of designing the data cubes of data warehouses (Kimball &amp; Ross 2013). For a serious system, such a quantity of management questions and dimensions, the bus matrix results a difficult-to-understand conceptual data model. The subject of automation and conceptual design – to which many individual methods already have been developed – are relevant topics in today’s literature also. In the 2010s data warehouse projects were realized in Hungarian higher education to inform the decision makers of the universities about their own institutions. As we participated in this project in 2009–2010, we faced that our bus matrix at the end contained about 80–120 indicators with nearly 200 dimensions (dimensional attributes), therefore we worked on the early stenography to formalize the management question. We provide a kind of ‘business intelligence problem solving thinking’ and a kind of descriptive language that can serve it and present a method which has two novelties compared to formers: <ol><li>It is based on the management questions and its visualization.</li><li>As a kind of stenography, it is always based on the terminology corresponding to the current problem, so it forms an intermediate language for the data model.</li></ol> We introduce our method through an example in a popular research area which is activity tracking.

Highlights

  • From the 2000’s we had to study a new concept in management sciences

  • In our study we presented a method and concrete designing tool that can decrease a serious deficiency in data warehouse conceptual design phase, when the customer and the vendor should think together to draw up the conceptual plan of a management information system

  • The problem we presented was simple and there were minimal quantity of management questions, but this hybrid conceptual modeling works in the same way during the conceptual design of a more complex management information system, the visual version of the design process of our example (Takács, 2019) results a very complex graph

Read more

Summary

Introduction

From the 2000’s we had to study a new concept in management sciences. Krauth (2008) summarized the actual information about Business Intelligence and forecasted the expected development and changes of BI for the ten years. After ten years we saw that the demand was raised in the leaders of small and medium enterprises for the dissolution of business intelligence, there are several so-called self-service business intelligence solutions we should use to satisfy this demand. In the 2000s business environment – mainly in small and medium enterprises – we saw that neither the economists nor the IT staff of these small firms could work with this BI-solutions (softwares). We participated in a data warehouse projects where we realized that our ‘corporate bus matrix’ contained about 80–120 indicators with nearly 200 dimensions (dimensional attributes), we started to work on the early stenography to formalize the management question (Takács & Bubnó 2012)

Related Works
Methodology of formalization of conceptual design
I u u
D dk I D dk ID a
Requirement analysis
Minimum granularity for each indicator
Ideal schemata for OLAP system
IK min
Source analysis
Integration
Indicators to be calculated to produce the fact tables
Necessary integration dimensions T
D MK D DK
D S D DS D DS D steps P gender
The Multidimensional modeling phase
Summary
Full Text
Published version (Free)

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call