Conflicting numbers in a dashboard are usually caused by differences in grain, filters, join logic, refresh timing, or metric definitions. For a Data Visualisation Specialist, the key skill is not just spotting the mismatch in Bigbear dashboards, but tracing it to the exact transformation or source causing it.
You notice that the same KPI in a Bigbear dashboard shows different values depending on which source table or model is used. Explain how you would investigate and resolve the discrepancy using SQL. Discuss how you would compare source datasets, validate joins and aggregations, check for duplicate rows or missing records, and confirm whether the metric definition is actually consistent across sources.
The interviewer expects a structured debugging approach, not just a generic statement like “check the data.” You should explain the order of investigation, the SQL patterns you would use, and how you would communicate the root cause and fix once identified.