Cover image for Retail Pulse is a comprehensive, 12-page

Retail Pulse is a comprehensive, 12-page interactive business intelligence solution built from scratch in Power BI. Designed to analyze a robust dataset of over 100,000 retail transaction records, this project transforms raw operational data into actionable strategic insights for executive decision-making. The dashboards maintain a strict, professional visual hierarchy—utilizing a dark-themed canvas, strict conditional color logic (Green for Revenue, Blue for Profit), and dynamic cross-filtering to allow users to isolate performance by region, time, product, and customer cohort. 🛠️ Tech Stack & Tools Data Visualization & BI: Power BI Data Transformation: Power Query Calculations & Measures: DAX (Data Analysis Expressions) Complementary Skills: Python, SQL (Data Extraction & Validation) 📈 Key Dashboards & Features Executive Summary: High-level overview of total business health (₹2.51B Total Revenue, 100K Total Customers). Sales & Trend Analysis: Multi-year revenue growth tracking and seasonal peak identification. Product Performance: Profitability mapping to isolate core revenue-driving inventory (e.g., Beds & Refrigerators). Customer Analytics: High-value segmentation and geographic performance mapping across India. Inventory Risk: Supply chain vulnerability tracking to identify high flight-risk stockouts. Master Interactive Filter: A dedicated control panel allowing global cross-filtering across all 12 pages via Sync Slicers. 💡 Business Insights Generated Customer Retention: Identified a 100% repeat customer rate, alongside a strict 90-day churn risk threshold. Profit Efficiency: While May generates the highest gross volume, July yields the highest net profit margin due to optimized product mixes. Regional Equality: Proven market penetration with revenue split almost evenly across Tier 1, Tier 2, and Village demographics.

Vivek Singh

Data Analyst