ITECH1103- Big Data and Analytics Group Assignment 2018 Worth – 30%    

ANALYTIC REPORT (20%- Due Week 11 Friday 11.55pm) and PRESENTATION (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 practical experience to work in teams to write a Data Analytical report, which will provide useful insights, patterns and trends from a given dataset. This activity will give students the opportunity to show resourcefulness and creativity by applying Watson Analytics. Enabling them to design useful visualization and predictive solutions for an analytics problem set.  

Group Presentation: Week 10 (Scheduled Laboratory) Learning Outcomes Assessed: K4, K5, A2, V1, V2 Purpose: The purpose of the oral presentation is to provide an opportunity for students to present the results of Data Analysis and to share this knowledge while practicing their verbal communication skills.

Project Details: Your task for this analytical project is to use the Watson Analytics tool to explore, analyze and visualize the given dataset: Solar Cities, power usage. You will need to provide interesting insights, trends and patterns from the data set features. 

1 of 9

Data set background: 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:  Adoption of solar energy technologies  Geographic characteristics  Physical characteristics of the dwellings, including such things as the dwellings age, size, number of stories, number of lights, insulation etc. 

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: 1. Which combination of features highlight where efficiencies could be made in the reduction in energy consumption? 2. What would you include in a predictive model that would explain the demand on future energy use and CO2 emissions? 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…)

2 of 9

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). This is a group assignment. You will complete it with your team (max 3 members enrolled in the same laboratory). • It is expected that each team member will contribute equally in the project. • Each team will turn in one joint document and give a joint presentation in the timetabled laboratory class in Week 10. • In addition, each individual team member will turn in a short reflection as part of the report. You will receive feedback on the draft about presentation choices, content, analysis, and style.

3 of 9

Data Set: Please use the dataset provided on the Moodle Shell in the assessment section. Your job is to examine the available data and present it in a set of informative graphs and text. You may use the following questions to determine the major factors driving power consumption in the dwellings found in the data set. But you should also look for further questions, relationships and patterns to get a better understanding, in order to better form your recommendations. Remember, you will also need to answer the above two main questions.

Some Starting Questions 1. What is the contribution of power usage over a year by roof colour? 2. What is the contribution of power usage over a year by PV_Capacity? 3. What is the contribution of power usage over a year by PV_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_capacity 9. Which age houses are more likely to have pv_capacity? 10. Are houses that are owned more likely to use less power than the ones that are rented? 11. Which suburb dwellings use the most power? 12. Do houses with larger square meterage use more power than smaller 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 use more power? 15. What age houses have what type of wall construction? 16. What age houses and from which areas and with how many bedrooms use the most power? 17. Does Roof colour and roof material make difference to power consumption? 18. Do dwellings that have double glazed windows and with window coverings use less power?

4 of 9

Task 1- Background information 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. [1 Page]

Task 2 – Reporting / Dashboards For your project, perform the relevant data analysis tasks by • answering the above questions • finding new relevant questions • answering the two main questions You should also identify the visualization and dashboards you need to develop to best communicate your findings to the stakeholders. [2-3 Pages]

Task 3 – Research 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. [1-2 Pages]

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. [1-2 Pages] 5 of 9

Task 5 – The Reflection: Each Team member is expected to write a brief reflection about this project in terms of challenges, learning and contribution.

