All posts by Report Bee Admin

Water scares city to Water Scarcity!

Title of this post is inspired from recent forward on social media about rain and water situation in Chennai. This forward also triggered the curiosity of data monks (a secret group) in Report Bee. Questions like?…

  • Where does Chennai get its water? What is its storage capacity?
  • How dependent is Chennai on Monsoons?
  • What will happen to water situation as Chennai’s population grows?
  • Is there a changing pattern in rains or weather?

We needed data to answer these questions. Luckily we had a good starting point for our data adventure – The website of Chennai Metro Water. This site has water levels of Chennai’s reservoirs (Lakes) for each day for the last 14 years (We wish it was 40 years of data!).

First step!

A Python script helped to retrieve the total volume of major reservoirs in Chennai. Once we had the data in the desired CSV format, it was play time 🙂

Where does Chennai get its water? What is its storage capacity?

We plotted various graphs to visualize the data and learn from it . The first graph, the total water levels from 2004 until today.


Observations from above graph, from 2004 up until 2012, the water levels have been fairly consistent across the year and these were years of water sufficiency. From 2013 onwards, there is a drastic fall in water levels across the 5 chief reservoirs which supply water to Chennai. This shortage of water did not stop even in 2015- December, the year infamous for Chennai floods.

Is there a changing pattern in rains or weather?

What we are seeing increasingly is a Monsoon that is holding itself back a little and then packs a punch too wet to handle in the months of Nov-Dec.

The truth is that when it rains so much in so little time, all water goes down the drain, literally. We need new ways to trap the monsoon efficiently.

Then, we visualized the 2004 to 2017 in an overlapping graph.

This visualization makes it is easy to compare the water levels across the years. In recent years, we run out of water faster and failed Monsoon threatens the city of drought. Validates the humour in the title of this post.

What will happen to water situation as Chennai’s population grows?

To understand this better, we calculated time taken for the water level to come to 3600 Mcft in a given year. Assuming that this level of water is a situation of concern. Listing the calculation for some of the years.

Jan 2006 – 8 months and 10 days to reach 3600 Mcft
Jan 2008 – 7 months and 20 days
Jan 2011 – 5 months to reach 5100 and then increases again
Dec 2015 – 8 months and 20 days to reach 3600 Mcft

In 2030, at full capacity in the 5 chief reservoirs, we’ll completely run of water in 9 months even if we get good rains. Chennai will face severe water scarcity in coming years.

  • Current Population of Chennai = 10,435,000, consumes 830 MLD/day
  • Predicted Population in 2030 = 13,921,000, will consume 1100 MLD/day
  • Reservoirs (Lakes) at Full Capacity = 300,000 MLD
  • Assuming no rainfall, No. of days the reservoirs will be sufficient for = 300,000/1,100 = 272 days (~9 months)

Do we need more desalination plants?  Do we need to build more reservoirs? Take a look at the table below.

Three were built in British era and other 2 much before! Are our catchment areas (reservoir locations) enough, do we need more?

How dependent is Chennai on Monsoons?

Monsoons are India’s lifeline. We used to be an agrarian economy dependent on rainfall for our survival in the global market. Today, years later, though the balance has shifted in favour of services more than manufacturing or agriculture, we are still dependent on these life-giving winds from the Indian Ocean. Even if not for agriculture in Chennai, it is to feed our rivers and put that glass of water on our dinner tables!

It’s not a goodbye, I’ll come back!

Author : Prakash Kamaraj

I don’t know where to start. I didn’t plan for it. But it happened.

I strongly believe in destiny, it takes us to places. For me, it was Antony Jackson. He took me in his arms, and gave me a lifetime opportunity. Who could dare to refuse? I never believed that I would get a job while still in college. After heading home, I told my dad , the one person who strongly believes in me that I got a job.

I joined Report Bee as an intern. Arvind from Partnerships received me with a warm smile. Yeshwanth granted me the Wi-Fi access. Daniel Doss, encouraged me with his strong words. Anant, I’d call him the coolest CEO on Earth. He handles everything with a smile. He came all the way to parking lot to wish us a safe journey. He never saw us as employee, but as a family, a bee hive. Sudha Ma’am has always been a sweetheart. She treats me like her son, and I get jealous when she calls Titus as “Titu”. Titus is real chilled out guy, deals everything lightly and solves it.

I learnt “How to grab information in a meeting” from Bala. That was my first meeting at Report Bee. Anjan gave me the confidence to learn new things. Anjan and Jack pushed me to take courses for my own growth and I grabbed the certificates with full marks. Directly or indirectly, I learnt something from everyone at Report Bee. There is a lot of positive energy everywhere. I used to be that one silent kid in the office but Manasa taught me to socialise with people.



My First job as a Designer has now become a memory for life. We had ‘Theme Thursdays’ where we followed themes and captured pictures and videos and participated in ‘Fresh Air Meets’ which happens early morning once in a month. When Jack decided to paint the office white, most of the bees jumped in to help.  It was one memorable day.

We had a lot of conversations and life lessons that helped me grow within as a person. The last 10 months here has taught me lessons for life and i know its not going to be the same outside. I’ll miss each and every bee in Report Bee. I’ve wanted my designs all over RB, and I’ve been pretty vocal about it.


I guess I did it! 😀

From Panic to Positivity

  Author: Venkateswaran

It was the tail-end of September, the time when schools generate their Term-I report cards. I had to travel out-of-station for a set of meetings that were scheduled during that time. While there were certain pending tasks, I was pretty sure that things will still function smoothly if I’m not in office for a week.

With that in my mind and a little bit of excitement, I flew to Delhi, my first ever trip to the capital. The moment I landed there and switched on my phone, messages started flooding in causing uneasiness. The reasons were two-fold. Firstly, I weren’t in my work space to handle issues and secondly, I feared I wouldn’t be able to experience and enjoy Delhi as planned.


One good emotion that saves us every time is “hope”. Hope doesn’t provide you a solution for any situation, but it helps you to move on. I hoped that I’ll be able to resolve all the problems that were unearthing and carry on with the scheduled meetings. As the day went by the count of work-related queries kept increasing with the expectation to resolve them all being within the same day.

I was starting to panic. Though I was trying to resolve most of it, work kept piling up. In the evening, after all the meetings, I called a colleague with whom I had planned to stay for the week. I thought of reaching his place early and finishing the work at his place. But alas, he was returning late from work. With nowhere to go I was roaming around Delhi. While I was trying my best to ease the situation my only source of communication, the single positive pillar that I had pinned my hopes on – my phone ­­­­– got switched off.

There is a popular saying in Tamil, “Muzhusa nenanja apram mukkaadu edhukku?” (After getting drenched, why do you need a scarf?).  With that thought my panic flew away. There was nothing to do but to be in the moment and let it sink. Sitting on a bench, a smile rose above my cheekbones.

For the next hour I roamed around the mall and found a place to charge my phone. I connected with a helpful resource at my office in Chennai and he briefed me of the things that were taken care of. By then, my colleague had also reached his house. I went to his place after dinner, had a nice talk and went to bed. It was a while since I had such a sound sleep.