How the demo dashboard is built
What this is
BeeHill's demonstration dashboard shows what a business performance dashboard can look like. Every figure is simulated for a fictional motor dealership group with four branches (Nairobi, Mombasa, Nakuru, Kisumu) and three categories (new vehicles, used vehicles, service and parts). It is not client data, and none of it describes real business results.
Dataset
24 months of monthly figures, November 2024 to October 2026, for each branch and category (288 records). The numbers are produced by a short program, not collected from any business. The random generator uses a fixed starting value (20261025), so every visitor sees the same data.
How the numbers are generated
- Revenue = category base level x branch share x seasonal index x branch growth over time x a random factor between 0.94 and 1.06.
- Branch shares: Nairobi 45%, Mombasa 25%, Nakuru 17%, Kisumu 13%. Monthly growth rates differ by branch, and Kisumu is set to decline slightly so the dashboard has something to flag.
- Seasonal index: lower in January and February, higher from September to December, peaking in December.
- Gross margin = category margin (new vehicles 8.5%, used vehicles 13.5%, service and parts 38%) adjusted by a branch offset and a small random variation.
- Vehicles sold = revenue divided by an assumed average price (KES 3.4 million new, KES 1.7 million used). Service has no unit count.
Calculations
- Period comparisons compare the selected period with the previous period of the same length. Margin change is shown in percentage points.
- Forecast: a straight-line (least squares) trend fitted to the last 12 months of revenue for the current filters, projected 3 months ahead.
- Recommendations are written by fixed rules from the filtered figures. They are not produced by AI.
Limitations
- The forecast ignores seasonality, prices, competition and the economy, and has no confidence range. It is an estimate, not a prediction to rely on.
- Simulated data cannot show how a real business behaves. Real projects need real data, checks of data quality and agreed definitions of each measure.
- The data period is fixed in the code and does not roll forward with the calendar.
- Currency is Kenya shillings (KES), shown in millions (M) or billions (B).
Accessibility
The chart has a text alternative: use the option to view the chart data as a table. Filters are standard form controls and work with a keyboard.