Design and Development of an Interactive MIS Dashboard for Cooperative Bank Branch Operations Using Power BI

  • Unique Paper ID: 194923
  • Volume: 12
  • Issue: 10
  • PageNo: 6035-6041
  • Abstract:
  • The banking sector generates large volumes of operational and financial data through daily activities such as deposits, loans, and customer transactions. Analyzing this data effectively is essential for improving decision-making and monitoring the financial performance of bank branches. This study presents the design and development of an interactive Management Information System (MIS) dashboard for cooperative bank branch operations. The system transforms raw banking data into meaningful insights by integrating data processing, analytical calculations, and visual reporting. The dashboard was developed using Microsoft Power BI, where banking datasets related to deposits and loans were cleaned and structured using Power Query, and key financial indicators were calculated using DAX measures. The developed dashboard provides visual representations of important banking metrics such as deposit distribution, CASA performance, loan outstanding amounts, and loan collection trends. Interactive charts, KPI indicators, and filtering options enable users to analyze financial performance quickly and efficiently. The proposed system improves the efficiency of financial analysis by presenting complex banking data in a clear visual format, thereby supporting better monitoring and decision-making for cooperative bank management.

Copyright & License

Copyright © 2026 Authors retain the copyright of this article. This article is an open access article distributed under the Creative Commons Attribution License which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

BibTeX

@article{194923,
        author = {A.Madhumitha and Dr.K.Ponmozhi},
        title = {Design and Development of an Interactive MIS Dashboard for Cooperative Bank Branch Operations Using Power BI},
        journal = {International Journal of Innovative Research in Technology},
        year = {2026},
        volume = {12},
        number = {10},
        pages = {6035-6041},
        issn = {2349-6002},
        url = {https://ijirt.org/article?manuscript=194923},
        abstract = {The banking sector generates large volumes of operational and financial data through daily activities such as deposits, loans, and customer transactions. Analyzing this data effectively is essential for improving decision-making and monitoring the financial performance of bank branches. This study presents the design and development of an interactive Management Information System (MIS) dashboard for cooperative bank branch operations. The system transforms raw banking data into meaningful insights by integrating data processing, analytical calculations, and visual reporting. The dashboard was developed using Microsoft Power BI, where banking datasets related to deposits and loans were cleaned and structured using Power Query, and key financial indicators were calculated using DAX measures.
The developed dashboard provides visual representations of important banking metrics such as deposit distribution, CASA performance, loan outstanding amounts, and loan collection trends. Interactive charts, KPI indicators, and filtering options enable users to analyze financial performance quickly and efficiently. The proposed system improves the efficiency of financial analysis by presenting complex banking data in a clear visual format, thereby supporting better monitoring and decision-making for cooperative bank management.},
        keywords = {Management Information System, Power BI, Cooperative Bank, Key Performance Indicator(KPI).},
        month = {March},
        }

Cite This Article

A.Madhumitha, , & Dr.K.Ponmozhi, (2026). Design and Development of an Interactive MIS Dashboard for Cooperative Bank Branch Operations Using Power BI. International Journal of Innovative Research in Technology (IJIRT), 12(10), 6035–6041.

Related Articles