ERP and BI Integration for Municipalities

  • Priyanka Ramessur
  • Yajma Devi Kaidoo
  • Bibi Zarine CadersaibEmail author
Conference paper
Part of the Advances in Intelligent Systems and Computing book series (AISC, volume 863)


Enterprise Resource Planning (ERP) systems and Business Intelligence (BI) are currently being used in municipalities in both developed and developing countries. Based on the literature review, it was found that ERP and BI bring along opportunities and challenges, which may depend on the type of city or town. From a fact finding process, it was found that the municipalities in Mauritius do not make efficient use of existing resources and through a citizen survey, citizens have put forward for many improvements in the complaint service. Therefore, the aim of this paper is to present an ERP framework, complemented with BI and Twitter Sentiment Analysis to address complaints. A brief evaluation was carried out which showed that the framework could be a possible solution for enhancing the efficiency of municipalities.


ERP BI Municipality Twitter Stanford core NLP 



We would like to thank the municipal authority and all the people who devoted their time to participate in this work in one way or another.


  1. 1.
    Pay Research Bureau: Local Authorities. PRB Report 2016. [online], p. 1. Available at: Accessed 12 Oct 2017
  2. 2. Portal of Local Authorities, Mauritius. [online] Available at: Accessed 12 Oct 2017
  3. 3.
    Kitchenham, B.: Procedures for Performing Systematic Reviews, vol. 33, pp. 1–26. Keele, UK, Keele University (2004)Google Scholar
  4. 4.
    Adelakun, O.: The Role of Business Intelligence in Government: A Case Study of a Swedish Municipality Contact Center (2012)Google Scholar
  5. 5.
    Nycz, M., Polkowski, Z.: Business intelligence in a local government unit. In: Proceedings of Informing Science and IT Education Conference (InSITE), pp. 301–311 (2015)Google Scholar
  6. 6.
    Chandiwana, T., Pather, S.: A citizen benefit perspective of municipal enterprise resource planning systems. Electronic J. Inf. Syst. Eval. 19(2) (2016)Google Scholar
  7. 7.
    Hartley, K., Seymour, L.F.: Towards a framework for the adoption of business intelligence in public sector organisations: the case of South Africa. In: Proceedings of the South African Institute of Computer Scientists and Information Technologists Conference on Knowledge, Innovation and Leadership in a Diverse, Multidisciplinary Environment, pp. 116–122. ACM (2011)Google Scholar
  8. 8.
    Elragal, A.: ERP and big data: the inept couple. Procedia Technol. 16, 242–249 (2014)CrossRefGoogle Scholar
  9. 9.
    Babu, M.P., Sastry, S.H.: Big data and predictive analytics in ERP systems for automating decision making process. In: 2014 5th IEEE International Conference on Software Engineering and Service Science (ICSESS), pp. 259–262. IEEE (2014)Google Scholar
  10. 10.
    Orosz, I., Orosz, T.: Business process reengineering project in local governments with ERP. In: 2012 7th IEEE International Symposium on Applied Computational Intelligence and Informatics (SACI), pp. 371–376. IEEE (2012)Google Scholar
  11. 11.
    Uwizeyemungu, S.: Motivations for ERP Adoption in the Public Sector: An Analysis From “Success Stories” (2005)Google Scholar
  12. 12.
    Teixeira, R.F.D.S., Afonso, F., Oliveira, B., Portela, F., Santos, M.F.: Business intelligence to improve the quality of local government services: case-study in a local government town hall. In: 6th International Conference on Knowledge Management and Information Sharing (KMIS 2014)Google Scholar
  13. 13.
    Gupta, S., Kumar, V., Chhabra, S.: A Window view of prospects of ERP implementation in municipal corporation of Delhi. Int. J. Emerg. Technol. Adv. Eng. Available at: (ISSN 2250–2459)
  14. 14.
    Reddick, C.G., Chatfield, A.T., Ojo, A.: A social media text analytics framework for double-loop learning for citizen-centric public services: a case study of a local government Facebook use. Gov. Inf. Q. 34(1), 110–125 (2017)CrossRefGoogle Scholar
  15. 15.
    Anna, K., Nikolay, K.: Survey on big data analytics in public sector of russian federation. Procedia Comput. Sci. 55, 905–911 (2015)CrossRefGoogle Scholar
  16. 16.
    Abai, N.H.Z., Yahaya, J.H., Deraman, A.: Incorporating business intelligence and analytics into performance management for the public sector issues and challenges. In: 2015 International Conference on Electrical Engineering and Informatics (ICEEI), pp. 484–489. IEEE (2015)Google Scholar
  17. 17.
    Fildes, R., Pidd, M.: The Benefits of Analytics in the Public Sector. UK (2011)Google Scholar
  18. 18.
    Schenk, T.J., Burman, B.: Big Data and Analytics: Driving Performance and Improving Decision-Making, Chicago: s.n (2015)Google Scholar
  19. 19.
    Beal, J., Prabhakar, B.: Public Sector ERP (2010)Google Scholar
  20. 20.
    Ramburn Gopaul, H.: A systematic analysis of ERP implementation challenges and coping mechanisms: the case of a large, decentralised, public organisation in South Africa, Doctoral Dissertation, University of Cape Town (2016)Google Scholar
  21. 21. Office of the Electoral Commissioner—Election Results. [online] Available at: Accessed 28 Jan 2018

Copyright information

© Springer Nature Singapore Pte Ltd. 2019

Authors and Affiliations

  • Priyanka Ramessur
    • 1
  • Yajma Devi Kaidoo
    • 1
  • Bibi Zarine Cadersaib
    • 1
  1. 1.University of Mauritius, ReduitMokaMauritius

Personalised recommendations