Vrinda Store Retail Sales Performance Audit
Audited a comprehensive retail sales database to profile target customer behaviors, map channel performance index, and structure future promotional spend.
1. The Problem
Vrinda Store was attempting to scale its seasonal retail revenues but lacked a data-driven customer model. Promotional campaigns were broad and generalized, resulting in high advertising spend with poor conversion rates. Sales managers could not pinpoint underperforming territories or identify which product subcategories carried the highest net profit margins.
The objective was to audit the raw year-long transactional database to answer three questions: **Who** is the core customer? **Where** is the revenue concentrated? And **what** channels drive the highest transactional value?
2. The Approach
I structured a clear spreadsheet audit plan:
- Data Ingestion & Cleaning: Sanitized transaction records, standardized date parameters, and resolved inconsistencies in city labels.
- Demographic Profiling: Grouped buyer ages and genders to map purchasing concentrations.
- Channel Effectiveness Study: Modeled transactional performance across sales mediums (direct store, third-party marketplaces).
3. The Process
The process was designed to go from raw numbers to clear structures:
Checked for duplicate records, filtered out cancelled orders to prevent gross margin skewing, and standardized currency formatting.
Constructed multi-dimensional pivot tables crossing Age Group x Gender x Order Value to isolate the dominant demographic.
Arranged high-impact charts in Excel to create a clean, single-page executive overview showing month-over-month performance trends.
4. The Analysis
My audit of transactional records uncovered three critical customer and inventory insights:
Women aged 30 to 45 emerge as the dominant buyer persona, generating nearly two-thirds of the brand's total annual transactional value.
Maharashtra and Karnataka are the highest-performing regional corridors, together contributing over a third of all completed customer orders.
Western wear and Kurtas represent the highest margin segments, exhibiting three times faster inventory turnover velocity compared to other categories.
5. Business Recommendation
I delivered a clean, actionable marketing and stocking proposal to Vrinda Store's operational leaders, detailing where to prioritize promotional budgets.
Recommended Strategic Impact
- Recommended 70% Ad Spend Reallocation: Shifting advertising dollars away from generalized campaigns targeting broad audiences to focus on the female 30-45 demographic in high-volume states.
- Projected 18% Stockout Reductions: Safety stock and buffer parameter recommendations for high-velocity Kurtas and Western wear lines.
- Designed Single-Sheet Dashboard: Deployed a centralized spreadsheet overview layout enabling monthly performance tracking with zero manual upkeep.