DS-201d · Module 4

Exercise: Building the CMO Dashboard

5 min read

The final exercise combines everything. You will build a single-page dashboard in both Claude and ChatGPT that a CMO could use to make budget allocation decisions. This is the visualization that goes in the board deck. It needs to be self-explanatory, visually clean, and analytically rigorous.

Create a four-panel executive dashboard from the marketing funnel data. Layout: 2x2 grid.

Panel 1 (top-left): "Channel Efficiency" — Scatter plot of cost per acquisition vs total closed-won deals. Size by spend. Label each channel.

Panel 2 (top-right): "Funnel Health" — Stacked bar chart showing where each channel loses prospects. Each bar is a channel, segments are the drop-off volume at each funnel stage.

Panel 3 (bottom-left): "Monthly Trend" — Line chart showing total closed-won deals per month, one line per channel. Show if channels are improving or declining.

Panel 4 (bottom-right): "Budget Allocation" — Donut chart of current spend distribution with a data table beneath showing recommended reallocation based on cost-per-acquisition data.

Style: Dark background (#0f172a). Cyan (#06b6d4) primary. Amber (#f59e0b) for highlights. Clean sans-serif font. Minimal gridlines. Suptitle: "Marketing Channel Performance — Q1 2025". Make it presentation-ready at 1920x1080.

Run this prompt in both tools. Claude will generate an interactive Artifact dashboard — rendered immediately, editable with follow-up prompts. ChatGPT will produce a comprehensive Python script that saves a 1920x1080 PNG when executed. Neither will be perfect on the first try — the 2x2 layout, color consistency across panels, and legend placement will need iteration. In Claude, iterate conversationally. In ChatGPT, ask for script modifications, re-run, and check the output.