Uloga alata Power Query u poslovnoj inteligenciji

graduate thesis

• Title (english): Role of the Power Query Tool in Business Intelligence
• Author: Matija Ribić
• Mentor: Jasmina Pivar (mentor)
• Committee member: Katarina Ćurko (član povjerenstva)
• Committee member: Nikola Vlahović (član povjerenstva)
• Granter: University of Zagreb; Faculty of Economics and Business; (Department of Informatics); Zagreb
• Defense date and country: 2024-07-02, Croatia
• Scientific / art field, discipline and subdiscipline: SOCIAL SCIENCES; Economics

Abstract

Svakim danom se stvara sve više podataka koji postaju važan izvor informacija. Alati poslovne inteligencije omogućuju bržu i lakšu obradu tih podataka kako bi se mogle donijeti odluke na temelju informacija proizašlih iz podataka. Power Query je alat za ekstrakciju, transformaciju i učitavanje podataka (engl. Extract, Transform, Load - ETL) koji omogućuje povezivanje, transformaciju i učitavanje velike količine podataka. Korištenjem alata Power Query ubrzava se i olakšava sami proces. U radu se predstavlja poslovna inteligencija i proces upravljanja podacima. Na primjeru se prikazuje rad u alatu Power Query te ga se uspoređuje s alatom Tableau Prep.

Abstract (english)

Every day, more and more data is created, which becomes an important information resource. Business intelligence tools enable quick and easy processing of this data so that decisions can be made based on the information derived from the data. The Power Query tool is an ETL (Extract, Transform, Load) tool that allows you to connect, transform and load large amounts of data. Using the Power Query tool speeds up and makes the process easier. The paper presents business intelligence and data management process. The example shows the work in Power Query and compares it with Tableau Prep.

• Keywords: Power Query; Tableau Prep; Microsoft Excel; Microsoft Power BI; poslovna inteligencija; proces upravljanja podacima
• Keywords (english): Power Query; Tableau Prep; Microsoft Excel; Microsoft Power BI; business intelligence; data management process
• Language: croatian
• URN:NBN: urn:nbn:hr:148:752216
• Study programme: Title: /; Study programme type: professional; Study level: graduate; Academic / professional title: magistar ekonomije/magistra ekonomije (magistar ekonomije/magistra ekonomije)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Access restricted to students and staff of home institution
• Created on: 2024-07-02 12:27:47