hello,please find the below attached file. make the solution choosing a data set which have 100000 rows a mentioned in the assignment. follow the marking criteria and the assignment requirements
Page 1 of 5 ITECH7407- Real Time Analytic Data Analytics Assignment – 2019 Worth – 20% ANALYTIC REPORT This is a business analytics project aimed at generating innovative analytics solutions for a Company. The objective is to analyze the given datasets from a relevant firm’s perspective in terms of implications and strategies which the chosen company could adopt to improve its functions, resources and processes efficiently and effectively. Project You are expected to work in groups to find a dataset with minimum of 10,000 rows from publicly available sources. You also need to hypothetically identify a company (chosen company) who could get benefits from the analysis of the dataset. You are expected to discuss the selected dataset with your tutor in labs by Week 7. Please click on the sources below to access some option to obtain open data: 1. World Bank Open Data 2. WHO (World Health Organization) — Open data repository 3. Google Public Data Explorer 4. Registry of Open Data on AWS (RODA) 5. European Union Open Data Portal 6. FiveThirtyEight 7. U.S. Census Bureau 8. Data.gov 9. UNICEF Dataset 10. DBpedia 11. freeCodeCamp Open Data 12. Australian Govt Data Your task is to complete the following tasks: Task 1- Background information Write a description of the selected dataset and project, and its importance for your chosen company. Information must be appropriately referenced. [1 Page] Task 2- Create Data View/Cube - Data Modelling and Provisioning Upon selecting the dataset, convert the dataset into HANA data cube/view by following the SAP HANA data modeling and provisioning technique https://data.worldbank.org/ https://www.who.int/gho/database/en/ https://www.google.com/publicdata/directory https://registry.opendata.aws/ http://open-data.europa.eu/en/data/ https://data.fivethirtyeight.com/ http://www.census.gov/data.html https://www.data.gov/ https://data.unicef.org/ https://wiki.dbpedia.org/ https://github.com/freeCodeCamp/open-data https://data.gov.au/ Page 2 of 5 using SAP HANA Web-based development workbench. The name of the cube/view should be the student ID of one of the group members. Task 3 – Perform Data Mining on data view For your project, perform the relevant data analysis tasks on data view/cube (created in Task 2) using data mining techniques such as classification/association/time series/clustering and identify the BI reporting solution and/or dashboards you need to develop for the operational manager of the chosen company. [2-3 Pages] Task 4 – Research Justify why you chose thee BI reporting solution/dashboards/data mining technique in Task 3 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 from Task 3. [1-2 Pages] Task 5 – Recommendations for CEO The CEO of the chosen company would like to improve their operations. Based on your BI analysis and the insights gained from your “Dataset” in the lights of analysis performed in previous tasks, make some logical recommendations to the CEO, and justify why/how your proposal could assist in achieving operational/strategic objectives with the help of appropriate references from peer-reviewed sources. [2-3 Pages]. Task 6 – Cover letter Write a cover letter to the CEO of the chosen firm with the important data insights and recommendations to achieve operational/strategic objectives [1 page] Other Tasks – Please refer to the marking scheme at the end of the assignment for other tasks and expectations. Report Submission: • A maximum of 3 people in a group. • Check your assignment for plagiarism in turnitin software. Please attach a turnitin report along with your assignment. An assignment without a turnitin report will not be accepted. Page 3 of 5 • Submit a hard-copy to tutors/lecturers assignment box in week 10. Double- sided printing for the hard-copy is encouraged in order to save paper. • You will also submit a 9-10 pages report (about 3000 words) not counting cover page, references and Appendix) 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 a formal report structure with cover page, introduction, use of headings, subheadings, conclusion sand reference section. http://owl.english.purdue.edu/owl/resource/560/01 http://www.apastyle.org/ Page 4 of 5 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 1- Background of the Project: Description of Project, Datasets and firm. The important of project for the firm [1+1+1+2] 5 2- Create Data View/Cube - Data Modelling and Provision – List the various steps with the help of screenshots, necessary in your modelling and provisioning process of the selected dataset to create data cube/view. The data view/cube should be named with a studentID 25 3- Perform Data Mining Technique/s : Perform various analysis using SAP expert analysis on your created data view cube - [Quality and complexity of the analysis – association/classification/clustering/time series models, dashboard designing and relevance for the project] 25 4- 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 the operational team of the company). [Each analysis/dashboard and report explanation with relevant research papers, complexity and in- depth of the justification, use of peer-reviewed sources] (20 for basic and 5 for advanced) 15 5- Recommendations - The CEO of the chosen firm would like to improve the operations. Based on your BI analysis and the insights 10 Page 5 of 5 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] 6- Cover letter (Format, key findings and recommendation ) [1+1+3] 5 7- 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 2 2 1 2 2 5 Total Marks 100 Total Marks out of 20 20% You MUST produce the actual visuals in SAP Tools i.e Lumira & Expert Analysis 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. ITECH7407- Real Time Analytic Data Analytics Assignment – 2019 Worth – 20% ANALYTIC REPORT Project 1. World Bank Open Data 2. WHO (World Health Organization) — Open data repository 3. Google Public Data Explorer 4. Registry of Open Data on AWS (RODA) 5. European Union Open Data Portal 6. FiveThirtyEight 7. U.S. Census Bureau 8. Data.gov 9. UNICEF Dataset 10. DBpedia 11. freeCodeCamp Open Data Report Submission: ITECH7407- Real-Time Analytics Assignment 1- Data Analysis- Marking Scheme Percentage 20% Due Week 11 (Friday 5pm) – Hard and Soft Copies