International Journal of Scientific & Technology Research

Home About Us Scope Editorial Board Blog/Latest News Contact Us
10th percentile
Powered by  Scopus
Scopus coverage:
Nov 2018 to May 2020


IJSTR >> Volume 8 - Issue 7, July 2019 Edition

International Journal of Scientific & Technology Research  
International Journal of Scientific & Technology Research

Website: http://www.ijstr.org

ISSN 2277-8616

Application Business Intelligence For Policy Decision

[Full Text]



Asfiyan, Abba Suganda Girsang



olap analysis, data warehouse, web reporting, business intelligence, real estate.



The purpose of this study was to design device flexible business intelligence software that is intended for managers to be able to analyze data to help make decisions. Components that will be displayed in OLAP Analysis and Design Reports and Dashboards. This result will be used as a reference to build Business Intelligence, data warehouse and web reporting. The data warehouse designed in this study is very helpful in processing daily transaction data generated and stored in OLTP databases (Online Transactional Processing) into data that can be analyzed as Online Analysis Processing data using the Qlik Sense tool. BI reports are designed to help in making research reports and can be tailored to the needs, so the problem of making reports can be overcome without using complicated programing codes. BI Dashboard designed in this research, certainly very helpful for leaders in analyzing data to support decision making and can also be used to study sales trends and market analysis.



[1] K. Foster, G. Smith, T. Ariyachandra, and M. N. Frolick, “Business Intelligence Competency Center: Improving Data and Decisions,” Inf. Syst. Manag., vol. 32, no. 3, pp. 229–233, 2015.
[2] C. Imhoff, N. Galemmo, and J. G. Geiger, Mastering Data Warehouse Design: Relational and Dimensional Techniques. Wiley Publishing, Inc.
[3] M. Murugesan and K. Karthikeyan, “Business Intelligence Market Trends and Growth in Enterprise Business,” Int. J. Recent Innov. Trends Comput. Commun., vol. 4, no. 3, pp. 188–192, 2016.
[4] K. Kasemsap, “The Fundamentals of Business Intelligence,” Int. J. Organ. Collect. Intell., vol. 6, no. 2, pp. 12–25, 2016.
[5] M. Aruldoss, M. Lakshmi Travis, and V. Prasanna Venkatesan, “A survey on recent research in business intelligence,” J. Enterp. Inf. Manag., vol. 27, no. 6, pp. 831–866, 2014.
[6] C. M. Olszak, “Toward Better Understanding and Use of Business Intelligence in Organizations,” Inf. Syst. Manag., vol. 33, no. 2, pp. 105–123, 2016.
[7] S. N. Kane, A. Mishra, and A. K. Dutta, “Preface: International Conference on Recent Trends in Physics (ICRTP 2016),” J. Phys. Conf. Ser., vol. 755, no. 1, 2016.
[8] C. Hazen, Benjamin;Skipper, Joseph;Ezell, Jeremy;Boone, “Big Data and Predictive Analytics for Supply Chain Sustainability: A Theory-driven Research Agenda,” Comput. Ind. Eng., vol. 101.
[9] A. S. Syed Fiaz, N. Asha, D. Sumathi, and A. S. Syed Navaz, “Visualization: Enhancing big data more adaptable and valuable,” Int. J. Appl. Eng. Res., vol. 11, no. 4, pp. 2801–2804, 2016.
[10] J. P. A. Runtuwene, I. R. H. T. Tangkawarow, C. T. M. Manoppo, and R. J. Salaki, “A Comparative Analysis of Extract, Transformation and Loading (ETL) Process,” IOP Conf. Ser. Mater. Sci. Eng., vol. 306, no. 1, 2018.
[11] J. Completo, R. S. Cruz, L. Coheur, and M. Delgado, “Design and Implementation of a Data Warehouse for Benchmarking in Clinical Rehabilitation,” Procedia Technol., vol. 5, pp. 885–894, 2012.
[12] S. Bāliņa, R. Žuka, and J. Krasts, “Opportunities for the Use of Business Data Analysis Technologies,” Econ. Bus., vol. 28, no. 1, pp. 20–25, 2016.
[13] C. Vercellis, Business intelligence: data mining and optimization for decision making. 2009.
[14] V. L. V. L. Sauter, Decision Support Systems for Business Intelligence: Second Edition. 2011.
[15] M. Benjelloun, M. El, and E. Amin, “Using Snowflake Schema and Bitmap Index for Big Data Warehouse Volume,” Int. J. Comput. Appl., vol. 180, no. 8, pp. 30–32, 2017.
[16] E. Sidi, M. El, and E. Amin, “Star Schema Advantages on Data Warehouse: Using Bitmap Index and Partitioned Fact Tables,” Int. J. Comput. Appl., vol. 134, no. 13, pp. 11–13, 2016.
[17] A. Amine, R. A. Daoud, and B. Bouikhalene, “Efficiency comparaison and evaluation between two ETL extraction tools,” Indones. J. Electr. Eng. Comput. Sci., vol. 3, no. 1, pp. 174–181, 2016.
[18] H. Vantara, “Hitachi Vantara: Pentaho Documentation,” 2017. [Online]. Available: https://help.pentaho.com/Documentation/8.0/Products. [Accessed: 02-Aug-2018].
[19] S. Klisarova-Belcheva and G. Ilieva, “Business intelligence and analytics – contemporary system model,” Trakia J. Sci., vol. 15, no. Suppl.1, pp. 298–304, 2018.
[20] V. M., A. Syed, A. Mohammad, and M. N., “Pentaho and Jaspersoft: A Comparative Study of Business Intelligence Open Source Tools Processing Big Data to Evaluate Performances,” Int. J. Adv. Comput. Sci. Appl., vol. 7, no. 10, pp. 20–29, 2016.
[21] P. Hawking and C. Sellitto, “A Fast-Moving Consumer Goods Company and Business Intelligence Strategy Development,” Int. J. Enterp. Inf. Syst., vol. 13, no. 2, pp. 22–33, 2017.