Case Study


Kerala Rainfall data to analyses sales impact

Client stumbled upon the unlikely problem of reduced sales in Kerala and wanted to understand the causation behind the impact. They mapped unprecedented rainfall as the catalyst.

Resources Assigned
Project Type

Detailed Research


Consulting Firm



Project Completion

January, 2023

The Problem

The project required us to comprehensively chart out the district-wise rainfall pattern in Kerala to understand the most affected. We were required to extensively present the data in a meaningful and understandable format.

The Solution

Our team pulled out the data regarding the rainfall pattern from multiple scattered sources and presented them chronologically to give a succinct overview of rainfall variance. Our team introduced additional control columns in the table, like %variance, to be more exhaustive and precise. Team also furnished a list of ancillary platforms (paid/unpaid) to give a comprehensive additional support beyond the ask.

Limited availability

Highly limited data

Technical knowledge

Understanding unfamiliar units

The Impact we created

Our support and the final output helped client to understand and in/validate their initial hypothesis of deviation of rainfall from normal in Kerala being the impetus for reduced sales

Structuring data

Architect the enormously scattered data set on open web into a cohesive and understandable format


Trends of rainfall impacted the sales