The data set for your analysis includes variables related to Global Bikes most recent sales data. You
Question:
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?