Client Name

Brookes Pharma

Faculty Advisor

Dr. Mohsin Ali Patel

SBS Thought Leadership Areas

Entrepreneurship and Innovation

SBS Thought Leadership Area Justification

This project aligns with the Entrepreneurship and Innovation thought leadership area by applying technology to solve a practical business problem faced by Brookes Pharma private company. Instead of depending upon traditional manual reporting processes, the project infact introduces an automated MIS that improves the way information is collected, monitored, and reported. The developments of dashboards, automated reporting, and exception management features reflects an innovative approach to improving organizations efficiency and decision making ability, which is consistent with IBA-SBS's focus on fostering innovation and creating impactful solutions to real world challenges.

Aligned SDGs

GOAL 9: Industry, Innovation and Infrastructure

Aligned SDGs Justification

The project is mainly focused on SDG 9: Industry, Innovation, and Infrastructure by creating a Financial Analytics Management Information System for digitalization and automation of management reporting at Brookes Pharma, as well as its enhancement through the implementation of dashboards, automated reporting, and exception management. This helps create more opportunities for innovation in the Pharma industry.

NDA

No

Abstract

This Experiential Learning Project (ELP) by IBA Karachi and Brookes Pharma was designed to address a critical gap in the company's financial operations, where reporting was managed through manual, fragmented, and Excel based processes across departments. The project suggested the creation of a centralized Financial Analytics Platform as a Management Information System (MIS) which will consolidate financial data, increase the management visibility and enable data driven decision making.

The project was divided into six phases. The first phase was a requirements and data review to identify missing and available data, and establish the analytical scope of the MIS. The second phase was devoted to the development of ERD where a star schema data model was designed applying Kimball's dimensional modelling methodology, including four dimension tables and six fact tables related to sales, expenses, payables, accounts receivable, inventory and production. In Phase 3, an interactive nine-page Power BI dashboard was created, which included sales performance, product analysis, export and receivables, revenue and cost monitoring, payables analytics, inventory management, and production efficiency. Phase 4 built a Python rule engine to compare the KPI values to the thresholds defined by the user and categorize exceptions as Critical Alerts, Alerts and Normal items, for daily, weekly and monthly reporting cycles. Phase 5 automated the reporting task using the rule engine and Outlook, to generate structured management emails with screenshots of dashboards and exception driven analysis. The system was validated in Phase 6, covering aspects of data accuracy, rule logic, and workflow.

Document Type

Restricted Access

Document Name for Citation

Experiential Learning Project

Download

Available for download on Friday, June 08, 2029

Share

COinS