Every good project begins with the preparation of graphic data.
Surveyers give us elements, and then i make attribution of elements, and graphic elements are linked by relations to elements existing in the database.
After that i have import data into MS SQL database and start with Tableau.
I have make 4 Dashboards.
At first Dashboard you can see mat with graphical elements, you can select Community, street. Also, you can switch Theme by profile or type of network. Here you have also information about water counsumation, distribution area and measuring units.
At this dashboard you can select a day to see data about supervised water pumps.
The third Dashboard
At third Dashboard you can select Community, Street and Private users/Companies. Data about consumption are present at map and also in table for selected partner.
The fourth Dashboard give you graphical view about partners and streets.
Whole project you can try at Tableau public: