Gaining insights fron 16 years of construction data, using python, SQL, and Tableau.
Links to Tableau vizzes:
Construction Rentals - all products
Construction Rentals - aerator analysis
This dataset from Kaggle contains rental data from various contruction rental vendors in Denmark between 2004 and 2020.
Tech used: Python, SQL, Tableau
I used python for data exploration and cleaning, looking at safety stock, and focusing on inventory stress for one machine type: aerators. Then I used SQL to look at machine popularity and perform additional analysis on aerator rentals.
Using Tableau, I first created this dashboard, which visualizes orders per year, average rental duration per product class, and order volume by month.
Then, I decided to go deeper on one product class: aerators. this dashboard visualizes inventory stress and rental duration.