Dorcas_Akinnibosun.xlsxOpen to work · Lagos · Remote, home page
How I work

Why every dashboard I build is interactive

A static chart answers one question. An interactive dashboard lets each person ask their own. How I design reports people can click through.

Dorcas Akinnibosun2 min read

Most data portfolios are a gallery of screenshots. Mine isn't, on purpose: every dashboard I build is interactive, and three of them are published live in Power BI on this site. Here is why that matters, and how I design for it.

A static chart answers one question

A screenshot shows the answer to the question its author had in mind. But a branch manager wants their branch, a director wants to compare regions, and a recruiter wants one industry. With a static report, each of those is a new request back to the analyst.

An interactive dashboard lets each person ask their own question. The slicers, KPI cards and charts update together, so filtering to one store or one year changes the whole page, not just one visual.

Order pages the way people ask questions

I lay out report pages in the order people tend to ask: what is happening, then why, then what to do about it. My Maven Electronics sales report runs from an executive overview, to sales trends, to products and customers, to stores and regions. Each page answers the question the previous one raises.

Page navigation, bookmarks and drill-through do the rest. You can start at the overview and drill into a single store without hunting for the right tab.

Excel can be interactive too

Not every team runs on Power BI. For MetroBank and Nexa I built the dashboards in Excel with Power Query, pivot tables and slicers. They ship as working workbooks, so people can filter them in the tool they already use every day.

What "interactive" doesn't mean

It doesn't mean more charts. Every slicer is another thing a reader has to understand, so I only add filters that match a real question someone will ask, and I keep the default view useful on its own. If nobody touches a single slicer, the page should still tell the main story.

It also doesn't replace the write-up. Every case study ends with findings and recommendations in plain language, so technical and non-technical readers leave with the same message.

Try one

Load a live report, pick a slicer and watch the page respond. That is the experience I'm designing for: you asking your own question, and the data answering it.

More

Keep reading.

All posts →
Contact

=IF(you_have_data, "let's look at it together", "say hello anyway")

Whether it's a role, a messy spreadsheet or a question about one of the case studies, messages come straight to my inbox.

Open to data analyst and BI work: full-time, contract or freelance, remote or on-site