Exploring, cleaning and wrangling a water consumption dataset using python and pandas library, in order to obtain clean data. This is data is modeled and visualized in a Power BI dashboard.
SFM Technologies is an engineering and expertise firm in telecommunications networks and information technologies.
The company carries out engineering and consulting missions in order to meet the organizational challenges of development and digital transformation of Telecommunications Regulators, Network Operators, Ministries of Telecommunications and Frequency Agencies.
More than 5 IoT sensors are distributed on the 2nd floor of the company. The sensors allow us to follow the company's water consumption by collecting information about the flow every 15 seconds during 9 months, which gave us a huge database, we can neither visualize these consumptions nor interpret the results of each consumption because the dataset provided isn't well-organized and it contains some mistakes.
Thanks to the proposed solution, we can finally visualize the analysis of the water consumption data on a readable dashboard, and then give the company's managers the opportunity to make decisions based on the obtained results in order to improve their water consumption and practices.