Interactive Reporting and User Experience Questions
Design dashboards with appropriate interactivity: filters, drill-downs, tooltips, and bookmarks. Balance flexibility with simplicity; avoid analysis paralysis from too many filters. Understand how to guide users toward insights through progressive disclosure.
MediumTechnical
68 practiced
Discuss the pros and cons of global (dashboard-level) filters versus per-visual filters. Provide design rules of thumb for when to use each and a strategy for documenting filter scope so users are not confused by unexpected interactions.
EasyTechnical
72 practiced
You're designing an executive dashboard for the C-suite. How do you decide default filter values and the initial view that loads when an executive opens the dashboard? Describe principles and at least three concrete rules you would follow to set sensible defaults while enabling deeper exploration.
HardTechnical
84 practiced
How should a dashboard present uncertain, incomplete, or low-quality data to avoid misleading decision makers? Propose UI patterns (badges, confidence intervals, data-quality banners), backend checks, and governance steps for surfacing data lineage and remediation status inline with KPIs.
EasyTechnical
66 practiced
Given a table sales(sale_id, product_id, product_name, revenue DECIMAL, sold_at TIMESTAMP), write a parameterized PostgreSQL query that returns the top 5 products by total revenue for a provided date range (start_date, end_date). Make sure your query handles NULL revenue values and ties consistently.
MediumTechnical
68 practiced
In Power BI, write a DAX measure (no need to run code) that calculates the rolling 7-day average of daily active users (DAU) given a table DailyMetrics(Date, ActiveUsers) and a proper Date table. Explain any assumptions and how your measure handles missing dates.
Unlock Full Question Bank
Get access to hundreds of Interactive Reporting and User Experience interview questions and detailed answers.
Sign in to ContinueJoin thousands of developers preparing for their dream job.