IBM Watson Analytics: Solar Cities Project Power Usage Analysis

This report presents a comprehensive analysis of the Solar Cities project using big data analytics techniques and the IBM Watson platform. The analysis explores various factors influencing power usage, including roof color, PV capacity, insulation, estimated age, and suburb demographics. Key findings highlight the significant impact of roof color (intermediate and dark) and specific suburbs on energy consumption. The report identifies primary drivers of power usage, such as wall construction, incandescent count, fluor count, estimated age, and their correlation with the suburb. Furthermore, the analysis reveals that smaller houses (under 199 sqm) tend to consume more power. Recommendations for project managers and stakeholders emphasize the importance of modifying wall construction and considering roof colors to improve power consumption efficiency. The report concludes with a reflection on the complexity of using IBM Watson analytics and the value of data visualization for understanding complex datasets. Desklib offers a wealth of similar solved assignments and resources for students.

Running head: BIG DATA AND ANALYTICS
Big Data and Analytics
Name of the Student
Name of the University
Authors note

1BIG DATA AND ANALYTICS
Table of Contents
Task 1...........................................................................................................................2
Background information.................................................................................2
Task 2 – Reporting / Dashboards.................................................................................2
Task 3 – Research......................................................................................................12
Task4 – Recommendations for the project manager and project stake holders........13
Reflection....................................................................................................................13
References.................................................................................................................14

2BIG DATA AND ANALYTICS
Task 1
Background information
In order to carry out the analysis on the solar cities project, the data set
defined under the Solar cities database, generated by Ballarat University, has been
considered. The provided database is comprised of various elements that have
direct or indirect impact on the process of consumption of energy by individual users
based on various factors. The mentioned factors are consisted of approximate user
age, the type of construction of wall, kinds of houses, the colour of the roof, bedroom
quantity, construction of wall and many more. Moreover, cfl_count, halogen_count,
pv_capacity, incandescent_count, fluor_count, led_count, insulation,
interval_date, power_usage is significant too for identifying the type of consumption
on energy alterations in the Grampians region and Loddon Mallee region.
Task 2 – Reporting / Dashboards
The IBM Watson data analytics allows uploading data sets and determining
results of below queries. These queries are represented through various graphs.
contribution of power usage over a year by roof colour

3BIG DATA AND ANALYTICS
The graph represents that the least power sonication occurred in the year
2012. The most consumption of power has occurred in 2014. In 2014 only, the power
consumption has crossed 140k. The analysis shows that the intermediate and dark
roof colours have great impact on consumption of energy.
Contribution of power usage over a year by PV capacity
Through the graph it can be illustrated that the top drivers of the
PV_CAPACITY are Flour_Count and LED_Count, and CFL_Count and LED_Count
and SUBURB.The mist PVP capacity is in the year 2014.
Contribution of Power usage over a year by PV_Capacity and Insulation
After analysing the power usage based on Insulation and PV capacity, the
following diagram has been discovered.

4BIG DATA AND ANALYTICS
Power usage by estimated age
The breakdown regarding usage of power based on different aged persons
has been shown in the above diagram. The diagram clearly entails that sixty and
over sixty aged persons have used power more than any other aged groups.
Months with most energy consumption
The most energy composition has been occurred in the month of August in
2012. The unit of consumed energy is 28802.64 units.
Months in which least power used

5BIG DATA AND ANALYTICS
Through analysing the energy consumption values, the above graph has been
generated. The least energy consumption occur in February, 2012. The units of
power consumed was 5595.71 units.
Drivers of Power usage
WALL_CONSTRUCTION and SUBURB (28%)
SIZE_SQM and SUBURB (27%)
BEDROOMS and SUBURB (27%)

6BIG DATA AND ANALYTICS
INCANDESCENT_COUNT and SUBURB (27%)
FLUOR_COUNT and SUBURB (27%)
ESTIMATED_AGE and SUBURB (27%)
FLUOR_COUNT and ESTIMATED_AGE (26%)
CFL_COUNT and WALL_CONSTRUCTION (25%)
CFL_COUNT and ESTIMATED_AGE. (25%)

7BIG DATA AND ANALYTICS
suburbs have the most houses with pv_capacity
The LED_Count and SUBURB has the majority with 65% strength.
Houses in suburbs more likely to have pv_capacity
The PV_CPACITY in terms of houses has been shown the above diagram.
The diagram shows the twenty to twenty-nine has majority in PV_CAPACITY.
Power usage by owned and rented Houses in the Given dataset

8BIG DATA AND ANALYTICS
The above diagram shows the usage of power for rented, mortgaged, owned
and many more house types. The power usage by owned houses is way more than
others.
suburb dwellings that uses most power
From the analysis we found that, the dwellings in the Portland uses most
power in the given data set.
Power usage by the size of the house

9BIG DATA AND ANALYTICS
The above graph deceits that the smaller houses which belongs under 199
Square meter consume more power in comparison with greater SQM houses. The
small houses consume 650889.28 units power in total.
Wall construction type with the age of the houses
The most common element in the wall construction in the houses regardless
of age of house is Brick.
What age houses and from which areas and with how many bedrooms use the
most power

10BIG DATA AND ANALYTICS
Numerically the total power usage is summed up to 119096.38 units

11BIG DATA AND ANALYTICS
Relation between power usage and roof colour and roof material
Utilization of power by the houses that have double glazed windows and
window coverings