Dashboard Development for E-Commerce Performance Analysis
Project Overview We receive comprehensive monthly performance data for our products (SKU-level & product group-level) and require professional dashboard solutions for visual processing and analysis of these data trends over time. Current Situation • Data Source: Monthly Excel exports with structured performance data • Data Scope: Approx. 25+ metrics per product (ASIN/SKU level) • Time Period: Multi-year historical data (from 2023) • Granularity: Monthly data points Relevant Data Dimensions (Columns A through AA) Current raw data includes the following key metrics: • Base Data: Month, Year, ASIN, SKU, Product Group, Title • Financial Metrics: Margin per product, Revenue (gross/net/organic/advertising), Profit margin, Gross profit margin • Sales Metrics: Units, Orders, Organic revenue share • Marketing: PPC spend, T-ACoS, Revenue % organic vs.advertising • Traffic: Sessions, Page views • B2B Segment: Separate B2B metrics (Sessions, Revenue, Orders, Revenue share) Project RequirementsPhase 1: Excel Dashboard (Initial) Objective: Build a functional Excel dashboard for time series analysis Must-Have Features: • Visualize temporal development of key metrics (line charts, trend analysis) • Filter functions by: o Individual SKUs/ASINs o Product groups (aggregated view) o Time periods (flexible: month, quarter, year) • Comparison capabilities: o Year-over-year comparisons (YoY) o Product comparisons o Product group performance • Automated data refresh when importing new monthly data • Clear dashboard layout with most important KPIs at a glance Nice-to-Have Features: • Calculated metrics (e.g., conversion rate, average order value) • Conditional formatting for performance alerts • Pivot tables for flexible data exploration • Export functions for reportsPhase 2: Further Development & Tool Migration (Optional) After successful implementation of the Excel solution, there is the possibility for further development in professional BI tools such as: • Power BI • Tableau • bolthires Looker Studio • Or comparable solutions Apply tot his job