Developing Business Intelligence System in a Building and Construction Company
Yanka Aleksandrova ()
Izvestia Journal of the Union of Scientists - Varna. Economic Sciences Series, 2017, issue 2, 217-224
The paper represents the implementation of Self Service Business Intelligence System (SSBIS) in a concrete production company. A brief comparison of possible BI and analytics platforms was made and the chosen platform was Power BI Desktop. A data model was built using snowflake schema design pattern. In order to decide on implementation approach was performed a comparison between two main alternatives – with or without using OLAP cube. As a result, and according to predefined business criteria like total costs and short implementation period was decided to use direct query against the operational relational database. Using functional capabilities of Power BI Desktop were demonstrated several important measures and visualizations like cumulative sums, Pareto rule coefficient, customer profile, RFM score, etc. The process of building the SSBIS showed that a main problem was the lack of enough knowledge in business users of modern applicable analytics models and measures.
Keywords: Self Service Business Intelligence Platforms; Power BI; data analytics; BI; SSBI (search for similar items in EconPapers)
JEL-codes: A00 (search for similar items in EconPapers)
References: Add references at CitEc
Citations: Track citations by RSS feed
Downloads: (external link)
This item may be available elsewhere in EconPapers: Search for items with the same title.
Export reference: BibTeX
RIS (EndNote, ProCite, RefMan)
Persistent link: https://EconPapers.repec.org/RePEc:vra:journl:y:2017:i:2:p:217-224
Access Statistics for this article
More articles in Izvestia Journal of the Union of Scientists - Varna. Economic Sciences Series from Union of Scientists - Varna, Economic Sciences Section Contact information at EDIRC.
Bibliographic data for series maintained by Pavel Petrov ().