How do you design a dashboard that executives will actually use, rather than one that gets ignored after a month?

What the interviewer is looking for

• This question tests visualisation & dashboards. Matches chart types to the question, keeps dashboards focused on decisions, and mentions tools like Power BI, Tableau or Looker.
• Strong answers: Starts from the decisions they make, few headline metrics with context and targets, clear layout, and checks usage after launch.
• Likely follow-up: How would you find out whether it is being used?

Another way it may be asked: The last three leadership dashboards were abandoned. What would you do differently on the next one?

A structure to follow: Requirements, sketch, deep-dive, trade-offs

1. Step 1

   Requirements

   Ask who uses it, what it must do, and which qualities matter most: speed, reliability, cost, consistency.

2. Step 2

   Sketch

   Draw the main parts and the path one request takes through them before adding detail.

3. Step 3

   Deep-dive

   Pick the riskiest part (storage, queueing, failure handling) and go deeper there.

4. Step 4

   Trade-offs

   Name what you gave up for each choice, and what you would do first if it needed to grow.

This is guidance on shape, not a script. Use your own real experience and facts; never invent details to fill a gap. See the STAR guide and answer frameworks.

Common slips

• Naming tools before establishing requirements.
• Drawing every box at the same depth instead of going deep where it matters.
• Presenting one design as the only answer, with no trade-offs.

How to practise it

Time yourself: two minutes on requirements, five on the sketch, five on one deep-dive, two on trade-offs.

Related questions

• How do you decide which kind of chart to use for a particular piece of data?
• What's the difference between an inner join and a left join, and when could picking the wrong one give you misleading numbers?
• You're handed a spreadsheet of sales with duplicate rows, mixed date formats and some blank regions. How would you clean it up?
• Weekly sign-ups dropped fifteen percent last week. Walk me through how you'd figure out why.
• If you were asked to define the key metrics for a subscription business, which would you choose and why?

Browse all questions