logo Use SA10RAM to get 10%* Discount.
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Abhilekh Nath DasComputer science
(/5)

909 Answers

Hire Me
expert
Vincent BirdsallAccounting
(5/5)

783 Answers

Hire Me
expert
Eva EdwardsMathematics
(5/5)

795 Answers

Hire Me
expert
Geraldo SemedoPsychology
(5/5)

867 Answers

Hire Me
SPSS
(5/5)

Calculate the customers age and store it as new integer variable, named Customer Age

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

For each task, a new process flow should be done.  

Calculate age

Calculate the customer’s age and store it as new integer variable, named “Customer Age”. Assume that today’s date is 01/01/2019. Additionally, you should check if the data are rightfully stored by the system according to the GDPR regulation. In particular, the company is not allowed to keep data for under-age persons (i.e., less than 18 years old).

A conditional report should be generated in the cases where such customers exist.

5. Recoding

A. Based on the “Customer Age” variable, create a new variable named “Age Group”

that is calculated as follows:

Condition (years) Recoded Label

1 - 18 “Under 18”

18 - 25 “Very Young”

26 - 35 “Young”

36 - 50 “Middle Aged”

51 - 65 “Mature”

66 - 75 “Senior”

> 75 “Very Senior”

B. The supplier code (Supplier_ID) of each product is contained in the 9th digit its SKU code. For example, for SKU code 58720393450301, the supplier code is 4. Use appropriate functions to store the supplier code as a new column named Supplier_ID.

B. Basic Analysis

1. Invoice Total Items

Create a report with the Total Items for every invoice.

The report structure should resemble the following (partial results):

2. Invoice Total Value

Create a report with the Total Value (i.e., Quantity x Price) for every invoice. Beware that there exist price discounts that can be seen in the promotions data set. Take into account all the invoices no matter if they are Sales or Returns.

The report structure should resemble the following (partial results):

3. Region Analysis

Create a report with appropriate graphs to demonstrate the contribution to the company’s revenues of each region of the country. For the top region found show the contribution to the company’s revenues per gender.

4. Basket Analysis

Create a report with appropriate graphs that describe the average basket. The report should include at least the number of SKU’s, total monetary value, etc. Comment on your findings.

5. Demographic Analysis

Create a report with the demographic analysis of the customers. Your report should include the analysis (tables and graphs) of appropriate variables and should be performed at a national and regional level. The report should include a pie chart and a

frequency table with the percentages of customers that belong to each age group.

C. Advanced Analysis

1. Product Rankings

Create a report that shows the top products per product type with respect to total sales value. The report should include the ranking of each product. Furthermore, the report should also include the subtotal sales of each product type at the beginning.

2. Behavioural Characteristics

Create a report that analyzes the behavioral characteristics of each age group (visits to the stores, number of distinct SKU’s purchased, total cost of purchases). Augment your analysis by providing pie charts for the behavioral characteristics for each age group.

3. Promotions Analysis

Create a report with appropriate graphs to show what is the percentage of products that are sold with and without promotion. Create a format to display the 0% promotion as “No Promotion” and the 10%, 20% and 30% as “Promotion”. Additionally, create a pie chart to show the percentage of products that are sold on each promotion type (use the description of the promotion and not its code). Do not include the products sold  without promotion. 

4. Daily Sales

Create a report with appropriate graphs to answer the following managerial question:  “Is there any difference among the various days with respect to the number of distinct SKU’s per invoice.”

5. Supplier Analysis

Create a report, which includes appropriate charts, to show an analysis of supplier sales.

The report should include the percentage of products that each supplier supplies, the  total revenue generated by these products and the weight of that revenue (i.e., percentage of that revenue against all the sales).

Finally, create a cross tabulation table, using the Summary Tables Wizard task to show the total revenue of the company with respect to the country origins of the products sold by each supplier. Use the names of the suppliers and the names of the countries of origins and not their codes. Add the total revenue in the middle of the cross tabulation, the origin in the rows and the suppliers in the columns

(5/5)
Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme

Get Free Quote!

374 Experts Online