Analytics Dashboard
Executive KPIs and business intelligence insights from your data warehouse
Filters
$0
Total Sales
Revenue from 60,398
orders
0
Total Orders
Unique
transactions
0
Total Customers
Active customer
base
0
Total Products
In catalog
$0
Avg Order Value
Per
transaction
0
Total Quantity
Units sold
Growth Metrics
Year-over-year, quarter-over-quarter, and month-over-month performance trends
YoY Growth
vs
Revenue Growth
+179.7%
$16.3M vs $5.8M
Orders Growth
+66.4%
11,234 vs 6,752
Customer Growth
+44.5%
10,456 vs 7,234
QoQ Growth
vs
Revenue Growth
-19.6%
$6.6M vs $8.2M
Orders Growth
-21.4%
6,199 vs 7,890
Avg Order Value
+2.3%
$1,068 vs $1,044
MoM Growth
vs
Revenue Growth
+12.4%
$2.8M vs $2.5M
Orders Growth
+8.7%
2,456 vs 2,260
Avg Order Value
+3.4%
$1,140 vs $1,106
Profitability Analysis
Gross profit, margins, and cost efficiency metrics derived from your fact table
Gross Profit
$11.69M
Sales - COGS
39.8% of Revenue
Gross Margin
39.81%
Profit / Sales × 100
vs Industry Avg (35%)
+4.81%
Cost of Goods Sold
$17.67M
Quantity × Unit Cost
60.2% of Revenue
Avg Unit Profit
$193.00
Gross Profit / Quantity
Bikes
$730.00
Clothing
$15.00
Accessories
$12.00
Customer Segmentation & Retention
Behavioral analysis, loyalty metrics, and customer lifetime value indicators
New vs Returning
11,619
New Customers
62.86%
6,865
Returning Customers
37.14%
Repeat Rate & Loyalty
37.14%
Repeat Rate
26.68%
Retention Rate
73.32%
Churn Rate
Customer Value Metrics
1.50
Avg Orders per Customer
27,659 orders / 18,484 customers
$1,588.20
Avg Revenue per Customer
$29.4M / 18,484 customers
$632.21
Avg Profit per Customer
$11.69M / 18,484 customers
$88.07M
Cumulative CLV
Total Customer Lifetime Value
Per
Customer: $4,765
Sales Performance Over Time
Monthly trends showing growth, seasonality, and performance patterns
Monthly Sales Trend
Sales ($)
Orders & Customers by Month
Orders
Customers
Customers by Gender
18,484 Total
9,341
Male (50.5%)
9,128
Female (49.4%)
15
n/a (0.1%)
Product Performance
295 ProductsTop 5 Products by Revenue
1
Mountain-200 Black, 46
$1,373,454
2
Mountain-200 Black, 42
$1,363,128
3
Mountain-200 Silver, 38
$1,339,394
4
Mountain-200 Silver, 46
$1,301,629
5
Mountain-200 Black, 38
$1,294,854
Low Performers (Mid-Range)
126
Road-650 Black, 44
$47,565
127
Road-650 Black, 48
$45,320
128
Road-650 Black, 52
$42,890
129
Road-650 Red, 44
$38,450
130
Road-650 Red, 48
$35,210
Product Insights
Category breakdown, cost analysis, and inventory distribution metrics
Products by Category
295 Total
Components
127
Bikes
97
Clothing
35
Accessories
29
Uncategorized
7
Average Cost by Category
Cost Analysis
Bikes
$949.44
Highest Avg. Cost
Components
$264.72
Mid-Range
Clothing
$24.80
Budget-Friendly
Accessories
$13.17
Lowest Avg. Cost
Customers by Country
6 Countries
🇺🇸
United States
7,482
40.5%
🇦🇺
Australia
3,591
19.4%
🇬🇧
United Kingdom
1,913
10.3%
🇫🇷
France
1,810
9.8%
🇩🇪
Germany
1,780
9.6%
🇨🇦
Canada
1,571
8.5%
Category Contribution
Part-to-Whole
Bikes
$28.3M
96.46%
Accessories
$700K
2.39%
Clothing
$340K
1.16%