Report Submission:  Submit a 7-8     page     report     (about     1500     words) not counting cover page and references) of this project. At least 5 references in your report must be from peer-reviewed sources. Include any and all sources of information including any person(s) you interviewed for this project.  Please note that all references must adhere to APA     style. See http://owl.english.purdue.edu/owl/resource/560/01 and http://www.apastyle.org/ for details on how to format a report and how to cite references. Make sure your follow formal report structure with cover page, introduction, use of headings, subheadings, conclusion sand reference section.  You are reminded to read the “Plagiarism” section of the  course description. Your essay should be a synthesis of ideas from a variety of sources expressed in your own words.  All reports must use the APA referencing style. University Referencing/Citation Style Guide: The University has published a style guide to help students correctly reference and cite information they use in assignments (American Psychological Association (APA) citation style, http://www.ballarat.edu.au/aasp/student/learning_support/gene ralguide/print/ch06s04.shtml or Australian citation style  Reports are to be presented in hard copy in size 12 Arial Font and double spaced. Your report should include a list of references used in the essay and a bibliography of the wider reading you have done to familiarize yourself on the topic.  A passing grade will be awarded to assignments adequately addressing all assessment criteria. Higher grades require better quality and more effort. For example, a minimum is set on the wider reading required. A student reading vastly more than this minimum will be better prepared to discuss the issues in depth and consequently their report is likely to be of a higher quality. So before submitting, please read through the assessment criteria very carefully.

6 of 9

ITECH1103- Big Data and Analytics Assignment 1- Data Analysis- Marking Scheme                   Percentage 20% Due Week 11 (Friday 5pm) – Hard and Soft Copies

Tasks Max Mark

Mark Award ed

Comments

1- Background of the Project: Description of the Project and Dataset. The importance of the project for understanding and improving energy efficiency and future demand. [1.5+1.5+2] 

5

2- Dashboard/Reports The BI reporting solution/dashboards you needed to develop for the stakeholders given y our previous data analysis The solution and dash board should be shown in terms of answering the given 18 questions, finding new questions, and finally answering the 2 main questions. [Marks will be given for the quality and complexity of the analysis]

20

3- Research – Justify why these BI reporting solution/dashboards are chosen and why those attributes 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; you can use the ‘Snipping tool’), and also include any assumptions that you may have made about the analysis in your assignment report (i.e. the report to the stakeholders of the project). [Each analysis/dashboard and report explanation with relevant research papers, complexity and in-depth of the justification, use of peer-reviewed sources]

10

7 of 9

4- Recommendations – Justify the answers to the two main questions, and show where power consumption efficiencies could be made; and what would be likely future power demand trends. Based on your BI analysis and the insights gained from the “Data Set” given the analysis performed in the previous tasks, highlight where these power efficiencies can be made, and attempt to predict future power trends. Give 2 possible scenarios. If you have made a predictive model, show which features and measurements lead to power reductions/increases, to add to your logical recommendations. [Key data insights, recommendations, with theoretical justifications and proper references. [4+4+2]

10

5- The Reflection: Each Team member is expected to write a brief reflection about this project in terms of challenges, learning and contribution. 

5

6- Report well-written and presented professionally, containing:  Title page  Table of Contents  Brief Introduction  Appropriate use of figures (i.e. graphs, summary tables) and reference to calculations and summaries to justify all observations and recommendations  Overall structure, presentation and formatting. Note that the report has to be presented formally. It must include discussion of calculations, observations and recommendations with graphs and/or tables. 

1 1 2 1 2

3

(10) Total Marks 60 Total Marks out of 20 20%

You MUST produce the actual visuals in Watson using the sample dataset. If you think the best presentation above is to use, say, only a pie chart, then discuss using a pie chart and indicate what the pie chart would show, why you picked the pie chart, and so on. It may be useful to try with various BI reporting/dashboards/presentations before rushing to that conclusion.

8 of 9

ITECH1103- Big Data and Analytics Assignment 1- Data Analysis Presentation- Marking Scheme Worth 10% Due Week 10 (Scheduled Tutorial) – Hard and Soft Copies

Students are expected to create and present a 10-15 minute overview of the findings from their Team Report.

Student IDs:

Assessment Criteria:

Criteria Marks Introduction /1

Content /4

Conclusion /1

Presentation Style e.g. clarity, engagement /2

Team participation /1

Timing (10-15 minutes) /1

SubTotal- /10 General Comments:

9 of 9