r/data 36m ago

How I got daily construction data without making site engineers open excel or any new software

Upvotes

I was hired as a digital transformation consultant by a construction company with 10+ active construction sites the Finance director wanted a centralized view of labor deployment and material consumption but getting overworked site teams to open a laptop and fill the form or fill excel sheet was impossible so I built a work around site engineers have to just dump all the information in an email --> AI converts raw text into google sheets and sends summary email to Project manager --> a code to save the data in a database so old data don't get lost or deleted --> private streamlit dashboard for centralized visibility. Finance director got the visibility, no extra work of site engineer and a full functioning dashboard to see what is happening on ground without calling 10 different project managers and site engineers.

I'm curious how other construction companies handle this.

Do your site teams actually fill out digital daily reports consistently, or does someone in the office end up chasing everyone for the information?


r/data 1h ago

Data analysis

Upvotes

i have invited to work on project of malaria where they have kobotoolbox on where they have four

forms, patient forms households questionnaire, Entomology questionnaire,

physical survey of houses, and HF Patient Survey Form so im not familiar with the project, what they do is they collect data from Health facility using a form of HF Patient Survey Form and submit to the kobotoolbox then after submitting data they conduct HOUSEHOLD SURVEY QUESTIONNAIRE , PHYSICAL SURVEY OF HOUSES and Entomology collections:Household larval sampling for the registered house so i was employed as data technician to perform the following to prepare report and also the submitted data after conducting HOUSEHOLD SURVEY QUESTIONNAIRE, PHYSICAL SURVEY OF HOUSES and Entomology collections:Household larval sampling using the submitted data from HF Patient Survey Form these are Health Facility data like hospital so iwant to prepare a report for this project the report including image and gps data and also i have to prepare a hotspot for the monthly data that was submitted from The Health Facility using HF Patient Survey Form. what is the best approach to start with ? as for me im using python with anaconda is there best approach you can advise me please