MoreThanAnalytics

Inspiration

Being in a hackathon, surrounded by many people on the same room, gave us the idea to create a monitoring tool for determining an employee's efficiency in an office based on easily-measurable metrics using Grafana.

What it does

We created a web dashboard that provides an employee and a company with information about the environmental variables in their workplace. In addition, the dashboard gives recommendations

to employees: for seeing the relationship between their environment and their productivity;
to companies: for improving some environmental-related CSDR KPIs.

MoreThanAnalytics improves the happiness of employees, and it is inexpensive to roll out and run.

How we built it

First, we created a C program (with the Arduino IDE) to ingest data from temperature, humidity and noise sensors from an ESP32 board. Then we created a Python script that connects to this board through its serial port, and uploads all recorded values to an InfluxDB database. A Grafana dashboard then queries this database to create neat visualizations.

Challenges we ran into

Deploying the whole application was difficult at times, because the different parts need to communicate with each other. We used Docker Compose to simplify this task, but even then configuring InfluxDB as a data source in Grafana took us a while.

Accomplishments that we're proud of

Team collaboration was great!

What we learned

We learned many things about Grafana, InfluxDB, Docker, serial communication with devboards, and microelectronics.

What's next for MoreThanAnalytics

Expanding the breadth of our application, by ingesting data from more kinds of sensors. Also, we would like to set up a system that integrates the environmental data registered through our systems with CSDR compliance tools/utilities.