Design and Build OLAP Business Intelligence for Village Sustainable Development Planning

Conference paper
Part of the IFIP Advances in Information and Communication Technology book series (IFIPAICT, volume 504)


The Indonesian government-year period 2014–2019, endorsed the National Medium Term Development Plan (RPJMN) with the concept of building Indonesia from the rural area. One of the RPJMN focus is the development of rural and border areas brings a new paradigm for the village development. This village development paradigm change requires the support of village information system. Village Information System and Rural Areas (SIDeKa) has developed and implemented in dozens of villages in the some district as a pilot project. The transaction data and information in the village have captured accurately using SIDeKa. These data and information becoming crucial sources for development planning in the next phase. This paper describe design and build OLAP Business Intelligence for development planning at village and supra village (district) that integrates SIDeKa’s data from all villages and aligns the development planning with the vision, mission, and objectives of rural development. This paper presents model/architecture for ETL, star schema, and new measures that capture spatial and temporal dimensions. OLAP Business Intelligence will be useful for Village Sustainable Development Planning.


OLAP Business Intelligence Sustainable Development Planning Village Information System and Rural Areas (SIDeKa) 


  1. 1.
    Kementerian Perencanaan Pembangunan Nasional/Badan Perencanaan Pembangunan Nasional. Rencana OpenPembangunan Jangka Menengah Nasional (RPJMN) 2015 – 2019 (2014)Google Scholar
  2. 2.
    Dirjen Bina Pembangunan Daerah. Peraturan Menteri Dalam Negeri Nomor 54 Tahun 2010 Tentang Pelaksanaan Peraturan Pemerintah Nomor 8 Tahun 2008 Tentang Tahapan, Tatacara Penyusunan, Pengendalian, Dan Evaluasi Pelaksanaan Rencana Pembangunan Daerah (2010)Google Scholar
  3. 3.
    Ward, J., Peppard, J.: Strategic Planning for Information Systems, 3rd edn. Wiley, West Sussex (2005)Google Scholar
  4. 4.
    Ranjan, J.: Business intelligence: concepts, components, techniques and benefits. J. Theor. Appl. Inf. Technol. 9(1), 060–070 (2009)Google Scholar
  5. 5.
    Nazier, M.M., Khedr, A., Haggag, M.: Business intelligence and its role to enhance corporate performance management. Int. J. Manage. Inf. Technol. 3(3), 8–15 (2013)Google Scholar
  6. 6.
    Porter, M.E.: Competitive Advantage Creating and Sustaining Superior Performance. The Free Press, New York (1985)Google Scholar
  7. 7.
    Al-Aboud, F.N.: Strategic information systems planning: a brief review. IJCSNS Int. J. Comput. Sci. Netw. 11, 179–183 (2011)Google Scholar
  8. 8.
    Open Group, 1999–2011.
  9. 9.
    Alonso, I.A., Verdun, J.C., Caro, E.T.: The IT implicated within the enterprise architecture model: analysis of architecture models and focus IT architecture domain. In: 2010 IEEE International Conference on Service-Oriented Computing & Application (SOCA), Perth, WA (2010)Google Scholar
  10. 10.
    Farrokhi, V., Pokorádi, L.: The necessities for building a model to evaluate business intelligence projects. Int. J. Comput. Sci. Eng. Surv. (IJCSES) 3(2), 1–10 (2012)CrossRefGoogle Scholar
  11. 11.
    Inmon, W.H.: Building the Data Warehouse, 4th edn. Wiley, New York (2005)Google Scholar
  12. 12.
    Ponniah, P.: Data Warehousing Fundamentals, 2nd edn. Wiley, New York (2010)CrossRefGoogle Scholar
  13. 13.
    Latifov, M.A., Sahay, S.: Data warehouse approach to strengthen actionability of health information systems: experience from Tajikistan. Electron. J. Inf. Syst. Dev. Countries 53(4), 1–19 (2012)Google Scholar
  14. 14.
    Purkayastha, S., Braa, J.: Big data analytics for developing countries – using the cloud for operational BI in health. Electron. J. Inf. Syst. Dev. Countries 59(6), 1–17 (2013)Google Scholar
  15. 15.
    Mohamed, M., Stankosky, M., Mohamed, M.: An empirical assessment of knowledge management criticality for sustainable development. J. Knowl. Manage. 13(5), 271–286 (2009)CrossRefGoogle Scholar

Copyright information

© IFIP International Federation for Information Processing 2017

Authors and Affiliations

  1. 1.Informatics Engineering DepartmentAtma Jaya Yogyakarta UniversityYogyakartaIndonesia

Personalised recommendations