My contribution
Used Excel sales patterns to redesign featured product bundles.
← All work
Poké Inn · Business operations
Sales analysis & product bundles
I studied sales in Excel and changed how products were grouped into featured meal combinations. The reported rate of choosing those combinations increased by 30%.
30%featured combo selection improvement
Excelsales analysis
Project overview
Use a sales pattern to rethink a product bundle
Work produced
Revised featured product combinations informed by sales analysis.
The original selection rates and measurement period are not published here. The outcome is a reported relative improvement.
Poké Inn / Product combinations
- Reviewed
- Sales patterns in Excel
- Changed
- Featured product combinations
30%
reported relative increase in featured combo selection
The original selection rates and comparison period are not published here.
Project overview
A business operations internship involving sales analysis and product bundle decisions.
Methods
Operational analysis, offer design, and outcome measurement.
Purpose
Connects customer choice patterns with a concrete operating change.
Terms explained
- Product bundle
- Products offered together as one combination.
- Selection rate
- How often the featured option is chosen among the eligible purchases being measured.
- Relative improvement
- A change compared with the starting rate. For example, a 30% relative increase from 10% would reach 13%. Those numbers are an illustration, not this project’s baseline.
01 · The business question
How can sales data inform product bundles that customers choose more often?
02 · My contribution
- Reviewed sales patterns in Excel to guide changes to product combinations.
- Redesigned the combinations, with a reported 30% relative increase in how often customers selected a featured combination.
03 · The finding
The reported rate of choosing a featured combination increased by 30%. This connects a change in the offer with a specific customer choice.
04 · The decision
Use sales patterns to decide which products to offer together. Review how often customers choose the featured combination after making a change.
Learning notes
An operating change needs a defined outcome.
- Sales patterns can point to a bundle worth revising. The bundle decision and the metric used to review it should stay connected.
- A relative change is easier to interpret when the baseline and comparison period are available. Those details are not included in the published project record.
A next questionFor a follow up test, define the eligible orders, baseline selection rate, and comparison window before changing another bundle.
05 · Work delivered
- Excel sales analysis
- Redesigned product bundles
- Reported featured combo selection improvement
Explore related fields
Follow the methods across other projects and working examples.
Context & measurement notes
A reported relative improvement in featured combo selection. Baseline rates and the comparison period are not available here.