Question: The data set for your analysis includes variables related to Global Bikes most recent sales data. You should be familiar with most of the variables,

The data set for your analysis includes variables related to Global Bike’s most recent sales data. You should be familiar with most of the variables, but here are some hints on this data set.
The sales team at Global Bike (GB) is concerned about new competitors in the market. A strategic planning meeting is scheduled for the first of the month. Your job is to explore the data and provide insights into GB’s current customer base and sales data. Nina Kane and her colleagues in Germany believe that Global Bike has 4 groups of customers with distinct characteristics. She also knows that customers have changed over the past few years and so any analysis that you provide on the groups should be focused on the newest data available.


Global Bike Case Study

Product

ProdDescr

ProdCat

CatDescr

Division

SalesQuantity

RevenueUSD

DiscountUSD

CostsUSD

PRTR1000

Professional Touring Bike-Black

TOU

Touring Bike

BI

4

14080.02

422.41

8320

DXTR1000

Deluxe Touring Bike-Black

TOU

Touring Bike

BI

8

26400

792

15600


Create a cluster analysis for Nina.

1. What can you tell Nina about the customer groups? 

2. Define how you clustered the transactions for Nina. 

3. What variables did you use? 

4. Did you use any filters? 

5. If so what were they?

Step by Step Solution

3.42 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

1 What can you tell Nina about the customer groups Cluster analysis is a method of data analysis used to define and identify customer groups Cluster analysis helps to determine customer segments which ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!