Enterprise Master Data Management & Business Operations System

--> Overview

This project is an Excel-based Business Operations and Master Data Management System developed to manage employee records, attendance, leave management, recruitment, vendor data, product data, and business reporting.

It demonstrates practical Business Analyst concepts including data management, reporting, dashboard creation, and Excel automation.

---

--> Features

• Employee Master
• Attendance Management
• Leave Management
• Recruitment Tracker
• Vendor Master
• Product Master
• KPI Dashboard
• Business Reporting

---

--> Excel Features Used

• VLOOKUP
• IF
• IFERROR
• COUNTIF
• Data Validation
• Conditional Formatting
• Pivot Tables
• Pivot Charts

---

--> Dashboard

The dashboard displays:

• Total Employees
• Active Employees
• Departments
• Vendors
• Products
• Recruitment Status
• Leave Status

---

--> Technologies

• Microsoft Excel

---

Developed By Priya R N