Microsoft Word - ITECH1103 Analytic Group Presentation - Semester XXXXXXXXXXdocx Weight – 10% Due Date: Presentation – Week 11 during lab/tutorial time Group Presentation: Learning Outcomes Assessed:...

1 answer below »
See the atached files


Microsoft Word - ITECH1103 Analytic Group Presentation - Semester 2 2019.docx Weight – 10% Due Date: Presentation – Week 11 during lab/tutorial time Group Presentation: Learning Outcomes Assessed: K4, A1, 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: All members of the team are to work together to present their findings and recommendations developed whilst completing the analysis of the data. The presentation should include a visual component, such as Power Point, to support the delivery of their findings. Requirements □ Presentations are to be between 10 to12 minutes in length □ Each team member must present for at least three minutes to verbally present some of the findings from the report □ Teams must provide one visual component (e.g. Power Point) that is consistent in presentation, fonts and format □ Any references used in your presentation must be included at the end of the presentation in APA format (see below). □ The presentation must include: o An introduction of the topic and team members o The findings made from the analysis of the data including images to support these findings o The recommendations you will make in your report o A conclusion Submission and Marking □ Each member of the group is to submit an electronic copy of the completed group presentation material via Moodle. □ All references are to be provided using the APA format; information for this is available here: o https://federation.edu.au/library/student-resources/help-with-study-skills2/guides-to-your- assessments □ You will be marked according to the marking rubric provided in this document. Those items with a * will be a group mark (i.e. all member of the group who are present will get the same mark), whilst the remaining will be individual marks. ITECH1103- Big Data and Analytics Group Presentation – Semester 3, 2019 CRICOS Provider No. 00103D ITECH 1103 Group Presentation Semester 3 2019 Page 1 of 2 ITECH1103- Big Data and Analytics - Assignment 2- Data Analysis- Presentation Marking Rubric Full marks ¾ marks ½ marks ¼ Marks Mark Presentation Material [2 marks] There are no errors in spelling, grammar and punctuation. Information is clear and concise on each slide. Visually appealing/engaging. There are some errors in spelling, grammar and punctuation. Too much information on two or more slides. Significant visual appeal. There are many errors in spelling, grammar and punctuation. Too much information was contained on many slides. Minimal effort made to make slides appealing or too much going on. There are many errors in spelling, grammar and punctuation. The slides were difficult to read and too much information had been copied onto them. No visual appeal. Knowledge of topic [ 7 marks] Extensive knowledge of topic. Members showed complete understanding of assignment. Accurately answered all questions posed. Most showed a good understanding of topic. All members able to answer most of audience questions. Few members showed good understanding of some parts of topic. Only some members accurately answered questions. Presenters didn’t understand topic. Majority of questions answered by only one member or majority of information incorrect. Presentation Skills [ 7 marks] Regular/constant eye contact, The audience was engaged, and presenters held the audience’s attention. Appropriate speaking volume & body language. Most members spoke to majority of audience; steady eye contact. The audience was engaged by the presentation. Majority of presenters spoke at a suitable volume. Some fidgeting by member(s). Members focused on only part of audience. Sporadic eye contact by more than one presenter. The audience was distracted. Speakers could be heard by only half of the audience. Body language was distracting. Minimal eye contact by more than one member focusing on small part of audience. The audience was not engaged. Majority of presenters spoke too quickly or quietly making it difficult to understand. Inappropriate/disinterested body language. Content [2 marks] The presentation was a concise summary of the topic with all questions answered. Comprehensive and complete coverage of information. The presentation was a good summary of the topic. Most important information covered; little irrelevant info. The presentation was informative, but several elements went unanswered. Much of the information irrelevant; coverage of some of major points. The presentation was a brief look at the topic, but many questions were left unanswered. Majority of information irrelevant and significant points left out. Group marks [ 2 marks] All presenters knew the information, participated equally, and helped each other as needed. Extremely prepared and rehearsed. Slight domination of one presenter. Members helped each other. Very well prepared. Significant controlling by some members with one minimally contributing. Primarily prepared but with some dependence on just reading off slides. Unbalanced presentation or tension resulting from over-helping. Multiple group members not participating. Evident lack of preparation/rehearsal. Dependence on slides. Total /20 /10 General Comments/Feedback: CRICOS Provider No. 00103D ITECH 1103 Group Presentation Semester 3 2019 Page 2 of 2 Page 1 of 4 CRICOS Provider No. 00103D ITECH 1103 Group Report Semester 3 2019 ITECH1103- Big Data and Analytics Group Assignment – Semester 3, 2019-20 (Summer Semester) Weight – 20% Due Date: Analytic Report - Fri, Jan 31, 2020 - 23:59 Analytic Report: Learning Outcomes Assessed: A3, K3, K6, and S2: Purpose: 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 chosen/given dataset. 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. Project Details: This is a group assignment and you will complete the task with your team. Your team will be made up of at most 3 members who are all enrolled in the same laboratory – the teams will be allocated by your tutor. It is expected that each team member will contribute equally to the project. Your team will use SAS Visual Analytics to explore, analyze and visualize the dataset provided. You will receive feedback on the draft about presentation choices, content, analysis, and 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 a Retail Company. In addition, each individual team member will write a short reflection as part of the report on their individual experience on working on the project. 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 (2 per student) 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 that each student will provide at least two other visualizations of the data (i.e. for a group of 3 students this is 6 extra visualizations). 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. [3 to 4 pages] • Task 6 – Executive Summary – summary of the data analysis including a brief introduction, methods used and Page 2 of 4 CRICOS Provider No. 00103D ITECH 1103 Group Report Semester 3 2019 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] Report Submission: Each member of the group is to submit an electronic copy of the completed group assignment and their own individual reflection via Moodle. The report will be approximately 8 to 12 pages in length (not counting cover page and references). The report will include the following in the order provided below: • A cover page including the names and student id of all team members • Table of Contents • Table of Figures / Tables • Executive Summary • Background • The body of
Answered Same DayJan 16, 2021ITECH1103

