The project applied Python, utilizing Pandas for data processing, Matplotlib and Seaborn for visualization, and statistical analysis to profile Aerofit treadmill customers, aiding in market research and product recommendation strategies.
The project developed a system to log database schema changes, including timestamps and relevant details, in a dedicated table, enabling reports on modifications and maintaining an accurate historical record for efficient schema contract management.
This project automates timestamp updates in a database table using PostgreSQL triggers and stored procedures, ensuring accurate tracking of data modifications.