Copyright © 2025 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.

@article{176268,
        author = {Niharika Singh and Possan Gopikrishnan},
        title = {COMPREHENSIVE ANALYSIS OF CORE BANKING OPERATION},
        journal = {International Journal of Innovative Research in Technology},
        year = {2025},
        volume = {11},
        number = {11},
        pages = {6026-6030},
        issn = {2349-6002},
        url = {https://ijirt.org/article?manuscript=176268},
        abstract = {In today’s data-driven financial landscape, efficient and accurate data consolidation is crucial for informed decision-making. This research focuses on the development of an automated, dynamic dashboard using Microsoft Excel—leveraging tools like Power Query and Pivot Tables—to streamline the processing of financial records, such as customer credit scores, loan statuses, and transaction histories. The proposed system eliminates the need for manual data entry by automatically merging Excel files stored in a designated folder and refreshing insights in real time. Through data transformation, visualization, and automation, the dashboard offers a cost-effective solution for small and medium-sized enterprises (SMEs) to monitor key financial metrics with minimal technical expertise. This study demonstrates how widely available tools can be effectively utilized to build intelligent, self-updating dashboards, ultimately improving operational efficiency and the reliability of financial analysis.},
        keywords = {Automated Dashboard, Power Query, Financial Data Visualization, Excel Automation, Pivot Tables, Business Intelligence, Data Integration, Self-Service BI, Real-Time Reporting, Excel Dashboarding},
        month = {April},
        }