Data Dashboards: The Single-Page Business Story
A data dashboard is the executive summary for your metrics, telling a story on a single page with key visualizations. It consolidates data from multiple reports, providing a high-level view to monitor business performance.
Why it exists
Business data is often spread across many detailed reports, creating information overload. A dashboard provides a single, consolidated view of the most critical metrics, allowing for quick monitoring and decision-making without forcing users to dig through pages of analysis.
The mental model
A dashboard is like the instrument panel in a car's cockpit. It doesn't show you every mechanical detail, but it gives you the essential, at-a-glance information needed to operate safely: speed, fuel level, and warning lights. It's an entryway to the deeper systems (the reports) if a warning light comes on.
How it works
A dashboard is a single page, or canvas, composed of individual visualizations called "tiles" (like charts or key numbers). Designers create these tiles by "pinning" them from one or more underlying reports. Each report is based on a specific dataset, or "semantic model". When the underlying data changes, the tiles on the dashboard update automatically. Selecting a tile typically takes you to the more detailed report page where it originated.
When to use it
Use a dashboard to monitor the overall health of your business, track key performance indicators (KPIs), and get a consolidated view of metrics from different data sources. It's perfect for executives and business users who need a quick, high-level understanding of performance. Many dashboards also support natural language queries, allowing you to ask questions like "total units this year."
When not to use it
Do not use a dashboard for deep, exploratory analysis. Dashboards are for monitoring the "what," not investigating the "why." They typically lack the powerful filtering and slicing capabilities of a full report. If you need to drill down, filter by multiple criteria, or explore data from many angles, you should navigate from the dashboard to the underlying report.
One canonical example
A sales manager's dashboard might show total units sold this quarter, revenue by region, and the top-performing salesperson on a single screen. Each of these tiles is pinned from different, more detailed reports. If the manager sees that a region is underperforming, they can click that tile to open the full regional sales report for a deeper investigation.
Interview question
A sales manager observes a sudden decline in regional sales on their data dashboard. Based on the card's description, what is the most appropriate immediate action to investigate this issue further?
- a.Begin a new, comprehensive data exploration using the dashboard's built-in analytical tools.
- b.Click on the specific regional sales tile to navigate to its associated detailed report.Correct
- c.Adjust the dashboard's date range filters to see if the decline is part of a longer trend.
- d.Contact the regional sales team to ask for an explanation of the performance drop.
Why? this is the answer
The card explicitly states that selecting a tile on a dashboard typically takes you to the more detailed report page for deeper investigation. This allows for data-driven exploration of the 'what' before moving to the 'why,' making it the intended immediate next step, unlike contacting the team which might come later.
Just read this? Test yourself on what you have been reading.
Read the original → learn.microsoft.com
- #dashboard
- #analytics
- #bi
- #metrics
- #reporting
You just looked this up. Could you explain it out loud?
That is the part interviews actually test. Tezvyn takes questions like this one and gives you what the interviewer is really checking, the answer that lands, and the mistake that ends the conversation, in the four minutes before your next meeting.
The iPhone app is on the way
We are building it. Until it lands, nothing here is held back from you: every interview card, your saved cards, streaks and the job board all work in Safari, plus hundreds of free practice quizzes of thirty questions each. Sign in and it all carries over to the app the day it arrives.
Want it as an icon? Tap Share at the bottom of Safari, then Add to Home Screen. It opens full screen and the cards you have read stay available offline.
We are hiring for this. Every open role lists the topics its interview covers, so you can prepare for the real thing rather than guessing.
See open roles