Abstract
The classic conceptual modeling around business processes followed by the ‘bus matrix’ methodology of designing the data cubes of data warehouses (Kimball & 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
Summary
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)
Sign-in/Register to view highlights & summary 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 callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
