Analyze Your Data · Lesson 3Pro+~16 min readForecasts + dashboardsAdvanced

Forecasts and live dashboards.

Analysis tells you what happened; this lesson tells you what’s likely next and how to watch it continuously. You’ll project trends honestly, build a live dashboard that updates itself, and set up recurring reports — so the picture stays current without you re-running the work every week.

The mental model

Go from one-time analysis to ongoing: projections, live dashboards, and reports that refresh themselves.

Analysis answers “what happened.” The next step answers “what’s likely next” and “how do I watch this continuously.” Forecasts project trends forward, dashboards keep the current picture live, and recurring reports deliver it on a schedule — so you’re not re-running the analysis every week.

Step 01 Simple forecasting

You don’t need a data-science model to project a trend. AI can extend a pattern and run scenarios — but only honestly if you make it state its assumptions.

Forecast promptBased on this historical data, project [metric] for the next [period]. Show a best-case, expected, and worst-case scenario, and state every assumption you’re making. Be clear about how much uncertainty there is — don’t present a single confident number.

Step 02 Build a live dashboard

Connect a view to your data so it updates as the data does — the at-a-glance numbers you check often. This is the Build an App build pointed at your metrics: describe the dashboard, connect the source, ship it.

Step 03 Recurring reports

Combine with the Automate a Workflow build: a scheduled job that runs your analysis and delivers a summary every Monday — the report you’d never find time to make by hand.

Step 04 Share and interpret

Give stakeholders the number and its meaning. A dashboard without interpretation gets misread; pair live numbers with a short note on what they mean and what to watch.

Forecasts invite false precision. AI will hand you “$847,329 next quarter” when the honest answer is “somewhere between $700k and $1M, trending up.” Garbage or thin data produces confident nonsense. Always show ranges and assumptions, and never present a projection as a certainty.

Your challenge: make it ongoing

Take your analysis from Lesson 2 forward:

Build a forecast with best/expected/worst cases and stated assumptions.
Stand up a live dashboard connected to your data.
Schedule a recurring summary report.
Pair the numbers with a short note on what they mean.

That’s a living view of your data instead of a one-off look. You’ve finished the Analyze Your Data track.

Next build: Automate Your Documents →Back to Analyze Your Data

What you can do now

Project trends with scenarios and stated assumptions
Build a live dashboard connected to your data
Schedule recurring reports that refresh themselves
Pair live numbers with interpretation
Avoid false precision in forecasts

You’ve finished this build

Analyze Your Data — complete

You can pull answers from a spreadsheet, produce real analysis and charts, and build forecasts and live dashboards. Ready for the next one? Automate Your Documents → or see all builds.