Designation: Category Intern (Indiluxe)
Internship Duration: 3-4 months
Office Location:
Vikhroli West, Mumbai, Maharashtra
Primary Responsibilities:
- Review roadmap
- Request data access for all needed datasets.
- Document data quality issues, missing fields.
- Create data dictionary and initial exploratory analysis
- Set up Excel environment for analysis
- Draft analysis frameworks
- Calculate basic price elasticity for major accessory categories (watches, handbags, jewelry, etc.)
- Analyze discount effectiveness (10%, 20%, 30%, 40% off)
- Calculate revenue vs. volume trade-offs
- Consumer surplus analysis - estimate willingness to pay
- Identify optimal pricing points
- Build pricing recommendation matrix by category
- Create visualizations
- Segment customers by purchase behavior (frequency, basket size, AOV)
- Identify luxury aspirants vs. established luxury buyers
- Income/spending pattern analysis across segments
- Calculate Customer Lifetime Value by segment
- Calculate Customer Acquisition Cost vs. retention costs
- Analyze repeat purchase rates by segment




- Build retention economics model
- Identify high-value segment opportunities
- Analyze brand performance: revenue, margin, units sold
- Calculate HHI for market concentration
- Contribution margin analysis by accessory type and brand
- Identify high-margin vs. high-volume products
- Cross-selling analysis: basket composition, product affinity
- Which accessories are bought together?
- Build brand portfolio matrix (Boston Consulting Group style)
- Stars, Cash Cows, Question Marks, Dogs
- Analyze seasonal patterns: Diwali, Recent Year, Valentine's, Raksha Bandhan, weddings
- Quantify festival impact on sales
- Build seasonal demand index by accessory category
- Forecast upcoming season demand
- Geographic analysis: Metro vs. Tier 1 vs. Tier 2 cities
- Mumbai, Delhi, Bangalore, Hyderabad, etc.
- Regional pricing and assortment recommendations
- Should strategy differ by geography?
- Integrate findings
- Ident

📌 Category Intern (Mumbai)
🏢 Tata CLiQ Fashion
📍 Mumbai