Click this link to interact with the dashboard: https://public.tableau.com/views/FashionRetailAnalysis_16764569484940/SALESKPIDASHBOARD?:language=en-GB&:display_count=n&:origin=viz_share_link
Aim: The purpose of this project was to perform sales analysis on a fashion retail dataset. The research questions were tailored around the following sales key performance indicators;
- Gross Profit
- Net Sales
- Consumer Lifetime Value
- Purchase Frequency
- Sales by product category
- Sales by customer segments
- Sales by country
- Sales by Year
- Discount
- Average Order Value
- Total Order Value. Application Used: Tableau About the datasets: The dataset used in this tutorial was from 365 Data Science. It consists of both consumer and product information, including demographics,customer life time value, year of purchase, product category, line production SKU, etc. The combined data has 26 columns and 3675 rows.
Methodology: The analysis and dashboard were completed in Tableau.
Please click the link below to interact with dashboard. https://public.tableau.com/views/FashionRetailAnalysis_16764569484940/SALESKPIDASHBOARD?:language=en-GB&:display_count=n&:origin=viz_share_link
Also, check my blog post on this project covering the areas below;
SECTION 1: Overview of sales performance KPIs
SECTION 2: Difference between sales performance metrics and KPIs
SECTION 3: Calculating sales performance KPIs in Tableau
https://medium.com/data4fashion/fashion-analytics-sales-metrics-kpis-8285edd19ed6