Improved operations for a local book, plant, and coffee shop through data-driven analysis, including inventory tracking, customer segmentation, and store-hour optimization based on traffic and sales patterns. Incorporated social media-driven demand trends (e.g., BookTok) into competitive analysis to inform customer engagement and merchandising recommendations.
Solution & Technical Approach
- Built an Excel + SQL framework to track inventory turnover and revenue by product line
- Analyzed purchasing behavior to identify high-impact sales periods and categories
- Applied behavioral segmentation (demographics, technographics, and needs-based psychographics) to identify target customer mindsets beyond basic purchase patterns, revealing opportunities in the remote worker and creative community segments
- Evaluated competitor positioning and social-media-driven demand trends (e.g., BookTok)
- Delivered actionable recommendations for store hours, promotions, and community engagement
Key Decisions
Simplicity over complexity. Prioritized low-cost, maintainable tooling to ensure adoption by a small business team. Focused on actionable insights over complex analysis.
Constraints Navigated
Impact
Replaced ad-hoc inventory and sales tracking with a structured framework. Improved visibility across books, coffee, and plant revenue streams. Enabled data-driven decisions for store hours, customer targeting, and marketing.