DD08 Targets vs Actual: how it was built
Which region is behind plan, and since when? Rebuild this dashboard step by step in the Data Canvas.
DD08 · Targets vs Actual
Code in this build: 7 widgets written in SQL, and 3 filter, chart or pivot settings written as code.
The question: Which region is behind plan, and since when?
Who asks, and when: The CFO and the regional directors, at month end.
The decision: Which region is behind plan, and since when.
What the dashboard shows: EMEA is at 103% of target and APAC at 85%, with NA and LATAM on plan.
Follow the pictures below, in order, and you end up with the same dashboard. Every step is one thing you do in the Data Canvas, on the demo data that installs with DataPallas.