Calculate the customer’s age and store it as a new integer variable, named “Customer Age”

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Calculate age

Calculate the customer’s age and store it as a new integer variable, named “Customer Age”.  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 cases where such customers exist.

5. Recoding

6. 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”

1. 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.

1. Basic Analysis

2. 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.

1. Advanced Analysis

2. 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

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. 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. The LineItem class will represent an individual

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

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of