Interactive Engineering Projects Dashboard & Database Management System

An advanced, dynamic Microsoft Excel Dashboard designed to manage and track engineering projects. The system integrates a robust database sheet with automated calculation logic and user-friendly interaction features.

Key Features Implemented:

Dynamic VLOOKUP System: Created an automated engineer hourly rate look-up table linked directly to actual costs, eliminating manual entry errors.

Interactive Slicers & Timeline: Integrated interactive filters for Engineering Domains, Status, and Timeline controls for seamless data drilling.

Custom Search Engine: Built an in-dashboard search utility utilizing IFERROR and VLOOKUP, allowing stakeholders to query specific domains and fetch real-time financial and project metrics instantaneously.

Data Optimization: Cleaned and structured project records (utilizing customized random date functions and formatting) to ensure pristine visual presentation.