ITECH7407-RealTimeAnalytic Individual assignment–2017 Worth– 20% ANALYTIC REPORT This is a business analytics project aimed at generating innovative analytic solutions for an Australian firm (i.e. Agriculture firm)by selecting one of the three projects. The objective is to analyze the given datasets from relevantfirm’s perspective in terms of implications, different phenomenon such as rainfall, solar exposure and sunspots may have for the chosen firm to achieve both operational and strategic objectives. This activity will give students the opportunity to show innovation and creativity in applying Watson Analytics/SAPBusinessObject/PredictiveAnalytics/HANA and designing useful visualization solutions and predictive models for different types of analytics problems. Students are expected to use one of the following project to make recommendation for an Australian firm such as agriculture firms or the other (Please consult with your lecturer). The list of Australian firm can be found from following link http://www.manta.com/world/Oceania/Australia/ Your task is to select one onlyof the below projects, and complete the following tasks: Task 1- Background information Write a descriptionof the selecteddatasetand project,and its importance forthe chosen firm. Information must be appropriately referenced. [1 Page] Task 2 – Reporting / Dashboards For your selected project, perform the relevant data analysis tasks listed under your selected project and identify the BI reporting solution and/or dashboards you need to develop for the operational manager of the indicated firm. [2-3 Pages] Task 3 – Research Justify why these BI reporting solution/dashboards are chosen in Task 2(Reporting / Dashboards) and why those data sets 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; use ‘Snipping tool’), and also include any assumptions that you may have made about the analysis in your Task2 (i.e. the report to the operational team of the company). [3-4 Pages] Task4 – Recommendations for CEO The CEO of the chosen firm would like to improve the operations. Based on your BI analysis and the insights gained from “Data Set” in the lights of analysis performed in previous tasks, make some logical recommendations to the CEO, and justify why/how your proposal could enhance company operations and could assist in achieving operational/strategic objectives with the help of appropriate references from peer-reviewedsources. [2-3 Pages] Task 5 – Cover letter Write a cover letter to the CEO of the chosen firm with the important data insights and recommendation to achieve operational/strategic objectives [1 page] Other Tasks – Please refer to marking scheme at the end of the assignment for other tasks and expectations. Project 1 Modelling monthly sunspot numbers Sunspots are the temporary phenomenon generated by strong magnetic fields emanating from the interior of the Sun. Sunspot activity cycles about every 11 years and can be visible as back flecks on the surface of the Sun. Peak solar activity is often marked by mass ejection of intense high-energy radiation from the sun’s surface called solar flares. Solar flares are known to have several impacts on earth, including their impact on satellite communication and radio transmission. Predicting solar activity is therefore of paramount importance. Relevant data analysis tasks are to: ⦁ Explore the monthly solar activity data available at http://sidc.oma.be/silso/datafiles, ⦁ Determine different trends and patterns ⦁ Develop a model to predict solar activity up to 12 months in advance and its implications for the firm you have chosen. Project 2 Modelling mean monthly solar exposure There is a growing interest in improving the knowledge of the relationship between sustainable urban development and local climatic conditions. In particular, such knowledge can be very useful to urban planners and bio meteorologists for the design of sustainable buildings and green landscapes to minimize energy consumption, and potentially mitigate the Urban Heat Island intensity and effects. Solar radiation exposure is one of the main factors driving changes in various surface processes on earth, including local changes in the near-surface air temperature. Knowledge and understanding of the influence of solar radiation exposure on maximum temperature, for example, can be very useful for sustainable planning of an urban environment. Relevant data analysis tasks are to: ⦁ Explore the monthly solar exposure for Ballarat Aerodrome (or any other Australian location of your interest); data available at ⦁ http://www.bom.gov.au/climate/data/. ⦁ Determine different trends and patterns Project 3 Modelling mean monthly rainfall variability Rainfall variability and trends is widely known to be impacted by climate change in various parts of Australia and globally. Such changes will have dire consequences in various socio-economic sectors such as agriculture firms. Please chose one of such examples and design analytical solutions. In this project, your data analysis tasks are to: ⦁ Explore the monthly rainfall data for Ballarat (or any other Australian location of your interest); data available at ⦁ http://www.bom.gov.au/climate/data/. ⦁ Determine different trends and patterns ⦁ Develop a model to predict rainfall up to 12 months in advance Report Submission: ⦁ Hard-copy to tutors/lecturersassignment box in week 10.Double-sidedprintingfor thehard-copy is encouraged in order to savepaper. ⦁ Youwillalsosubmita9-10pagesreport(about3000wordsnotcountingcoverpageandreferences)ofthisproject.Atleast15referencesin yourreportmustbefrompeer-reviewedsources.Includeanyandallsourcesofinformationincludinganyperson(s)youinterviewed forthis project. ⦁ PleasenotethatallreferencesmustadheretoAPAstyle.Seehttp://owl.english.purdue.edu/owl/resource/560/01andhttp://www.apastyle.org/fordetailsonhowtoformatareportandhowtocitereferences.Makesureyourfollowformalreportstructurewithcoverpage, introduction, useofheadings, subheadings, conclusions and 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/generalguide/print/ch06s04.shtmlor 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. ITECH7407- Real-Time Analytics Assignment 1- Data Analysis- Marking Scheme Percentage 20% Due Week 11 (Friday 5pm) – Hard and Soft Copies Tasks Max Marks Marks Awarded Comments ⦁ Background of the Project: Description of Project, Datasets and firm. The important of project for the firm [1+1+1+2] 5 ⦁ Dashboard/ReportsWhat are the BI reporting solution/dashboards you will need to develop for operational manager of chosen in the light of Task/s of your Data analysis - [Quality and complexity of the analysis –descriptive/predictive/prescriptive models, dashboard designing and relevance for the project] 10 ⦁ 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; use ‘Snipping tool’), and also include any assumptions that you may have made about the analysis in your assignment report (i.e. the report to theoperational team of the company). [Each analysis/dashboard and report explanation with relevant research papers, complexity and in-depth of the justification, use of peer-reviewedsources] 10 ⦁ Recommendations - The CEO of the chosen firm would like to improve the operations. Based on your BI analysis and the insights gained from “Data Set” in the lights of analysis performed in previous tasks, make some logical recommendations to the CEO, and justify why/how your proposal could enhance company operations and could assist in achieving operational/strategic objectives. [Key data insights, recommendations to achieve organisational objectives with theoretical justifications with proper references. [2+3+5] 10 ⦁ Cover letter (Format, key findings and recommendation ) [1+1+1] 3 ⦁ Other Tasks Report is well-written and presented professionally, containing: Title page Table of Contents ⦁ Introduction Appropriate use of headings within report 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 1 2 4 Total Marks 50 Total Marks out of 20 20% You MUST produce the actual visuals in IBM Cognos/SAP Tools and/or 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 conclusion.