Unit Cost Dashboard

Our internal system for tracking and managing unit costs was all being done from macros-enabled excel workbooks which were slow to load and lacked full functionality. It created challenges for our teams like: - Difficulty leaving notes and tracking revision history for line items - Limited visibility accross multiple project sizes and types - Inefficient UI/UX

Developed a web application to serve as an online portal for the underlying database. Optimized queries for quick loading times, added the ability to filter by specific divisions and building sizes, and created an intutivie user interface that allowed users to leave notes and track revision history. Key components included: - Django templates and jQuery front-end - Django backend for authentication and routing - Integration with existing PostgreSQL database The system consistes of multiple unit cost dashboards, filtering capabilities for each, and a datatables UI for sorting.

This unit cost dashbaord project resulted in: - An additional 3 divisions (and counting) committing to share information and start using the tool - Reported reduced time spent finding unit costs by 70% - Accelerated decision-making processes by providing instant access to critical data The web application has become an essential tool for executive decision-making, business development, and project estimating, allowing our teams to quickly and efficiently get to the cost information they need to provide clients with accurate project estimates.