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
Step: 1
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 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started