Problem & Context
Maintenance and operational activities generated reporting data that needed to be structured and visualized so management could monitor operational conditions more easily. Technician reporting needed to be collected and structured, breakdown and downtime information needed clearer visualization, and maintenance/asset information needed a more structured digital workflow.
Goal
Build practical reporting and information-system solutions that make operational data easier to collect, monitor, and use.
Approach
Structured technician reporting using Google Sheets, connected it to Looker Studio, designed dashboards focused on Breakdown and Downtime information, developed an AppSheet application for maintenance and asset workflows, and added automation using AppSheet Bots.
Technical Implementation
Google Sheets was used as the structured operational data layer. Looker Studio transformed reporting data into management dashboards. AppSheet was used to build a lightweight maintenance and asset management application, with AppSheet Bots handling workflow automation — combining data collection, visualization, and application-based workflows.
Outcome
Created working digital reporting and workflow tools that supported operational monitoring and maintenance processes.
Limitations Note
The asset management portion of the AppSheet system was not fully completed during the internship.
Lessons Learned
Connecting technician reports in Google Sheets, dashboards in Looker Studio and AppSheet workflows brought collection, visualization and maintenance processes into one digital workflow. The asset-management portion remained incomplete, so the documented scope distinguishes that unfinished work from the reporting tools described as working.