Data Analysis
Construction Productivity App in Streamlit
Streamlit’s framework allowed me to develop and deploy an app to understand and track productivity in the construction sites of a company.
The APP
This is a real app developed in a Python-based platform for a real company, but I made a copy of the real app to show how it was made and how it can be used in real life.
The Construction Productivity app is a valuable tool for professionals in the civil construction industry. It offers a comprehensive comparison of productivity levels and follow-ups between the company’s various construction sites.
By tracking all of the company’s current construction sites, this app enables professionals to exchange information and stay up-to-date on the latest trends and best practices, ultimately leading to improved productivity.
The app includes two key features: Follow-Up and Comparison. The Follow-Up page allows users to track a construction activity over several months, providing information on average productivity levels and performance trends. The Comparison page enables users to compare productivity indexes across different construction sites, allowing them to identify the best-performing sites and learn from their successes.
I don’t want to extend this post more than it needs. So let’s dive into it.
The pages
The app consists of only 3 sections: Homepage, Follow-Up, and Comparison.
The Homepage is a brief understanding of what this app is about, so let’s talk about the other two sections.
Follow-Up
Here we can check the activities across the months.
Let’s say that I am the manager of the “Hollywood Cave” construction site and I want to check how is my ceramic floor cladding activity in the past months.
The sidebar comes already selected with years, months, city, and type:
So what’s needed is to select the Construction site (in this case Hollywood Cave), category (Internal Coatings), and finally the activity (Ceramic/Porcelain Floor Cladding) inside the page:
Then you’ll have the following pieces of information:
Last Added Records
It’ll show the information for the last month added to the database for your filter.
Metrics
It shows the metrics to understand how is the current index against the average. It shows also the average, minimum, maximum, and number of records for the filter.
Line chart for the follow-up of the productivity index
It visually shows the performance of the activity over the months.
Table of selected records
It provides the table with the selected records and gives a download link to the data.
Comparison
Here we can compare activities among the construction sites.
Let’s say that I am the manager of the “Hollywood Cave” construction site and I want to check how is my ceramic floor cladding activity compared to all of the other construction sites.
Again, as before, the sidebar comes already selected with years, months, cities, and types.
The page selections now come with all of the construction sites selected, and you’ll need only select a category and an activity.
Then you’ll have the following pieces of information:
Metrics
It shows the metrics to understand how is the current average, the number of records, minimum (with the name of the const. site), and maximum (with the name of the const. site).
Bar chart for comparison between different construction sites
It visually shows a comparison between the construction sites to see if the average productivity is consistent between them.
It also shows an average line to see who is above or below the average productivity index.
Table of selected records
Again it provides the table with the selected records and gives a download link to the data.
That’s it
Thank you for reading this piece and I hope you’ll find a good use for this app. It helped me a lot and I’ll think it’ll help you too.
Find me on LinkedIn or Instagram.
Check my other projects:
Bye.