Question2:

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

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, but here are some hints on this data set. Problem Statement: 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 GBs 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.

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?