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.

@article{195109,
        author = {M.VARSHA and K.MANIRAJ},
        title = {Design and Development of an Interactive MIS Dashboard for Intimate Fashion Private Limited Using Power BI},
        journal = {International Journal of Innovative Research in Technology},
        year = {2026},
        volume = {12},
        number = {10},
        pages = {7563-7569},
        issn = {2349-6002},
        url = {https://ijirt.org/article?manuscript=195109},
        abstract = {The garment and textile industry generate significant volumes of operational data through daily workforce activities such as employee attendance, overtime hours, module-wise production, and transport operations. Analyzing this data effectively is essential for monitoring workforce performance and supporting accurate incentive calculations. This study presents the design and development of an interactive Management Information System (MIS) dashboard for Intimate Fashion Private Limited, a garment manufacturing company. The system transforms raw employee attendance, overtime, and driver transport data into meaningful insights using Microsoft Power BI. Data cleaning and transformation were performed using Power Query, while key performance metrics including attendance percentage, OT incentive amounts, final incentive calculations, and penalty analysis were derived using DAX measures. The developed dashboards provide interactive visual representations of employee incentive distribution by module, OT hours distribution, top incentive earners, attendance versus performance comparisons, driver trip completion, delivery performance, and safety incident analysis. KPI indicators and filtering options enable management to analyze workforce performance quickly and efficiently. The proposed system improves the efficiency of incentive management by presenting complex operational data in a clear visual format, thereby supporting better monitoring and decision-making for the company's management.},
        keywords = {Power BI, MIS Dashboard, Employee Incentive, OT Analysis, Attendance Management, Driver Incentive, DAX, Power Query, Garment Industry Analytics},
        month = {March},
        }