DD06 Seasonality & Peak Times: how it was built
When do we staff up, and when do we run campaigns? Rebuild this dashboard step by step in the Data Canvas.
DD06 · Seasonality & Peak Times
Code in this build: 3 widgets written in SQL, and 5 filter, chart or pivot settings written as code.
The question: When do we staff up, and when do we run campaigns?
Who asks, and when: The operations planner and marketing.
The decision: When to staff up and when to run campaigns.
What the dashboard shows: Orders peak on Monday evenings, 19:00-21:00, with Monday 20:00 the busiest hour of the week, while sales-rep orders peak on Monday at 13:00. November is about 2.3 times an average month and the Black Friday days run about 4 times an average day; the 25th to the 27th of any month bring about 25% more orders than an average day, and August runs a third below an average month.
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.