Answer To: Microsoft Word - ITECH1103 Analytic Group Presentation - Semester XXXXXXXXXXdocx Weight – 10% Due...

Pooja answered on Jan 28 2021
142 Votes
customer data
Table of Contents
Executive Summary    3
Background information    4
Analysis    5
1)    Data dictionary    5
2) Number of Customers    6
3) Customers and countries    7
4) Country and Revenue    7
5) Customers and total revenue    8
6) days to place and order    9
7) Customer type and quantity ordered    10
8) Customer type and quantity ordered    11
9) top 5 countries with respect to each customer type    12
10) customer type and continent by quantity ordered    13
11) Title    14
12) Days of Delivery    14
13) Most efficient predictor of Quantity ordered    15
14) country of customer    16
15) Cluster Analysis for Quantity ordered on basis of Customer Type    16
16) Days to delivery for each continent type by customer type.    16
17) days to delivery by customer type name    18
18) days to deliver & number of orders by order type    18
19) cost, days t
o deliver and discount percent    19
20) customer type with unit cost and quantity ordered    19
Discussion of findings    20
2) Number of Customers    20
3) Customers and countries    20
4) Country and Revenue    20
5) Customers and total revenue    20
6) days to place an order    20
7) Customer and quantity ordered    21
8) Customer type and quantity ordered    21
9) top 5 countries with respect to each customer type    21
10) customer type and continent by the quantity ordered    21
11) Title    22
12) Days of Delivery    22
13) Most efficient predictor of Quantity ordered    22
14) country of the customer    22
15) Cluster Analysis for Quantity ordered on basis of Customer Type    22
16) Days to delivery for each continent type by customer type.    22
17) days to delivery by customer type name    22
18) days to deliver & number of orders by order type    23
19) cost, days to deliver and discount percent    23
20) customer type with unit cost and quantity ordered    23
Conclusion    23
Reflection    24
References    25
Figure 1    5
Figure 2    6
Figure 3    7
Figure 4    8
Figure 5    9
Figure 6    10
Figure 7    11
Figure 8    12
Figure 9    13
Figure 10    13
Figure 11    14
Figure 12    15
Figure 13    15
Figure 14    16
Figure 15    17
Figure 16    17
Figure 17    18
Figure 18    18
Figure 19    19
Table 1    5
Table 2    6
Table 3    6
Table 4    8
Table 5    9
Table 6    9
Table 7    10
Table 8    11
Table 9    12
Table 10    13
Table 11    14
Table 12    17
Executive Summary
There is a total of 9,51,669 customers. The top country with highest total of the retail price is the United States with a total retail price $3,29,01,896. The top customers with the highest retail price are Michael and David have a retail price of $8,79,353 and $8,24,643 respectively.
On February 28, 2014, and December 19, 2016, the highest number of orders were placed corresponding to 1096 and 1,003 orders. The customers David, Michael, and John have the highest quantity ordered with a value of 10600, 10192, and 10000. The highest Quantity Ordered corresponds to customer type Orion Club Gold members high activity, Orion Club Gold members medium activity, and Orion Club members high activity. For all customers type, the top 5 countries include the United States and Germany. The maximum ordered quantity was received from Europe. The cities Madrid, London, Paris, and Milano have maximum days of delivery corresponding to 51587, 35916, 34602, and 18148 respectively.
The maximum number of customers belongs to the United States. The days to delivery are the highest by Europe for customer type Internet/Catalog Customers. The top 3 customer type receiving fastest delivery are Orion Club members low activity, Orion Club Gold members low activity, and Orion Club members medium activity.
The maximum number of order type corresponds to retail sale. There is a weak linear relationship between (cost, days to deliver) and (discount percentage, days to deliver). As the value of cost increases the value of quantity ordered also increases.
Background information
Companies need people who know how to use data to understand their customer’s needs. Once they understand their needs, they can provide the products customers want to buy. A good understanding of customers is extremely important for running a successful business.
KYC or ‘know your customer’ is what actually makes all the difference for many companies. Customer Analytics is a very broad area. this includes characteristics of customers and their behaviour and numerous different. Outcomes and performance indicators that the business might be interested in. The segmentation, targeting, and positioning is called as ‘S T P framework’ which can be applied to all areas of business. Grljević, O., & Bošnjak, Z. (2018).
An article was published in the name of “Customer Classification of Discrete Data Concerning Customer Assets Based on Data Mining” which was written by Lei Zuo and Junfeng Guo. In this study, a customer classification model based on outlier data analysis concerning customer asset was performed. The 4 dimensions were transaction frequency, types of products or services traded, transaction amount and client age. the aim was to divide twenty-five types of outlier customer data into four categories. Various marketing strategies were also applied here. Zuo, L., & Guo, J. (2019, January).
Analysis
1) Data dictionary
The dataset has 22 columns and a total of 951.7K rows. The categorical variables are listed as
· City Name
· Continent Name
· Customer Birth Date
· Customer Country
· Customer Group Name
· Customer ID
· Customer Type Name
· Customer First name
· Customer Last name
· Date order was delivered
· date order was placed
· Order ID
· Order Type
· Postal code
· State name
· Title
The continuous variables are listed as
· Cost
· Days to delivery
· Discount in percent of Normal total retail price
· Frequency
· Profit
· Quantity ordered
· Retail price
· Frequency percent
2) Number of Customers
Table 1
    Customer Group Name
    Frequency
    Internet/Catalog Customers
    76,965
    Orion Club Gold members
    4,83,438
    Orion Club members
    3,91,266
    
    Count: 9,51,669
