How would you visualize three years of monthly revenue?

WHAT THIS TESTS: This question evaluates your data literacy and ability to present information honestly. The interviewer is checking if you understand that chart design is not just aesthetic but has a major impact on interpretation. They want to see if you can create a visual that tells a true, clear story without needing a long explanation, which is a core skill for making data-informed decisions.

A GOOD ANSWER COVERS: Four key points in order. First, state the chart choice: a line chart is the standard and best choice for showing a continuous value over a time period. Second, detail the essential elements for clarity: a descriptive title like "Monthly Product Revenue, Jan 2021 - Dec 2023", a labeled X-axis for time, and a labeled Y-axis for revenue in a specific currency. Third, and most critically, specify that the Y-axis must start at zero to provide an honest representation of the magnitude of fluctuations. Fourth, add context to show senior thinking, such as overlaying a 12-month moving average to highlight the underlying trend versus monthly noise, or adding annotations for key events like marketing campaigns or price changes.

COMMON WRONG ANSWERS: A major red flag is suggesting an entirely inappropriate chart, like a pie chart. A more common but still weak answer is suggesting a bar chart; while not strictly wrong, it is less effective than a line chart for showing trends across 36 distinct time points. The most frequent mistake is failing to mention that the Y-axis must start at zero. An answer that omits this detail is considered incomplete, as truncating the axis is the most common way to create a misleading chart.

LIKELY FOLLOW-UPS: Expect questions that add complexity. For example: "How would you visualize this data if you were comparing it to a competitor's product?" (Answer: a dual-line chart, paying close attention to the axis scales). Or, "How would you show the contribution of different sales regions to the total monthly revenue?" (Answer: a stacked area chart). Or, "How would your choice change for 10 years of daily data?" (Answer: requires aggregation to weekly/monthly or an interactive chart with zoom capabilities).

ONE CONCRETE EXAMPLE: If monthly revenue fluctuates between 90,000 and 110,000, a chart with a Y-axis starting at 80,000 would make a 10% dip look like a catastrophic failure. Starting the axis at 0 shows the same $10,000 drop in its proper context: a noticeable but manageable fluctuation against the overall revenue stream. This demonstrates an honest and accurate portrayal of the business's stability.