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 Requirements
Phase 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 reports
Phase 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
• Google Looker Studio
• Or comparable solutions
Apply Now
Apply Now