Building dashboards for the agritech company Cerera
About the client
Cerera.ai works on quality control in crop production. The company’s qualified agronomists are constantly in their clients’ fields, verifying that agricultural operations are carried out correctly and to a high standard, and checking the phytosanitary condition of the fields. Based on the data collected in its own IT solution, Cerera provides clients with recommendations on how to improve production efficiency.
The task
Cerera approached me to visualize data from the company's internal application database. The dashboards were meant to help the company's clients monitor the current situation in their fields. At the same time, the business uses the dashboards to keep tabs on the quality of work performed by the company's agricultural specialists.
Goals
- →Build dashboards to visualize the state of the clients' fields
- →Implement a dashboard to assess the performance of field staff
What was built
- 01
Database structure analysis
Analysis of the application's database structure in order to build the required dashboards.
- 02
Creating views
Creating views in MySQL for the dashboard charts.
- 03
Visualization on a BI platform
Building charts and tables as interactive BI dashboards.
Result
Several dashboards were created to monitor agricultural operations, the condition of clients' fields, and the performance of specialists working in those fields.