Pembangunan Dashboard Untuk Visualisasi Analisa Keuangan
Kata Kunci:
dashboard, data warehouse, information visualization, Financial Analysis, SQL Server, ETLAbstrak
PT HFI is a company engaged in the field of heavy equipment financing. Over time the growing company and more diverse data owned. This makes it difficult for the company to analyse the data. Related to this matter, the research conducted aims to design and build a dashboard at PT HFI. Methods of data collection conducted through the interview process, literature study, and observation. The purpose of this paper is to build data warehouse to simplify the process of data analysis, moving operational data from excel file into the SQL Server 2016 operating database, making the dashboard using the application Power BI. The results of this study are a data warehouse that can facilitate the analysis of data owned by the company and dashboard that can present information into the visual form. Dashboard can support the creation of information into the form of visual custom so that the information displayed in accordance with the needs. Benefits obtained are helpful in making decisions, can be used as a tool for making financial reports, and can facilitate users performs financial data analysis stored in the database in visual form.Unduhan
Unduhan
Diterbitkan
Cara Mengutip
Terbitan
Bagian
Lisensi
The copyright to this article is transferred to Universitas Mercu Buana (UMB) if and when the article is accepted for publication. The undersigned hereby transfers any and all rights in and to the paper including without limitation all copyrights to UMB. The undersigned hereby represents and warrants that the paper is original and that he/she is the author of the paper, except for material that is clearly identified as to its original source, with permission notices from the copyright owners where required. The undersigned represents that he/she has the power and authority to make and execute this assignment.
We declare that this paper has not been published in the same form elsewhere.
Furthermore, I/We hereby transfer the unlimited rights of publication of the above-mentioned paper as a whole to UMB. The copyright transfer covers the right to reproduce and distribute the article, including reprints, translations, photographic reproductions, microform, electronic form (offline, online) or any other reproductions of similar nature.
The corresponding author signs for and accepts responsibility for releasing this material on behalf of any and all co-authors. This agreement is to be signed by at least one of the authors who have obtained the assent of the co-author(s) where applicable. After submission of this agreement signed by the corresponding author, changes of authorship or in the order of the authors listed will not be accepted.
Retained Rights/Terms and Conditions
Although authors are permitted to re-use all or portions of the Work in other works, this does not include granting third-party requests for reprinting, republishing, or other types of re-use.
Our Articles are licensed under CC BY-NC
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
