How to Fix an Overwhelming Dashboard with Filters and Refresh Rate Adjustments
You are a data analyst at a retail company. Your team has deployed a new dashboard that displays real-time inventory levels across all warehouses. The dashboard uses a traffic light color scheme (green = sufficient, yellow = low, red = out of stock). After one week, the warehouse managers complain that the dashboard is overwhelming because it shows all 500+ products at once, and they cannot quickly identify which items need immediate attention. They request a way to prioritize items that are red or yellow. Additionally, the dashboard updates every second, causing the screen to flicker constantly, which they find distracting. You need to redesign the dashboard to address these issues. Which course of action should you take?
Quick Answer
The answer is to add a filter showing only red or yellow status items and reduce the refresh rate to every five minutes. This directly addresses the overwhelming dashboard by applying filters to reduce cognitive load, hiding the 500+ green products so managers can instantly prioritize critical inventory, while the refresh rate adjustment from every second to every five minutes eliminates distracting screen flicker without sacrificing near-real-time data. On the CompTIA Data+ DA0-001 exam, this scenario tests your understanding of dashboard usability principles—specifically how filters and refresh intervals balance data timeliness with user focus. A common trap is choosing to keep the one-second refresh rate for “real-time” accuracy, but the exam emphasizes that excessive refresh rates harm readability and user trust. Remember the memory tip: “Filter the fire, slow the flicker”—prioritize only the alerts that need action, then pace the updates to match human attention spans.
⚠ Common exam trap
Candidates often think increasing refresh rate improves data accuracy, but the real issue is user distraction and information overload, not data latency.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Add a filter to show only items with red or yellow status, and reduce the refresh rate to every 5 minutes.
It directly addresses both user complaints: adding a filter to show only red/yellow items reduces cognitive overload by hiding the 500+ products that are not critical, and reducing the refresh rate from every second to every 5 minutes eliminates distracting screen flicker while still providing near-real-time inventory updates. This approach balances usability with the need for timely alerts without overwhelming the user.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Add a filter to show only items with red or yellow status, and reduce the refresh rate to every 5 minutes.
Why this is correct
Filter reduces clutter; slower refresh eliminates flicker.
- ✗
Replace the dashboard with a static table that shows all products sorted alphabetically, and increase the refresh rate to every 2 seconds.
Why it's wrong here
Static table is not actionable; faster refresh worsens flicker.
- ✗
Remove the color scheme and display only numerical values, and keep the refresh rate at 1 second.
Why it's wrong here
Removing colors reduces visual cues; flicker persists.
- ✗
Add additional colors to distinguish more inventory levels and increase the refresh rate to every 500 milliseconds.
Why it's wrong here
More colors and faster refresh increase confusion and flickering.
Visual reference
Go deeper
Related to this question
About these practice questions
This DA0-002 question is part of Courseiva's 986-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
Same concept, more angles
1 more way this is tested on DA0-002
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A retail company's data analyst developed a dashboard for store managers to monitor daily sales performance. The dashboard includes numerous metrics such as sales by hour, product category, employee, and customer demographics, along with trend lines and forecast graphs. Despite the comprehensive data, store managers are ignoring the dashboard because they find it cluttered and confusing. They prefer to rely on their intuition and verbal updates from shift leads. The analyst needs to improve communication of data insights to ensure the dashboard is used effectively. Which of the following actions should the analyst take FIRST?
medium- A.Send the raw data in a spreadsheet instead
- ✓ B.Simplify the dashboard by focusing on key metrics and using clear visual hierarchy
- C.Schedule a training session to explain all metrics
- D.Add more data points to provide a comprehensive view
Why B: The core issue is that the dashboard is cluttered and confusing, which directly undermines its usability. Option B addresses this by simplifying the dashboard to focus on key metrics and using a clear visual hierarchy, which is the foundational step in effective data communication. Without first reducing cognitive load, no amount of training or additional data will make the dashboard useful for time-constrained store managers.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DA0-002 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DA0-002 exam.