ZARA Sales Performance & Market Analysis Dashboard

A comprehensive, end-to-end retail analytics solution developed to track and optimize ZARA's sales performance, product placement strategy, and inventory distribution. This project transforms complex transactional data into high-impact business intelligence to enhance profitability and operational efficiency.

Technical Architecture & Methodology:

• Data Engineering & Cleaning (Python): Leveraged Pandas and NumPy to execute advanced data preprocessing, handle missing values, eliminate redundancies, and ensure maximum data integrity for business reporting.

• Interactive Business Intelligence (Power BI): Architected a dynamic, executive-facing dashboard utilizing a modern dark-themed UI/UX layout optimized for scannability and quick decision-making.

Key Business Insights & Deliverables:

• Executive KPIs Tracked: Maintained full visibility over core retail metrics, highlighting Total Revenue ($18.92M), Sales Volume (225K units sold), Average Unit Price ($86.08), and an active catalog of 123 unique Product IDs.

• Product Position Optimization: Analyzed the direct correlation between store layout and sales volume, revealing that "Aisle" placements led with 38.09% of total volume, followed closely by "End-cap" (33.01%) and "Front of Store" (28.9%).

• Segment Performance: Visualized revenue distribution across demographics, identifying the "MAN" section as the primary revenue driver (generating $18M) compared to the "WOMAN" section ($1M) under the filtered view.

• Inventory Analytics: Evaluled product variety distribution, identifying "Jackets" (67 items) as the leading category in the product mix, followed by Shoes and T-shirts.

• Dynamic Decision-Making: Integrated multi-dimensional slicers (Seasonal, Promotion, Sales Volume, and Section) to empower stakeholders to perform instant ad-hoc analysis.