Business Intelligence Report: Solar City Project Power Analysis

The Solar City Project, an initiative of the University of Ballarat, investigates factors influencing energy consumption in the Loddon Mallee and Grampians regions, aiming to evaluate drivers of power consumption and CO2 emissions by unraveling household features contributing to power consumption, such as adoption of solar energy technologies, geographical characteristics, and physical characteristics of dwellings. Dark and intermediate color roofs contribute to lower power usage compared to light and unknown roofs, with houses aged fifteen to nineteen showing the highest average power usage, while those aged forty to forty-nine have the lowest. July sees the highest average power usage, and December the lowest. Heywood has the highest number of houses with PV capacity, while Tyrendarra has the least. Recommendations include promoting higher PV capacity, using double-glazed blinds, and higher insulation capacity to PV. The author reflects positively on using IBM Watson Analytics for the project.

Solar City Project
BUSINESS INTELLIGENCE AND BIG DATA
ANALYTICS

Introduction
• The “Solar city project” is an initiative of “University of Ballarat.”
• The project focuses on factors which influence Energy Consumption in the region of “Loddon Mallee” and
“Grampians.”
• The objective of the project was to evaluate the drivers of power consumption and thus the drivers of CO2
• The project wished to unravel features in household which contribute to power consumption
• The feature which are assessed to evaluate power consumption are
 Adoption of Solar Energy Technologies
 Geographical Characteristics
 Physical Characteristics of dwellings

Dark and Intermediate colour roofs contribute to low power usage as compared to Light and Unknown Roofs

Houses with estimated age of Fifteen to nineteen have the highest average power usage.
Houses with estimated age of forty to forty-nine have the lowest average power usage.

The highest average power usage is in the month of July while the lowest average power usage is in December

Heywood has the highest number of houses with PV_Capacity. Tyrendarra has the least number of houses with PV_Capacity.

Houses with estimated age of Thirty to Thirty-nine have the highest number of installed PV_Capacity.

Average Power usage of Other-Tenure houses is the highest. Average power usage of rent-free houses is the least

Average power-usage of Casterton is the highest, while for Portland is the least. Power Usage varies across Suburbs

Average Power Usage increases with number of Lamps in a house.

Power Usage changes with number of Bedrooms, Suburb and Estimated Age of the house. Houses with over sixty and
over from the suburbs of Casterton and Heathmeare having more than 3 bedrooms use the maximum power.

Dark coloured roofs made of Timber and Concrete Blocks utilise the highest power