ISSS602 Data代写、帮做QVC数据、Data代做、IDEA数据分子代做代写

日期：2018-09-30 05:43

SMU Classification: Restricted

ISSS602 Data Analytics Lab

Assignment 1: Show Me the Numbers

Setting the Scene

QVC (an acronym for "Quality Value Convenience") is an American cable, satellite and

broadcast television network, and flagship shopping channel specializing in televised home

shopping that is owned by Qurate Retail Group. Founded in 1986 by Joseph Segel in West

Chester, Pennsylvania, United States, QVC broadcasts to more than 350 million households in

seven countries as QVC US, QVC UK, QVC Germany, QVC Japan, QVC Italy, QVC/CNR (China) and

QVC France (https://en.wikipedia.org/wiki/QVC).

QVC provides its customers with a variety of product offerings around the globe. The largest

market for QVC is currently the US. In the US alone, QVC ships millions of packages each year

to enrich its customers’ lives. The future of fulfilling customer orders and meeting or exceeding

their expectations is always at the forefront of QVC’s decisions. One expectation is related to

delivery speed. Some retailers, primarily online retailers, focus primarily on quick turnaround

on shipping goods to customers. The faster the turnaround the more extensive the

logistics/delivery network or the more costly it is. QVC doesn’t just provide its customers with

products, it prides itself on top notch customer service and a rich and rewarding overall

experience (http://sc.aisnet.org/conference2018/student-competitions/qvc-challenge/)

The Task

In this assignment, you are tasked to employ Interactive Data Exploration and Analysis (IDEA)

approach to discover as many interesting or/and un-known understanding from the first six

months 2016 data. Your challenge is to analyze QVC’s customer geography, distribution

network, and product mix, purchase patterns and develop a data discovery report that contains

useful information for QVC to use to understand, among many others, what the relationship

between speed of product/package delivery and customer loyalty is.

Your analysis should address, among many other, of the following questions:

Does the current distribution network maximize customer penetration (spend) If not,

what should QVC do to increase customer penetration with the current distribution

network?

Are there specific products or product categories that should be located in specific

distribution centers?

SMU Classification: Restricted

Do customers that receive their product sooner purchase more than customers with

longer delivery times?

The Data

This data is extracted and anonymized from QVC.

There are two options for using the data. Those with experience and the technology needed to

work with a large data set should choose option 2 below. Those that are working just in excel

should chose option 1 below.

1. A sample population was pulled from the larger data set and placed into the excel

spreadsheet named “Smaller Sample set of QVC data”.

2. The large data set was broken up into six excel spreadsheets (named QVC data 1, 2, 3,

etc) with less than 1 million rows each. You may combine these spreadsheets and do

your analysis on the larger set if you have the technology needed to do so.

There are also excel spreadsheet with the following information in them which applies to

option 1 and 2 above:

distribution center data

order type data

data dictionary

QVC Data & Metadata Information (https://drive.google.com/drive/folders/1dkaoFlkhoogmTC0E9UCdShoWAYVXKYW).

Scope of work

The specific scope of work of this assignment are as follows:

1. Data preparation:

a. Identify at least ten major data quality issues from the data sets give. You are

required to provide a comprehensive discussion on the data issues identified

b. Prepare the final data analytical sandbox using appropriate data wrangling

techniques.

2. Data analysis:

a. Discover at least ten major insights from the analytics sandbox by using

appropriate IDEA techniques.

b. Perform appropriate confirmative analysis to validate the exploratory data

analysis results.

3. Interpretation of analysis results:

SMU Classification: Restricted

a. Relate and discuss the results of the analysis in providing valuable understanding

to the questions provide at The Task section.

4. Managerial Communication

a. Prepare an executive summary for senior management consumption.

Deliverables

An executive summary in MS PowerPoint format.

o The executive report should not be more than ten slides, inclusive of cover-page

and content page.

o It should comprise of both the major findings and managerial recommendations.

o The discussions should be in bullet point format.

o The font size of the bullet point should not be less than 24 points.

A technical report of not more than 3000 words in Microsoft Word format (12 points for

main text) with the following contents:

o A detailed description of the data preparation.

o A detailed description of the analysis procedures used.

o A clear discussion and interpretation of the analysis results.

 An analytical sandbox in JMP file format.

Submission Instruction

The executive summary, technical report and analytical sandbox are to be submitted in

softcopy. You are required to upload the final deliverable into the Dropbox of LMS

before the stated assignment due date. Late work will be severely penalised. Students

must check and confirm on LMS the assignment due date.

The final deliverables (e.g. executive summary, technical report and analytical sandbox,

etc) must be zipped in a single zip file format.

Name the zip file according to the course code and assignment, for example:

ISSS602_Assign1.

Due Date

24th September 2018, 23:59pm (mid-night)

SMU Classification: Restricted

Grading Criteria

The report will be graded using the following criteria:

Managerial communication (executive report): Easy to understand and insightful

recommendations (20%).

Data preparation (30%)

Appropriateness of the analysis methods used (20%)

Accurate interpretation of analysis results (20%)

Bonus: demonstrated extra research, analysis and/or presentation efforts (10%)