Analytics Report | My Assignment Tutor

CRICOS Provider No. 00103DRTO Code 4909Assignment 2: Analytics Report Overview The purpose of this task is to provide students with practical experience in working in teams to write a data analytical report to provide useful insights, pattern and trends in the BANK_CUSTOMERS in the light of guided questions asked within this document on page 6. This dataset is located in SAS Viya archives of datasets. This activity will give students the opportunity to show innovation and creativity in applying SAS Analytics, and designing useful visualization and predictive solutions for various analytics problems. Timelines and Expectations Percentage Value of Task: 35%Due: Please check Couse DescriptionMinimum time expectation: Preparation for this task will take approximately 20 hoursWork – Individual Project Details You will use an analytical tool (i.e SAS Visual Analytics) to explore, analyse and visualize the dataset provided [Appendix 1: Guided Questions on page 6]. An important part of this work is preparing a good quality report, which details your choices, content, and analysis, and is of an appropriate style. The aim is to use the data set allocated to provide interesting insights, trends and patterns amongst the data. Your intended audience is the CEO and middle management of the Multinational Retail Company, who are responsible for overseeing the retails industry worldwide. Tasks Task 1- Background information – Write a description of the dataset and project, and its importance for the organization. Discuss the main benefits of using visual analytics to explore big data. In this you should include a justification for using the visualizations that you will use and how they have been successful in other similar projects. This discussion should be suitable for a general audience. Information must come from at least 6 appropriate sources be appropriately referenced. [2 to 3 pages] Task 2 – Reporting / Dashboards – For your project, perform the relevant data analysis tasks by answering the guided questions provided (see Appendix for questions and dataset) and, identify the visualization you need to develop. Note: remove any missing data points from your visualizations where possible/suitable Task 3 – Additional Visualizations – In addition to the guided questions, it is expected thatstudent will provide at least two other visualizations of the data. These additional visualizations will be judged in terms of quality of the findings and complexity of analysis. These visualizations should be using multi-dimensional, filtering and advance calculation techniques. Task 4 – Justification -Justify why these visualizations are chosen in Task 2 and 3. 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 Task 2 (i.e. the report to the operational team of the company).[1 to 2 pages] Task 5 – Discussion of findings – using the visualizations created discuss the findings from the data set. In this discussion you should explain what each visualization shows. Then summarize the main findings. [1 to 2 pages] Task 6 – Executive Summary – summary of the data analysis including a brief introduction, methods used and a list of the key findings [1 page only] Task 7 – The Reflection (Individual Task) – each team member is expected to write a brief reflection about this project in terms of challenges, learning and contribution. [1 to 2 pages] Submission The assignment is to be submitted via the Assignment 1 submission box in Moodle. This can be found in the Assessments section of the course Moodle shell. Your report file will be submitted as either a MS word file or a PDF. If you are using MacOS, please submit as a PDF. Your report will be approximately 8 to 12 pages in length (not including cover page and references). The report will include the following in the order provided below: A cover page with your names and student IDTable of ContentsTable of Figures / TablesExecutive SummaryBackgroundThe body of the report including reports, insights, justifications and visualsDiscussion of findingsConclusionReferencesAppendices All references used in your report must be from peer-reviewed sources. Include any and all sources of information including any person(s)n you interviewed for this project. Your report should be formatted according to the “Assignment Layout and Appearance Guidelines” and your references presented using the APA referencing style; information is available: You are reminded to read the “Plagiarism” section of the course description. 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. Marking Criteria/Rubric TasksMarksAwardedComments1 – Background of the Project: Description of Project, Datasets and organisation. The importance of project for the organisation. Benefits and examples provided for the use of data visualization using peer reviewed sources.102 – Dashboard/Reports utilization of appropriate data analysis tools, visualizations and dashboards developed for the report403 – Additional Visualizations The quality and complexity of additional visualizations provided other than the guided questions.104 – Justification – Each analysis/dashboard and report explanation with relevant research papers, complexity and in-depth of the justification.55 – Discussion of findings – Key data insights, recommendations to achieve organisational objectives with theoretical justifications with proper references.156- Executive summary – Format, key findings and Recommendation.10Presentation of Report – Report is well-written and presented professionally, containing all requirements10Total Marks100Total Marks out of 3535% Feedback Feedback and marks will be provided in Moodle. Marks will also be available in FDL Marks. Plagiarism Plagiarism is the presentation of the expressed thought or work of another person as though it is one’s own without properly acknowledging that person. You must not allow other students to copy your work and must take care to safeguard against this happening. More information about the plagiarism policy and procedure for the university can be found at refer to the Course Description for information regarding late assignments, extensions, and special consideration. A reminder all academic regulations can be accessed via the university’s website, see: Appendix 1: Guided Questions -CHOOSE ANY 5 OF THESE TO IMPLEMENT (worth 8 marks each) Data set – SAS Viya Data Source – BANK_CUSTOMERS (20 columns, 483 rows, size 143.KB) You are required to select a minimum of 2 questions from each pool, and total of 5 questions. Question 1 is compulsory. Pool A Create a data dictionary for the data source.What are the top and bottom 5 counties with respect to number of customers?What is the distribution of gender in each occupation?How many customers have saving, chk and MM accounts?With respect to Question 2, how many customers are full time and part time in each account type?How many customers both full and part time with MM account are having C lifestyle?What is the highest and lowest profession with respect to occupation?Which occupation have highest and lowest number of people renting and owning? Pool B Provide the list of top 10 customers with respect to income with their account number, name and income.Provide the list various occupations along with their income, job status and lifestyle in state of California.What is the trend open date in terms of yearly quarter from 2001 to 2011? (Year Quarter should be displayed as “1st Quarter 2001”).Display the name/ss and HH_Income of customer/s living in Honolulu, female, lifestyle C and working in finance occupation.Provide the list of bottoms 5 customers with respect to income with their account number, name and income.What is the highest and lower paid occupation and the relevant lifestyle in each of the account type?What is the frequency of job status with respect to gender?


Leave a Reply

Your email address will not be published. Required fields are marked *