Last week, I posted a graph of my household water use for the past few years and challenged our readers to identify as many interesting characteristics about my household as they can. Often, the only data a water utility has on their customers are what they have in their billing records. Other household characteristics, such as size of household, income, age, house and lot size and features, water use behavior and preferences, etc., are very difficult to obtain for each customer. However, as demonstrated by my own personal example, mining the billing data alone can reveal much about each household. Here is what my water use history reveals about my household, and the application of this exercise in water resources and utility finance management.
Are you up for a challenge? I have disclosed in this graph my own household’s water use between June 2006 and December 2014, as reported on my water bills. Without any more information about my household’s characteristics (except that it is residential, on a single 5/8″ meter, and using drinking water and wastewater service from one utility), this is the extent of knowledge that my utility has about my household. Yet, my water use data – which are present in the utility’s billing records – reveal much about my household. My challenge to you is to look at this graph and identify as many interesting characteristics about my household as you can. Think about it, too, from the perspective of how the utility should interact with my household. Here are a few questions to consider to get you started: