When a stakeholder says the numbers don’t look right, you need a method to determine whether the problem lives upstream in the database or inside Tableau itself. I replicate eight Superstore table calculations in BigQuery, step by step, and show real cases where SQL caught Tableau misconfigurations.
Log data records when events start and end — but not how many were active at once. This post shows how data scaffolding transforms sparse event logs into a continuous daily timeline, unlocking time-based metrics like concurrent demand, utilization rates, and peak periods.
