A hybrid approach to building a multi-dimensional business intelligence system for electricity grid operators. (August 2016)

• Record Type: Journal Article
• Authors: Lukić, Jelena; Radenković, Miloš; Despotović-Zrakić, Marijana; Labus, Aleksandra; Bogdanović, Zorica
• Is Part Of: Utilities policy. Volume 41(2016)
• Page Start: 95
• Page End: 106
• Publication Date: 2016-08
• Subjects: Business intelligence -- Data-warehouse -- Data-warehouse design -- Smart grids; Public utilities -- United States -- Periodicals; Public utilities -- Government policy -- United States -- Periodicals; 363.6
• DOI: 10.1016/j.jup.2016.06.010
• Languages: English
• ISSNs: 0957-1787

Abstract

Abstract: This paper proposes a new methodology for building multi-dimensional data-warehousing and business intelligence systems for utility companies. The proposed approach can be used by any utility company that wishes to take advantage of the principles and recommendations gained through a critical analysis of the Kimball and ASAP methodologies. The results show that this new approach can be incorporated as a cornerstone for business intelligence systems operating in a data-rich environment. It can be successfully designed and used for various reporting purposes of various business segments of an organization. The approach was tested by applying it to electricity market analysis of the Serbian energy transmission system and market operator "Elektromreža Srbije" in the context of smart-grid technologies. Highlights: Data warehouse and business intelligence system for smart grid company is modeled. Critical analysis of Kimball's and ASAP methodologies was carried out. A hybrid approach to building DW/BI system is proposed and evaluated. Electricity market analysis of the PE Elektromreža Srbije was conducted. The designed DW/BI system proved to be effective.