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

Abstract: 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)
Date: 2017
References: Add references at CitEc
Citations:

Downloads: (external link)
http://www.su-varna.org/izdanij/2017/ikonomika-017-2/217-224.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

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 ().