Report-writing agent

Quarterly market reports, drafted by AI and signed off by analysts

01 / Situation

Analysts were spending far too much time gathering, normalizing, and narrating market data across siloed sources.

02 / Intervention

Built automated data pipelines, a two-stage insight and commentary engine, and a review portal that kept analysts in control of every word.

03 / Outcome

50% reduction in time required to produce market reports

The situation

Where they started.

Every quarter this firm's research team wrote market reports by hand for dozens of US metros across office, industrial and healthcare, down to the submarket level. Each one meant pulling numbers from SQL and Power BI, building charts, writing commentary section by section and assembling a branded PowerPoint. We automated the pipeline end to end: one AI stage reads the data and pulls out the trends, a second drafts the commentary in the firm's voice, and analysts review, edit and approve before the deck is built.

Analysts spending 50%+ of their time on manual data gathering

Data locked in siloed formats (structured SQL, BI dashboards and past reports)

Inability to cover niche submarkets due to resource constraints

The delivery

What we did.

We built a reporting engine that pulls the latest figures, has one AI stage extract the headline metrics and trends, and a second write each section of commentary (economy, leasing, vacancy, construction, rents, sales) using examples from past reports. Analysts review and rewrite in a custom portal, and approved reports come out as fully branded PowerPoint decks with charts and maps, in batches of up to 100 at a time. Each quarter the AI drafts are scored against the published versions so quality keeps improving.

Execution model

Built automated data pipelines, a two-stage insight and commentary engine, and a review portal that kept analysts in control of every word.

The result

What changed.

50% reduction in time required to produce market reports

50% reduction in time required to produce market reports

Seven-figure annualized value in time savings

Enabled coverage of new, smaller submarkets without adding headcount

AI drafts benchmarked every quarter against the published reports

Try it yourself

See the work in action.

We rebuilt parts of this engagement as working demos you can talk to. The data is invented, so nothing from the client appears, but the problems are the real ones.