ITECH1103- Big Data andAnalytics Group Assignment2018Worth – 30%ANALYTIC REPORT (20%- Due Week 11 Friday 11.55pm)andPRESENTATION (10% - Due Week 10 in Tutorial Time)Analytical Report:Learning Outcomes Assessed: K3, S2, A1, V1, V2 :Purpose: The purpose of this task is to give students practicalexperience to work in teams to write a Data Analytical report, whichwill provide useful insights, patterns and trends from a given dataset.This activity will give students the opportunity to showresourcefulness and creativity by applying Watson Analytics.Enabling them to design useful visualization and predictive solutionsfor an analytics problem set.Group Presentation: Week 10 (Scheduled Laboratory)Learning Outcomes Assessed: K4, K5, A2, V1, V2Purpose: The purpose of the oral presentation is to provide anopportunity for students to present the results of Data Analysis andto share this knowledge while practicing their verbal communicationskills.Project Details: Your task for this analytical project is to use theWatson Analytics tool to explore, analyze and visualize the givendataset: Solar Cities, power usage. You will need to provideinteresting insights, trends and patterns from the data set features.1 of 9Data set background:The Solar cities project was a project led by the University ofBallarat, (former name of Federation University), which involved therecruitment of households and businesses across the Loddon Malleeand Grampians regions to monitor changes in energy consumption.The project looked at a number of factors that could influenceenergy consumption. These factors were broken up into sets offeatures, and measurements were taken for each respective feature.For example, a factor could be related to a dwelling's constructionmaterials. In which case a feature could be “dwelling constructiontype” and a measurement would be taken to determine theconstruction type for each dwelling and stored in the data set. Forexample “dwelling construction type” could contain the values brick,brick veneer etc... Many of these features are included within theprovided Solar Cities data set.The following are sets of features included in the provided data set: Adoption of solar energy technologies Geographic characteristics Physical characteristics of the dwellings, including suchthings as the dwellings age, size, number of stories, number oflights, insulation etc.The main aim of this project is to understand the drivers of powerconsumption, and as a large percentage of electrical energy iscreated by coal fired plants, then conversely the drivers of CO2Therefore two main questions that need to be asked as a researcherof the Solar Cities project are:1. Which combination of features highlight where efficienciescould be made in the reduction in energy consumption?2. What would you include in a predictive model that wouldexplain the demand on future energy use and CO2 emissions?i.e. which features and their measurements contribute toeither higher or lower energy consumption? (For a predictivemodel, Watson Analytics does have a rule based engine...)2 of 9You have been commissioned as a research assistant with the mainaim to find the drivers of power usage, understand the factors thatcontribute to this and provide any useful and interesting insights,trends and patterns that could be presented to the stakeholders ofthis project. Your intended audience are the project manager andassociated stakeholders.Your findings will be presented to the project manager and the otherstakeholders, where you will outline the factors that contribute topower usage and what your recommendations will be to reducepower consumption, given the current dwellings that exist in thegiven geographical locations in country Victoria (i.e found in thedata set).You are expected to present the data findings in visual forms (i.e.,charts and graphs). This is a group assignment. You will complete itwith your team (max 3 members enrolled in the same laboratory).• It is expected that each team member will contribute equallyin the project.• Each team will turn in one joint document and give a jointpresentation in the timetabled laboratory class in Week 10.• In addition, each individual team member will turn in a shortreflection as part of the report.You will receive feedback on the draft about presentation choices,content, analysis, and style.3 of 9Data Set:Please use the dataset provided on the Moodle Shell in theassessment section.Your job is to examine the available data and present it in a set ofinformative graphs and text. You may use the following questions todetermine the major factors driving power consumption in thedwellings found in the data set. But you should also look for furtherquestions, relationships and patterns to get a better understanding,in order to better form your recommendations. Remember, you willalso need to answer the above two main questions.Some Starting Questions1. What is the contribution of power usage over a year by roofcolour?2. What is the contribution of power usage over a year byPV_Capacity?3. What is the contribution of power usage over a year byPV_Capacity and Insulation?4. What is the power usage by estimated age?5. Over which months is the most power used?6. Over which months is the least power used?7. What are the top drivers of power usage?8. Which suburbs have the most houses with pv_capacity9. Which age houses are more likely to have pv_capacity?10. Are houses that are owned more likely to use less power thanthe ones that are rented?11. Which suburb dwellings use the most power?12. Do houses with larger square meterage use more power thansmaller houses, also does double story make a difference?13. Which light types in dwellings use more power?14. Does having more lights of any type mean the house will usemore power?15. What age houses have what type of wall construction?16. What age houses and from which areas and with how manybedrooms use the most power?17. Does Roof colour and roof material make difference to powerconsumption?18. Do dwellings that have double glazed windows and with windowcoverings use less power?4 of 9Task 1- Background informationWrite a description of the selected dataset and its importance giventhe Solar Cities project, i.e. the Solar Cities project is attempting tounderstand power usage in dwellings, in order to then recommendhow to improve the overall efficiency of power consumption indwellings. Information must be appropriately referenced. [1 Page]Task 2 – Reporting / DashboardsFor your project, perform the relevant data analysis tasks by• answering the above questions• finding new relevant questions• answering the two main questionsYou should also identify the visualization and dashboards you needto develop to best communicate your findings to the stakeholders.[2-3 Pages]Task 3 – ResearchJustify why these BI reporting solution/dashboards are chosen inTask 2 (Reporting / Dashboards) and why those data set features arepresent and laid out in the fashion you proposed (feel free to includeall other relevant justifications).Note: To ensure that you discuss this task properly, you must includevisual samples of the reports you produce (i.e. the screenshots ofthe BI report/dashboard must be presented and explained in thewritten report; use ‘Snipping tool’), and also include anyassumptions that you may have made about the analysis in yourTask2. [1-2 Pages]Task4 – Recommendations for the project manager andproject stake holdersBased on your BI analysis and the insights gained from the “DataSet”, given your analysis performed in previous tasks, make somelogical recommendations to the stake holders. Justify the answers tothe two main questions, and show where power consumptionefficiencies could be made, and what future consumption will looklike. Give 2 possible scenarios. Also, if you have a predictive modelshow which features and measurements lead to powerreductions/increases, to add to your logical recommendations. Dothis with the help of appropriate references from peer-reviewedsources. [1-2 Pages]5 of 9Task 5 - The Reflection: Each Team member is expected to write abrief reflection about this project in terms of challenges, learning andcontribution.Report Submission: Submit a 7-8 page report (about 1500 words) notcounting cover page and references) of this project. At least5 references in your report must be from peer-reviewedsources. Include any and all sources of information includingany person(s) you interviewed for this project. Please note that all references must adhere to APA style. Seehttp://owl.english.purdue.edu/owl/resource/560/01 andhttp://www.apastyle.org/ for details on how to format areport and how to cite references. Make sure your followformal report structure with cover page, introduction, use ofheadings, subheadings, conclusion sand reference section. You are reminded to read the “Plagiarism” section of the course description. Your essay should be a synthesis of ideasfrom a variety of sources expressed in your own words. All reports must use the APA referencing style. UniversityReferencing/Citation Style Guide: The University has publisheda style guide to help students correctly reference and citeinformation they use in assignments (American PsychologicalAssociation (APA) citation style,http://www.ballarat.edu.au/aasp/student/learning_support/generalguide/print/ch06s04.shtml or Australian citation style Reports are to be presented in hard copy in size 12 Arial Fontand double spaced. Your report should include a list ofreferences used in the essay and a bibliography of the widerreading you have done to familiarize yourself on the topic. A passing grade will be awarded to assignments adequatelyaddressing all assessment criteria. Higher grades requirebetter quality and more effort. For example, a minimum is seton the wider reading required. A student reading vastly morethan this minimum will be better prepared to discuss theissues in depth and consequently their report is likely to be ofa higher quality. So before submitting, please read through theassessment criteria very carefully.