Figure 1
    Customer Type Name
    Frequency
    Orion Club Gold members high activity
    2,23,488
    Orion Club Gold members medium activity
    1,60,666
    Orion Club members high activity
    1,60,304
    Orion Club members medium activity
    1,28,241
    Orion Club members low activity
    1,02,721
    Orion Club Gold members low activity
    99,284
    Internet/Catalog Customers
    76,965
3) Customers and countries
Table 2
    Customer_FirstName
    Frequency
    Antonio
    2,581
    Barbara
    2,480
    Andrea
    2,329
    Alain
    1,921
    Andrew
    1,888
    Ana
    1,731
    Anne
    1,490
    Andreas
    1,485
    Alberto
    1,433
    Anna
    1,380
    Angela
    1,075
    Alan
    1,065
Figure 2
4) Country and Revenue
Table 3
    Customer Country
    Retail Price
    
    $13,31,96,488.48
    United States
    $3,29,01,896.80
    Germany
    $1,97,60,678.03
    France
    $1,47,01,399.68
    Italy
    $1,45,25,623.82
    United Kingdom
    $1,31,75,549.39
    Spain
    $1,22,33,250.16
    Netherlands
    $95,49,237.18
    Australia
    $78,94,103.00
    Belgium
    $31,37,551.64
    Denmark
    $24,62,872.19
Figure 3
5) Customers and total revenue
Table 4
    Customer_FirstName
    Retail Price
    Michael
    $8,79,353.92
    David
    $8,24,643.56
    John
    $7,94,653.59
    Robert
    $6,94,692.47
    Peter
    $6,48,676.25
    James
    $5,76,694.37
    Thomas
    $5,71,126.76
    Paul
    $4,89,962.85
    William
    $4,49,091.91
    Christine
    $4,12,559.50
Figure 4
6) days to place and order
Table 5
    Date Order was placed by Customer
    Frequency
    February 28, 2014
    1,096
    December 19, 2016
    1,003
    December 06, 2016
    998
    December 13, 2016
    931
    December 27, 2016
    926
    December 12, 2016
    914
    December 26, 2016
    912
    December 20, 2016
    899
    December 05, 2016
    884
    December 16, 2016
    876
    December 02, 2016
    872
    November 01, 2016
    857
    August 09, 2016
    855
    July 26, 2016
    854
    December 08, 2016
    853
    December 18, 2016
    849
    July 08, 2014
    843
    December 01, 2016
    839
    December 15, 2016
    836
    December 03, 2016
    835
Figure 5
7) Customer type and quantity ordered
Table 6
    Customer_FirstName
    Quantity Ordered
    David
    10,600
    Michael
    10,192
    John
    10,000
    Robert
    8,427
    Peter
    7,668
    Elfonza
    1
    Elery
    1
    Elainna
    1
    Kinta
    1
    Kimyen
    1
    Kimlie
    1
    Effy
    1
Figure 6
8) Customer type and quantity ordered
Table 7
    Customer Type Name
    Quantity Ordered
    Orion Club Gold members high activity
    3,73,905
    Orion Club Gold members...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here