As a Data Analyst, I was entrusted with the critical task of designing a sophisticated dashboard
that would display the number of overdue contracts and the days overdue for each department. The
primary objective of this project was to enable the organization to monitor contract timelines
effectively, identify areas of concern, and take proactive measures to address any delays.
To tackle this project, I utilized my expertise in SQL to retrieve and manage the contract data
efficiently. The first step was to calculate the days of overdue for each department by
comparing the contract's due date with the current date.
After calculating the days overdue, I further categorized the contracts into three distinct
categories based on their lateness. This categorization allowed stakeholders to quickly identify
and prioritize contracts that required immediate attention.
The 'E Contracts' project presented unique challenges, especially in ensuring the accuracy and
reliability of the data. The precise calculation of the days overdue demanded careful
consideration of business rules and contractual conditions. Moreover, handling a significant
volume of contract data required effective data wrangling techniques to maintain data integrity
and completeness.
