Progress Tracking and Status Reporting Questions

Keeping a project visible and on track: tracking progress, monitoring project health with early-warning signals, and reporting status to stakeholders and executives. Covers choosing status metrics, surfacing problems early, and tailoring communication to different audiences.

MediumBehavioral

33 practiced

Describe a time when metrics were being used punitively in a team you worked with. How did you identify the problem, who did you involve, what actions did you take to change the practice, and what was the result? Use concrete examples and outcomes.

EasyTechnical

28 practiced

Write a SQL query (any ANSI-compatible dialect) to compute a 7-day rolling average of a metric per user given this table: events( user_id INT, event_date DATE, metric_value FLOAT ) Return columns: user_id, event_date, rolling_7d_avg. Explain how you handle missing dates and users with sparse events.

Sample Answer

Approach: first aggregate metrics at user+date level, then use a window that looks back 6 days to compute the 7-day average. Two options are shown: (A) average over available event days (ignores missing dates) using a RANGE window; (B) treat missing dates as zero by first generating a calendar and left-joining each user to every date. A) Ignore missing dates (average over present days) sql WITH daily AS ( SELECT user_id, event_date, SUM(metric_value) AS value FROM events GROUP BY user_id, event_date ) SELECT user_id, event_date, AVG(value) OVER ( PARTITION BY user_id ORDER BY event_date RANGE BETWEEN INTERVAL '6' DAY PRECEDING AND CURRENT ROW ) AS rolling_7d_avg FROM daily ORDER BY user_id, event_date; B) Treat missing dates as zero (strict 7-day per-day average) sql -- assume calendar(date) exists or generate dates as needed WITH users AS (SELECT DISTINCT user_id FROM events), calendar AS (SELECT generate_series(min_date, max_date, INTERVAL '1 day')::date AS event_date FROM (SELECT MIN(event_date) AS min_date, MAX(event_date) AS max_date FROM events) t), grid AS ( SELECT u.user_id, c.event_date FROM users u CROSS JOIN calendar c ), daily AS ( SELECT g.user_id, g.event_date, COALESCE(e.metric_value,0) AS value FROM grid g LEFT JOIN ( SELECT user_id, event_date, SUM(metric_value) AS metric_value FROM events GROUP BY user_id, event_date ) e ON e.user_id = g.user_id AND e.event_date = g.event_date ) SELECT user_id, event_date, AVG(value) OVER ( PARTITION BY user_id ORDER BY event_date RANGE BETWEEN INTERVAL '6' DAY PRECEDING AND CURRENT ROW ) AS rolling_7d_avg FROM daily ORDER BY user_id, event_date; Handling sparse users: Option A yields a moving average over only days with events — useful when you want average per-event-day. Option B forces a daily time series per user and treats missing days as zero — use this when metric is “daily” (e.g., active minutes) and zeros matter. Choose based on business definition of the metric.

HardSystem Design

37 practiced

Design an organization-level outcomes tracking platform that unifies OKRs, KPIs, and program metrics for multiple business units. Requirements: multi-tenant dashboards, metric lineage, RBAC, metric versioning, and support for millions of events per day. Sketch the high-level architecture (ingest, storage, semantic layer, BI access), justify technology choices, and identify major operational risks.

Sample Answer

MediumTechnical

35 practiced

A product manager tells you adoption of a new feature increased 40% month-over-month, but finance says revenue did not change. As the BI Analyst, outline a step-by-step analysis plan to reconcile these views, including which metrics, cohorts, and visualizations you would produce.

Sample Answer

EasyBehavioral

38 practiced

Tell me about a time you had to explain a complex dashboard to non-technical executives. Use the STAR structure (Situation, Task, Action, Result). What visualization choices did you make, how did you validate stakeholders understood the insights, and what was the business outcome?

Unlock Full Question Bank

Get access to all 40 Progress Tracking and Status Reporting interview questions and detailed answers.

Join thousands of developers preparing for their dream job.