1 of 33

Copilot

The AI Sidekick You Didn’t Know You Had

Trevor Hart

Institutional Research

Eastern Arizona College

2 of 33

Agenda

Topic	Session
Introduction	Introduction to Copilot
Prompting Basics	Learn how to write prompts for Copilot to get the best results.
Demo	Demo Video will walk through examples of how Copilot can be used to accomplish tasks large and small.
Bonus (time permitting)	Copilot Agents Copilot in SSMS (SQL Server Management Studio) Copilot in Power Automate
Closing	Recap

3 of 33

Copilot

4 of 33

Copilot Chat Experiences

5 of 33

Learn how to prompt Copilot

6 of 33

Learn how to prompt Copilot

7 of 33

Saving Prompts

8 of 33

Sharing Prompts

9 of 33

Be More Productive

Source: Survey of Microsoft 365 Copilot Early Access Program users, October 2023; The missed meeting’ study; ‘Email effectiveness’ study; The strain of searching’ study.

10 of 33

Demo

Now, let's move to the practical demonstration
You will see Copilot in action shortly.
Prepare to witness real-world applications.

Note: Copilot in PowerPoint helped create this slide

11 of 33

Video size to large to include in slide deck.

12 of 33

Copilot Agents

13 of 33

Copilot Agents

https://copilotstudio.microsoft.com/

Copilot Agents home screen

Ask Copilot to create an agent
Access already created Copilot Agents

14 of 33

Create Copilot Agent: Step-by-Step

Ask Copilot to create an agent
Specify what the agent purpose is
Explain what the agent should be able to do
Give Agent a name

1

2

3

4

15 of 33

Create Copilot Agent: Step-by-Step

Define more clearly what the agent should do
Define how the agent should interact with users
Identify any constraints or limitations

5

6

7

16 of 33

Create Copilot Agent: Step-by-Step

Add a Website

8

17 of 33

Create Copilot Agent

18 of 33

Customize Copilot Agent

19 of 33

Provide Documents and Test Agent

20 of 33

Publish Copilot Agent

21 of 33

Interact with Published Copilot Agent in SharePoint

Publish Agent to SharePoint site
Ask Agent specific questions about the documents provided to it

22 of 33

Copilot - SSMS (SQL Server Management Studio)

23 of 33

Copilot - SSMS

“Copilot in SSMS is not about replacing you as a person; it’s there to empower every data professional to be more capable and productive than they are today. ”
Copilot understands your SQL database
Copilot interacts with your database based on the questions you ask.

Source: https://techcommunity.microsoft.com/blog/sqlserver/announcing-the-preview-of-copilot-in-sql-server-management-studio-ssms/4415267

24 of 33

Copilot - SSMS

Ask Copilot about databases you are connected to
Request assistance with writing, troubleshooting, and fixing queries
Ask Copilot to query data in a specific databases

Copilot will run SQL queries in the background and give you the results in the chat widow

Additional scenarios

Scenarios - Copilot in SQL Server Management Studio | Microsoft Learn

25 of 33

Copilot - Power Automate

26 of 33

Copilot - Power Automate

Ask Copilot to create workflow

27 of 33

Copilot - Power Automate

Ask Copilot to add additional actions
After all actions needed have been added, click “Keep it and continue”

28 of 33

Copilot - Power Automate

29 of 33

Copilot - Power Automate

Copilot helps you code actions in your flow
Ex. add date and time to files name

30 of 33

Troubleshoot workflows with Copilot (Assist me)

31 of 33

Recap

Topic	Session
Introduction	Introduction to Copilot
Prompting Basics	Learn how to write prompts for Copilot to get the best results.
Demo	Demo Video will walk through examples of how Copilot can be used to accomplish tasks large and small.
Bonus (time permitting)	Copilot Agents Copilot in SSMS (SQL Server Management Studio) Copilot in Power Automate
Closing	Recap

32 of 33

Thank you!

Trevor Hart

Institutional Research

Trevor.hart@eac.edu

1 of 33

2 of 33

3 of 33

4 of 33

5 of 33

6 of 33

7 of 33

8 of 33

9 of 33

10 of 33

11 of 33

12 of 33

13 of 33

14 of 33

15 of 33

16 of 33

17 of 33

18 of 33

19 of 33

20 of 33

21 of 33

22 of 33

23 of 33

24 of 33

25 of 33

26 of 33

27 of 33

28 of 33

29 of 33

30 of 33

31 of 33

32 of 33

33 of 33