A KPI dashboard
The problem
Design and build a one-page dashboard for a small online shop: revenue, orders, conversion and returns, with trends, targets and a breakdown by category.
Requirements
- Four KPI cards with value, change from last month and status against a target
- A monthly revenue line chart with a 3-month moving average and an annotated event
- A sorted bar chart of revenue by category with Other and percentage labels that add up to 100
- A 12-column grid layout, consistent colours and the data's update time
Technologies
- Python 3
- SVG or HTML
- Aggregation
- Dashboard design
Step by step
- Write down the audience, their decisions and the KPIs that inform them.
- Aggregate the raw orders into the KPI values and chart data.
- Build the cards and charts, then lay them out on the grid.
- Review the page against the course's checklist for honesty and accessibility.
Expected result
A dashboard page that answers the shop owner's main questions at a glance.
How it is evaluated
- Every number has context
- Charts are honest and accessible
- The layout puts the most important information first
- Calculations match a hand check on a sample
Ways to improve it
- Add filters by region and period
- Add small multiples by category
- Add a sparkline to each KPI card