Project Details:

This project was built to learn the end-to-end process of data workflow from building the sensors that collect data to building the pipeline for the information to be stored and finally for the extraction, transformation and loading of the data to an analysis platform such as R and PowerBI.

​

From data that was collected and analysed, it was found that air conditioning usage could be reduced up to 40% in the given test period by ventilating a room well instead of turning the air con on. Suggestions were given on smart systems that could automatically turn the aircon off and open windows automatically using sensors and servos.

​

Scroll down to view project highlights and download links for project files.

​

This project has 2 other sub parts which can be accessed via these links:

​

Sensor uptime monitor using PowerBI Direct Query

​

Prediction model, A comparison of using Excel and R for machine learning / prediction