Compiling Brief Documentation for the Dashboard

Compiling Brief Documentation for the Dashboard#

We will write brief documentation for the dashboard, which will be placed on a separate tab of the dashboard.

General Information#

The WWI Business Performance Overview Dashboard provides comprehensive insights into sales performance, customer behavior, product analytics, and delivery operations within the Wide World Importers company. This tool enables data-driven decision making across multiple business dimensions.

Dashboard Owner: Pavel Grigoryev

Data Coverage: January 2013 - May 2016

Abbreviations:

Abbreviation

Full Name

LM

Last Month

YoY

Year-over-Year

AOV

Average Order Value

ARPPU

Average Revenue Per Paying User

APC

Average Payment Count

Tab Overview#

Sales Tab#

Key Metrics:

  • Revenue - Total sales amount for the last month

  • Profit - Total profit generated for the last month

  • Sales - Total number of orders sold for the last month

  • AOV - Average Order Value for the last month

Each metric includes a monthly trend visualization (sparkline) for the last 12 months and the previous year, allowing for direct historical comparison.

Detailed Breakdowns:

  • By customer category

  • By delivery status (on-time vs delayed orders)

  • By state and city geographic regions

Customers Tab#

Key Metrics:

  • Customers - Total active customers for the last month

  • ARPPU - Average Revenue Per Paying User for the last month

  • APC - Average Purchase Count per customer for the last month

  • Avg Items/Order - Average Products per Order for the last month

Each metric includes a monthly trend visualization (sparkline) for the last 12 months and the previous year, allowing for direct historical comparison.

Detailed Breakdowns:

  • Customer metrics by state and city

Products Tab#

Key Metrics:

  • Avg Product Revenue - Average Revenue per Product for the last month

  • Avg Product Profit - Average Profit per Product for the last month

  • Avg Items Sales - Average Units Sold per Product for the last month

  • Avg Unit Price - Average Product Price for the last month

Each metric includes a monthly trend visualization (sparkline) for the last 12 months and the previous year, allowing for direct historical comparison.

Detailed Breakdowns:

  • By product category

  • By packaging type (internal/external packaging)

Delivery & Logistics Tab#

Key Metrics:

  • Avg Delivery Days - Mean time from order to delivery in days for the last month

  • Delay Rate - Percentage of orders delivered late for the last month

  • Average Delay Days - Mean lateness for delayed orders for the last month

  • Avg Picking Days - Mean Order picking time for the last month

Each metric includes a monthly trend visualization (sparkline) for the last 12 months and the previous year, allowing for direct historical comparison.

Detailed Breakdowns:

  • Performance by state and city regions

Access Information#

Access Level: Available to all

Data Sources & Technical Details#

Data Sources:

  • Data is sourced from the analytical database.

  • The dashboard connects to materialized views: analytics.mv_orders and analytics.mv_products.

Calculation Methodology:

  • YoY (Year-over-Year) Growth: Calculated as (Metric Value for Last Month / Metric Value for Same Month Previous Year) - 1.

  • Sparkline Trends: Each monthly point on sparklines represents the YoY growth for that specific month, calculated as (Current Month Value / Same Month Previous Year Value) - 1, providing a continuous YoY comparison over the past 12 months.

Frequently Asked Questions#

What does YoY mean and how is it calculated?#

YoY stands for Year-over-Year.

  • It is a key performance metric that compares a specific period (e.g., a month) to the exact same period in the previous year.

  • This eliminates seasonal effects and provides a clearer view of growth trends.

It is calculated as:

(Metric Value for Current Period / Metric Value for Same Period Previous Year) - 1

How are delayed orders defined?#

An order is classified as delayed if the actual delivery date is later than the promised/scheduled delivery date.

What is shown on the sparkline charts?#

The sparklines provide a visual history of a metric’s performance:

  • The solid line represents the monthly values for the most recent 12-month period.

  • The shaded dashed line behind it represents the values for the same months from the previous year (a 12-month period offset by one year).

This overlay allows for an instant visual comparison of current performance against the historical benchmark.

On this page