The Solar cities project was a project led by the University of Ballarat, (former name of Federation University), which involved the recruitment of households and businesses across the Loddon Mallee and Grampians regions to monitor changes in energy consumption. The project looked at a number of factors that could influence energy consumption. These factors were broken up into sets of features, and measurements were taken for each respective feature. For example, a factor could be related to a dwelling's construction materials. In which case a feature could be “dwelling construction type” and a measurement would be taken to determine the construction type for each dwelling and stored in the data set. For example “dwelling construction type” could contain the values brick, brick veneer etc... Many of these features are included within the provided Solar Cities data set.
The following are sets of features included in the provided data set:
The main aim of this project is to understand the drivers of power consumption, and as a large percentage of electrical energy is created by coal fired plants, then conversely the drivers of CO2
Therefore two main questions that need to be asked as a researcher of the Solar Cities project are:
i.e. which features and their measurements contribute to either higher or lower energy consumption? (For a predictive model, Watson Analytics does have a rule based engine...)
You have been commissioned as a research assistant with the main aim to find the drivers of power usage, understand the factors that contribute to this and provide any useful and interesting insights, trends and patterns that could be presented to the stakeholders of this project. Your intended audience are the project manager and associated stakeholders.
Your findings will be presented to the project manager and the other stakeholders, where you will outline the factors that contribute to power usage and what your recommendations will be to reduce power consumption, given the current dwellings that exist in the given geographical locations in country Victoria (i.e found in the data set).
You are expected to present the data findings in visual forms (i.e., charts and graphs).
Some Starting Questions
Write a description of the selected dataset and its importance given the Solar Cities project, i.e. the Solar Cities project is attempting to understand power usage in dwellings, in order to then recommend how to improve the overall efficiency of power consumption in dwellings. Information must be appropriately referenced.
Task 2 – Reporting / Dashboards
For your project, perform the relevant data analysis tasks by
You should also identify the visualization and dashboards you need to develop to best communicate your findings to the stakeholders.
Justify why these BI reporting solution/dashboards are chosen in Task 2 (Reporting / Dashboards) and why those data set features are present and laid out in the fashion you proposed (feel free to include all other relevant justifications).
Note: To ensure that you discuss this task properly, you must include visual samples of the reports you produce (i.e. the screenshots of the BI report/dashboard must be presented and explained in the written report; use ‘Snipping tool’), and also include any assumptions that you may have made about the analysis in your Task2.
Task4 – Recommendations for the project manager and project stake holders
Based on your BI analysis and the insights gained from the “Data Set”, given your analysis performed in previous tasks, make some logical recommendations to the stake holders. Justify the answers to the two main questions, and show where power consumption efficiencies could be made, and what future consumption will look like. Give 2 possible scenarios. Also, if you have a predictive model show which features and measurements lead to power reductions/increases, to add to your logical recommendations. Do this with the help of appropriate references from peer-reviewed sources.
Task 5 - The Reflection: Each Team member is expected to write a brief reflection about this project in terms of challenges, learning and contribution.
The data analysis of this study finds the “Skills and Credibility” of the students about the fact how they are capable of using the online visualisation tools- “IBM Weston Analytics” (Zhu et al., 2014). Also, their ability to execute the decision analysis and predictive analysis are verified in this research report. The research report is structured on the basis of “Solar city project data” analytically. The data set used in the report is gathered by a reputed concerning University. This analytical study focuses on the explanatory variables of the data set that may control the usage of electric power in various suburbs of “Victoria”. The analyst concluded as per the preferences of “Dwellings” and “Businesses” over “London Mallee” and “Grampians”.
The research questions are represented by “Dashboard” presentation. The three types of features considered here, are – 1) “Geographic Characteristics”, 2) “Adoption of Solar energy Technologies”, and 3) “Physical Characteristics of different types of dwellings”. The explanatory factors associated to the dwellings detain the significant drivers and predictors of the energy usage. A significant proportion of “Electric energy” generated from “Non-renewable” resources of energy especially “Coal” or “Petroleum” generate extensive amount of threatening gases like CO2. The reporting of “Business analysis” with the support of “Dashboards” would support the decision-makers and policy-makers to commence the interpretations with respect to “Business outputs” (Jiang, 2017). The analyst would present the outcomes of the analysis to the project manager and stakeholders. They would be capable of recommending the possible steps and measures to make suggestive decisions regarding geographical locations of “Victoria” in the matter of excess energy usage and excess emission of carbon di-Oxide (Kang & Han, 2008).
The power was mostly used in 2014 and least in 2012. The power usage is highest in “Dark” coloured roof followed by “Intermediate” coloured roof.
The power usage is highest when Photo-Voltaic capacity is least. The power is mostly used in the dwellings in 2014 for the Photo-Voltaic capacity 0 to 960. The overall power usage is least in Photo-Voltaic capacity 3841-4800.
The power usage is highest for the Photo-Voltaic capacity 0 to 960 with insulation 1 in 2014 followed by Photo-Voltaic capacity 0 to 960 with insulation 1 in 2013 and 2015. The power usage is comparatively lesser in the dwellings for higher Photo-Voltaic capacity and number of insulation does not put a significant effect in this case. The
The usage of power is highest for the dwellings where estimated age of the dwellings is Sixty years and over. The usage of power is least for the dwellings whose estimated age is 0 to 4 years.
The total power usage in all the four years is highest in “July” with the usage of more than 155 K.
The total power usage in all the four years is lowest in “November” with the usage of less than 80 K.
The significant “Top driver” of the power usage are –
“Suburb” singularly explain 21% consumption of the Power. On the other hand, “Wall construction” and “Suburb” both jointly explain 28% consumption of Power.
The “Portland” suburb have most number of houses with Photo-Voltaic capacity. The “Heywood” suburb have second highest number of houses with Photo-Voltaic capacity.
The “Age group” of “Thirty to Thirty-Nine” are more likely to have a Photo-Voltaic capacity. The Power Voltic Capacity in this “Age group” varies from 0 and 3840.
No, the “Owned” houses are more likely to use power than the “Rented” houses.
The usage of power in all the dwellings is maximum for “Portland” suburb. The usage of power is second highest in “Heywood” suburb.
The power usage is higher for the houses that has larger area (199 sq. metre) and power usage is lesser for the rooms whose area is small. The usage of power usage is higher for single storied houses than double storied houses.
From the five graphs of average power usage and light counts of LED, CFL, Halogen, Incandescent and Fluorescent lights, it is observed that “Halogen” light mostly causes power consumption.
The power consumption is higher for the houses with any means of lights (“CFL”, “Halogen”, “LED”, “and Fluorescent” and “Incandescent”) when total number of lights is 17. The power consumption descends for the power usage 13, 21, 23 and 26. No prominent pattern is found for the power usage and number of lights. Hence, more number of lights do not mean the more amount of power usage.
The power usage is maximum for the houses made of “Weatherboard” having age Sixty years and over. The houses made of “Bricks” have second highest power usage for the age Twenty to Twenty-nine. Overall, the power is mostly used in the houses made of “Bricks” followed by “Weatherboard”. The power usage is least for the roof construction of “Concrete Block”, “Double Brick” and “Unknown” types of building materials.
The power usage is maximum in the houses of age “Forty to Sixty Nine” years with number of bedrooms 1 to 20 in “Portland” suburb.
Yes, roof colour and roof material make difference to power consumption. The power is mostly consumed in “Dark” coloured rooms made of “Bricks”, followed by “Intermediate” coloured rooms made of “Bricks”. The power consumption is comparatively much lesser for the dwellings of “Concrete block” and “Double brick”.
Yes, the dwellings having “Double glazed” windows and window coverings (Blinds or Curtains) utilise lesser power than the dwellings of “Single glaze” windows with and without any kinds of “Window coverings”.
In case of “Business intelligence” and “Business information”, the reporting by dashboard is a vital aspect that assistances to make conversant conclusions and decisions especially for the “IP Professionals” (Eckerson, 2010). Decision-makers and policy makers uses “Dashboards” to capture the “Long-term Objectives” (Ferrucci, 2012). “Creating”, “Managing” and “Sharing” of the business reports could be an activity represented by “Dashboards” for its versatility (Palpanas et al., 2007). This analysis is visualized with the help of “Dashboards” that easily reveals “Inherent trend”, “Pattern” and “Association” among the factors of the data set.
Research Question 1.
“Which combination of features highlight where efficiencies could be made in the reduction in energy consumption?”
The combinations that would be beneficial to reduce the power consumption are-
If following aspects are considered at the time of constructing the dwellings, then lesser power would be consumed (Hoyt et al., 2016).
Research Question 2.
“What would you include in a predictive model that would explain the demand on future energy use and CO2 emissions?”
The dashboard presents the predictive model of use of energy consumption by different factors that would determine the emission of poisonous gas like Carbon-di-Oxide (CO2). These factors are –
The two constructed dashboards indicate that dark coloured rooms, with high estimated age, brick type wall constructing material, single storied dwellings and with window curtains consumes high amount of energy. The lower PV_capacity and heavy usage of lights especially “Halogen” lights consumes high amount of electric energy. As the year is proceeding, the power consumption in the different types of suburbs especially in “Heywood” and “Portland” suburb is significantly enhancing. Size of the rooms and different types of month of the year also bring variability of power usage.
Chen, H., Chiang, R. H., & Storey, V. C. (2012). Business intelligence and analytics: from big data to big impact. MIS quarterly, 1165-1188.
Eckerson, W. W. (2010). Performance dashboards: measuring, monitoring, and managing your business. John Wiley & Sons.
Ferrucci, D. A. (2012). Introduction to “this is watson”. IBM Journal of Research and Development, 56(3.4), 1-1.
Frolick, M. N., & Ariyachandra, T. R. (2006). Business performance management: One truth. IS Management, 23(1), 41-48.
Hoyt, R. E., Snider, D., Thompson, C., & Mantravadi, S. (2016). IBM Watson analytics: automating visualization, descriptive, and predictive statistics. JMIR public health and surveillance, 2(2).
Jiang, F. (2017). Data Analytics Helps Business Decision Making.
Kang, J. G., & Han, K. H. (2008, November). A business activity monitoring system supporting real-time business performance management. In Convergence and Hybrid Information Technology, 2008. ICCIT'08. Third International Conference on (Vol. 1, pp. 473-478). IEEE.
Lim, E. P., Chen, H., & Chen, G. (2013). Business intelligence and analytics: Research directions. ACM Transactions on Management Information Systems (TMIS), 3(4), 17.
Palpanas, T., Chowdhary, P., Mihaila, G., & Pinel, F. (2007). Integrated model-driven dashboard development. Information Systems Frontiers, 9(2-3), 195-208.
Zhu, W. D. J., Foyle, B., Gagné, D., Gupta, V., Magdalen, J., Mundi, A. S., ... & Triska, M. (2014). IBM Watson Content Analytics: Discovering Actionable Insight from Your Content. IBM Redbooks.
To export a reference to this article please select a referencing stye below:
My Assignment Help. (2020). Big Data And Analytics. Retrieved from https://myassignmenthelp.com/free-samples/itech1103-big-data-and-analytics/report-on-solar-city-project-data.html.
"Big Data And Analytics." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/itech1103-big-data-and-analytics/report-on-solar-city-project-data.html.
My Assignment Help (2020) Big Data And Analytics [Online]. Available from: https://myassignmenthelp.com/free-samples/itech1103-big-data-and-analytics/report-on-solar-city-project-data.html
[Accessed 21 January 2021].
My Assignment Help. 'Big Data And Analytics' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/itech1103-big-data-and-analytics/report-on-solar-city-project-data.html> accessed 21 January 2021.
My Assignment Help. Big Data And Analytics [Internet]. My Assignment Help. 2020 [cited 21 January 2021]. Available from: https://myassignmenthelp.com/free-samples/itech1103-big-data-and-analytics/report-on-solar-city-project-data.html.
If you are not sure how to write an essay in a short time, then visit our website MyAssignmenthelp.com to avail top-notch quality output in a jiffy. Experienced qualified writers are at your disposal for writing an essay based on the client’s requirements. We also have numerous essay examples stored in our repository as free samples which highlight the extensive research work the writers conduct to create unique content. Moreover, you get 100% original content at an economical price. Professional essay help is at its best with our writers as they incorporate additional information into the content in the form of graphs, charts, tables etc.
Answers: 1. Database Management Systems versus Spreadsheets A database application could be used for selecting the desired application. One of the major points of difference between the spreadsheet applications and database is that the information stored within spreadsheets could be performed within a file system while data stored within a data is quickly accessible with some commands, which are quickly addressable. The examples are: It i...
Read MoreAnswers: 1: Staining can be considered as an auxiliary technique that is abundantly used in the microbiological studying that helps in identification of different microbial strains. There are different kinds of microbial straining procedures, such as spore staining, simple staining, negative staining, hanging drop slide, and gram staining. In order to understand the difference between the above mentioned types of staining, it can be mentioned...
Read MoreAnswer: 1.Biometric system can be defined as a technological system that makes use of certain information about a person in order to identify the person. Biometric system therefore mainly relies on specific data mostly associated with the unique biological traits of a person. The most commonly used biometrics include Fingerprint, hand geometry and iris recognition along with face recognition, DNA matching and so on (Hasan & Abdul-Kareem, 2...
Read MoreAnswer: Part A: Task 1: Report Methodology 1: Dynamic Software Development Method Description: The software methodology that is being used as the primary working methodology in this case has its base on the Rapid Application Development Process. It is a methodology that has four phases in its framework that focuses on the developmental process of the software in the organization also involving the feasibility study regarding the project...
Read MoreAnswer: Introduction: Virtual Machine Manager is also known as the “hypervisor” is considered to be one of the many of the hardware virtualization technique that is associated with allowing the multiple operating system also known as guest to operate in a concurrent way with the host computer. This is also named like this because conceptually it is placed on one level higher that the supervisory program (Masdari, Nabavi, & Ahm...
Read MoreJust share requirement and get customized Solution.
Orders
Overall Rating
Experts
Our writers make sure that all orders are submitted, prior to the deadline.
Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.
Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.
Our writers can provide you professional writing assistance on any subject at any level.
Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.
Get all your documents checked for plagiarism or duplicacy with us.
Get different kinds of essays typed in minutes with clicks.
Calculate your semester grades and cumulative GPa with our GPA Calculator.
Balance any chemical equation in minutes just by entering the formula.
Calculate the number of words and number of pages of all your academic documents.
Our Mission Client Satisfaction
The assignment was awesome and I scored good at this. Hope to get more such help from you.
Australia
This was perfectly done. I got a perfect score and more time to focus on my bigger assignments
Australia
This reflection assignment is well written with great details and supporting evidences.
Australia
My professor gave me a perfect grade for this assignment and I\'m super impressed with the quality of work.
Australia