Scenario

AI accelerates the creation of public hearing materials by automating feedback analysis, drafting talking points, and building a polished deck—ensuring transparency and saving hours of manual effort.

1. Gather citizen feedback

Copilot quickly summarizes citizen feedback that has been exported to Excel from a Microsoft Form. It groups comments by theme—like zoning and traffic impact. The team copies the response into Word with one click.

Example prompt: Summarize all citizen feedback from / UpcomingZoningFeedback.xlsx group by theme.

2. Complete sentiment review

The team asks Copilot to draft a narrative summary of the top themes and sentiment trends. This gives employees a clear storyline for the briefing deck and helps leadership to understand public sentiment ahead of the hearing.

Example prompt: Add a summary of key themes and sentiment

3. Analyze data

Copilot converts the feedback into charts showing frequency of concerns and geographic distribution, turning qualitative input into actionable insights for decision-makers.

Example prompt: Generate charts showing the top five citizen concerns and their frequency by district.

4. Build the briefing deck

Instead of starting from scratch, Copilot generates a structured deck with sections for key themes, visuals, and proposed actions. It applies the correct agency branding and suggest layouts to make information easy to understand.

Example prompt: Create a five-slide briefing deck for the zoning hearing using the two files built earlier: /UpcomingZoningTrends.docx and /UpcomingZoningFeedback.xlsx.

5. Record and transcribe the hearing

Copilot automatically records and transcribes the public hearing in real time, tagging speakers and capturing decisions. This ensures an accurate record without manual note-taking and supports transparency for citizens and auditors.

Microsoft Teams icon

Copilot in Teams

Benefit: Be present during the meeting by relying on Copilot in Teams for transcription and summary.

6. Recap hearing notes and share outcomes

Copilot updates the briefing deck with key decisions, next steps, and community feedback highlights. This provides a clear, actionable summary within hours.

PowerPoint icon

Copilot in PowerPoint

Example prompt: Based on this recap of the zoning hearing add a new slide including decisions, next steps, and updated visuals for the briefing deck.

KPIs

Opportunity to impact key functional area KPIs

How Microsoft Copilot can help maintain budgets

Copilot can be extended into financial systems and other processes to bring data together and speed decision-making based on targets and trends.

Speed data analysis and reporting

  • Quickly analyze trends
  • Generate informative charts
  • Create strategy presentations

Inform your decisions

Improve your data

How Microsoft Copilot can help improve courtroom efficiency

Automate the tracking of Judicial utilization to uncover data insights and increase courtroom efficiency and transparency.

Task organization

  • Ensure critical tasks are addressed first
  • Track multiple deadlines

Save time

How Microsoft Copilot can help improve communications

Copilot streamlines employee creativity and collaboration, reducing the time and effort needed to meet communication demands and bolstering public trust.

Content creation

  • Ideate creative new ways to communicate
  • Tailored content to increase
    engagement and reach
  • Translation to expand global reach
  • Analyze effectiveness to update in real time

Task organization

Meeting insights

How Microsoft Copilot can help reduce procurement cycle time

Enable faster delivery timelines and contract compliance percentage rates to ensure contract terms and are met.

Optimizing Procurement Workflows

  • Reduce time spent on administrative tasks
  • Find knowledge and take action
  • Efficiently draft and format documents
  • Swiftly scan and summarize documents

Advancing Review

Facilitating Decisions

1Access Microsoft 365 Copilot Chat at m365copilot.com, or the Microsoft 365 Copilot Chat mobile app and set toggle to “Web”.

2Access Microsoft 365 Copilot Chat at m365copilot.com, the Microsoft 365 Copilot Chat mobile app, or the Microsoft 365 Copilot Chat app in Teams, and set toggle to “Work”.

3AI Agents allow Copilot to access your organization-specific apps. In the past this would have required an API call to get data from a system of record.

The content in this example scenario is for demonstration purposes only. You should evaluate how Copilot aligns with your organization’s business processes, regulatory requirements, and responsible AI principles.