Naslov
Power Pivot for Excel as a tool for descriptive analytics

Autori
Beroš, Ivo ; Hlupić, Nikica ; Butković, Danijel

Vrsta, podvrsta i kategorija rada
Radovi u zbornicima skupova, cjeloviti rad (in extenso), znanstveni

Izvornik
Proceedings of the ISCCRO – International Statistical Conference in Croatia - ISCCRO’20: The 3rd International Statistical Conference in Croatia / Žmuk, Berislav ; Čeh Časni, Anita - Zagreb : Hrvatsko statističko društvo, 2020, 29-34

Skup
3rd International Statistical Conference in Croatia (ISCCRO'20)

Mjesto i datum
Zagreb, Hrvatska, 15.10.2020. - 16.10.2020

Vrsta sudjelovanja
Predavanje

Vrsta recenzije
Međunarodna recenzija

Ključne riječi
business analytics, business intelligence, Power Pivot
(business analytics, business intelligence, Power Pivot.)

Sažetak
The use of business analytics and especially business intelligence (BI) today is very important due the growth of data and information which can be used to support business decisions. The users demand various reports, but traditional enterprise systems often cannot satisfy those demands in acceptable time. That situation leads to development of selfservice business intelligence, where users collect and analyze date with minimal support of organizations BI group. To perform self-service BI, many users commonly chose Excel as a result of familiarity with program and small costs, but that approach is suitable only for relatively small amount of data. Microsoft has identified those issues and offered Power Pivot for Excel as a new technology for doing self-service BI. The purpose of this paper is to identify additional skills that Excel users have to learn for successful use of Power Pivot. In addition to this, the limits on the size of data in which Power Pivot can be used are investigated. The results show that Power Pivot can be successfully used in certain situation.

Izvorni jezik
Engleski

POVEZANOST RADA