Extraction and Transformation of General Ledger Data from SAP ERP to Microsoft Power Pivot
Wiharyo, Arinto Hadi (2014)
Wiharyo, Arinto Hadi
HAAGA-HELIA ammattikorkeakoulu
2014
All rights reserved
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-2014112717170
https://urn.fi/URN:NBN:fi:amk-2014112717170
Tiivistelmä
SAP ERP is an automated and integrated system that supports end-to-end business process of organization by combining functional and cross-functional business process, and integrating business modules into a logical architecture. SAP ERP has the ability to hold unstructed general ledger data from business transactions in data warehouse. Unstructured general ledger data brings no value to organizations, Microsoft Power Pivot is used to structure and transform the unstructured general data into structured data for analysis, reporting and decision making through fast, simple and efficient processes.
The study was conducted through qualitative research that was divided into theoretical and empirical researches. The theoretical research is based on the literature analysis from books, courses provided by HAAGA-HELIA UAS, internet sources, community guidelines, journals and articles, and thesis. Meanwhile the empirical research is based on the business transaction scenario, extraction, transformation and loading of general ledger data, and an addition of brief explanation of Power View and Power BI.
The dashboard created has shown the change in general ledger data as a result of the business transaction scenario, the dashboard clearly transforms the general ledger data into a structured report for analysis and decisions making. Additional findings regarding Power View and Power BI functonalities were discovered during the study. Power View has allowed the general ledger data to be presented in more stylish manners without eliminating the main idea of BI, while Power BI has the shown its ability to allow users to share, collaborate, track and communicate one Power BI workbook through the SharePoint.
The study was conducted through qualitative research that was divided into theoretical and empirical researches. The theoretical research is based on the literature analysis from books, courses provided by HAAGA-HELIA UAS, internet sources, community guidelines, journals and articles, and thesis. Meanwhile the empirical research is based on the business transaction scenario, extraction, transformation and loading of general ledger data, and an addition of brief explanation of Power View and Power BI.
The dashboard created has shown the change in general ledger data as a result of the business transaction scenario, the dashboard clearly transforms the general ledger data into a structured report for analysis and decisions making. Additional findings regarding Power View and Power BI functonalities were discovered during the study. Power View has allowed the general ledger data to be presented in more stylish manners without eliminating the main idea of BI, while Power BI has the shown its ability to allow users to share, collaborate, track and communicate one Power BI workbook through the SharePoint.