Superset BI dashboards
Hilal embeds Apache Superset directly in the app for users who want every chart and every breakdown. The four KPI tiles on the home dashboard are the executive summary; Superset is the encyclopedia.
In this guide:
- Open the Superset view
- Use the pre-built dashboards
- Filter and drill
- Export Superset data
Prerequisites
- Your subscription tier includes Superset (Premium and above; not on Free or Basic by default — check Settings → Subscriptions & add-ons).
- Your Amazon data has finished its initial sync.
Step 1: Open the Superset view
Go to Dashboard → Superset BI dashboards in the sidebar.
You’ll see a grid of pre-built dashboards Hilal ships with:
| Dashboard | Use when |
|---|---|
| Sales overview | Headline revenue, order, and AOV trends. |
| SKU performance | Per-SKU revenue, units, profit, and stock days-of-cover. |
| Advertising performance | Per-campaign ACoS, TACoS, click-through, conversion. |
| Marketplace breakdown | Regional comparison across all your marketplaces. |
| Returns & refunds | Return rates, reasons, refund cost. |
| Buyer behavior | Repeat purchase, geographic distribution, review sentiment. |
Click any tile to open the dashboard in-line.
Step 2: Use the pre-built dashboards
Each Superset dashboard is fully interactive. The toolbar across the top has:
- Date range filter — applies to every chart.
- Marketplace filter — multi-select.
- Refresh — re-runs all queries.
- Tabs — most dashboards have multiple tabs (Overview / Detail / Cohorts).
Hover any chart for tooltips; click a data point to drill into the underlying rows.
Step 3: Filter and drill
Most charts support cross-filtering — clicking on a slice of one chart filters the others on the same page. To clear, click the active filter chip in the toolbar or press Esc.
To filter to a specific dimension (a single SKU, a single campaign), use the Filter box in the dashboard’s left rail.
Step 4: Export Superset data
Click the ⋯ menu on any chart and pick:
- Download as CSV — raw data behind the chart.
- Download as image — PNG of the chart.
- View in SQL Lab (advanced) — see and edit the SQL behind the chart.
Note: Superset CSV exports are independent of the Hilal Excel/PDF exporter (Finances → Exports).
Troubleshooting
- “Superset is not included in your plan.” Upgrade to Premium or higher; or buy the Advanced analytics add-on.
- A dashboard is blank. Either no data matches your filters (try widening the date range) or your data sync is still running.
- A chart shows “Query timeout.” The query was too expensive. Narrow the date range or filter to fewer marketplaces.