Group 6 Briefing

Microsoft 365 Copilot Training - Western Tractor

Welcome Group 6!

πŸ‘₯ Your team: Twan V, Jasen M, Jordan M, Tad H, Nathan A

You're about to embark on a hands-on learning journey through four carefully designed activities that will help you master Microsoft 365 Copilot. Each activity is structured to give you multiple approaches to solving real-world business challenges.

Throughout these exercises, you'll work with actual Western Tractor scenarios, using realistic data and situations you might encounter in your daily work. This isn't just about learning Copilotβ€”it's about discovering how AI can enhance your productivity and help you deliver better results for our customers.

What makes this training unique: Each activity includes multiple prompting approaches, so you can compare different methods and discover which techniques work best for different situations. You'll also explore various analysis types and learn to identify key insights that drive business decisions.

πŸ“š Bonus: Case Study

Explore a real-world decision scenario: Western Tractor faces a supply chain crisis due to US tariffs. Follow Sarah Chen, Supply Chain Manager, as she must decide whether to use Microsoft 365 Copilot to navigate the crisis.

Read Case Study β†’

πŸ“‹ Quick Navigation

πŸ“§ Activity 1πŸ“Š Activity 2πŸ’¬ Activity 3πŸ’‘ Activity 4

πŸ“§ Activity 1: Customer Communication Challenge

Duration: 20 minutes | Focus: Promotional Content & Marketing

Why this matters: Develop your ability to create promotional content that drives sales while maintaining brand integrity. You'll explore how different messaging approaches can influence customer behavior and engagement.

πŸ“ Your Data File:

Customer_Communication_Template_Group6.txt

This file contains all the customer information you'll need, including purchase details, contact information, and service department details. Open it before you begin and familiarize yourself with the content.

Your Task:

Use Word Copilot to draft a parts promotion announcement for your assigned customer. Your goal is to create a communication that feels personal, professional, and aligned with Western Tractor's brand values.

Multiple Prompting Approaches:

Approach 1: Context-Rich Prompting

This approach involves providing Copilot with comprehensive background information upfront. By giving detailed context, you help Copilot understand the full picture and generate more accurate, relevant output.

Try this prompt:

Draft a parts promotion announcement for [Customer Name] who recently purchased [Equipment]. Highlight our upcoming parts sale (20% off select parts), mention parts relevant to their equipment, include sale dates (November 20-30, 2024), and provide ordering information. Use an engaging, promotional tone.

Analysis Focus: Notice how providing detailed context upfront results in a more complete output. Compare the specificity and relevance of this approach to the others you'll try.

Approach 2: Iterative Refinement

This method starts with a simple prompt and gradually adds detail through follow-up requests. It's useful when you're exploring ideas or when you want to see how Copilot's output evolves with additional guidance.

Step 1 - Basic Prompt:

Write a parts promotion announcement.

Step 2 - Add Details: After reviewing the initial output, ask Copilot to "Make it more personal and include specific information from the customer data file."

Step 3 - Refine Format: Finally, request "Adjust the format to be more professional and easier to read."

Analysis Focus: Compare the final result with Approach 1. Which method produces better results? Consider the time investment versus output quality.

Approach 3: Template-Based Prompting

This approach provides Copilot with a clear structure to follow. It's particularly effective when you need consistent formatting or when working with established document types.

Try this prompt:

Create a parts promotion announcement with: 1) Attention-grabbing headline, 2) Sale details and dates, 3) Relevant parts for customer's equipment, 4) Special offers or discounts, 5) How to order. Use the customer data to personalize the content.

Analysis Focus: Notice how structured prompting ensures all necessary elements are included. Compare this approach's completeness to free-form prompts.

πŸ’‘ Key Insights to Explore:

  • Which prompting approach produces the most effective output for your specific task?
  • How does Copilot handle specific customer details from your data file? Does it incorporate them naturally?
  • What tone and style adjustments work best for Western Tractor's brand? How can you guide Copilot to match your brand voice?
  • How can you verify the output includes all necessary information? What quality checks should you perform?

Questions to Work Through:

  1. What happens if you ask Copilot to revise the output for a different audience (e.g., a commercial customer vs. a residential customer)?
  2. How can you use Copilot to check for professionalism and brand consistency? Try asking it to review the output against Western Tractor's communication standards.
  3. What's the best way to incorporate specific details from your data file? Experiment with referencing the file directly versus copying information into your prompt.

πŸ“Š Activity 2: Data Analysis & Reporting

Duration: 20 minutes | Focus: Sales Data Analysis & Trend Identification

Why this matters: Data analysis is at the heart of informed business decisions. In this activity, you'll learn how Copilot can help you quickly identify patterns, trends, and insights from sales data that would take hours to discover manually. You'll explore different analytical approaches and discover which questions yield the most actionable results.

πŸ“ Your Data File:

Q4_Sales_Data_Group6.csv

This CSV file contains Q4 sales data with information about transactions, locations, equipment types, customer categories, and payment methods. Open it in Excel before starting your analysis.

Your Task:

Use Excel Copilot to analyze Q4 sales data and identify key trends for management. Your goal is to uncover insights that can inform Q1 strategy and help leadership make data-driven decisions.

Multiple Analysis Approaches:

Approach 1: Exploratory Analysis

This approach involves asking a series of questions to explore the data from different angles. It's like having a conversation with your data, where each answer leads to new questions.

Try these prompts in sequence:

  1. "Analyze the Q4 sales data and identify the top 3 equipment categories by total sales."
  2. "Calculate the average sale price for each location (Lethbridge, Taber, Burdett, Medicine Hat)."
  3. "What patterns do you see in payment methods across different customer types?"

Analysis Focus: Notice how each question builds on the previous one, revealing different aspects of the data. This exploratory approach helps you discover insights you might not have initially considered.

Approach 2: Comparative Analysis

This method focuses on comparing different segments of your data to identify differences, similarities, and patterns. It's particularly useful for understanding performance across locations, customer types, or time periods.

Try this prompt:

Compare sales performance across all four locations. Create a summary showing: total sales by location, average transaction value, most popular equipment category per location, and payment method preferences. Highlight any significant differences or trends.

Analysis Focus: Notice how comparative analysis provides actionable insights by showing relative performance. This type of analysis helps identify best practices and areas for improvement.

Approach 3: Predictive Insights

This approach uses historical data to identify trends and patterns that suggest future opportunities or challenges. While Copilot can't predict the future, it can identify patterns that inform strategic planning.

Try this prompt:

Based on the Q4 sales data, what trends suggest opportunities for Q1? Identify which customer types, equipment categories, or locations show growth potential. Provide recommendations for sales strategy.

Analysis Focus: Consider how well Copilot identifies forward-looking insights from historical data. Evaluate whether the recommendations are practical and aligned with Western Tractor's business model.

πŸ’‘ Key Insights to Explore:

  • Which location shows the strongest sales performance and why? What factors might contribute to this success?
  • What equipment categories are trending upward? Are there seasonal patterns you should consider?
  • How do payment methods vary by customer type? What does this tell you about customer preferences and financial situations?
  • What recommendations can you make for Q1 sales strategy? How can you use these insights to improve performance?

Questions to Work Through:

  1. How can you use Copilot to create visualizations (charts) from the analysis? Try asking it to suggest appropriate chart types for different data comparisons.
  2. What happens when you ask Copilot to identify anomalies or outliers in the data? These might indicate data quality issues or unusual business events.
  3. Can Copilot help you format the analysis for a management presentation? Experiment with creating executive summaries and formatted reports.

πŸ’¬ Activity 3: Meeting Efficiency Challenge

Duration: 20 minutes | Focus: Meeting Preparation & Agendas

Why this matters: Learn to create effective pre-meeting materials that maximize meeting productivity. You'll discover how well-prepared participants lead to more focused discussions and better outcomes.

πŸ“ Your Data File:

Service_Meeting_Transcript_Group6.txt

This transcript contains a realistic service department meeting discussion. Read through it to understand the context, then use Copilot to extract the information you need.

Your Task:

Use Teams Copilot or Word Copilot to Create pre-read outline for next meeting. Your output should be clear, well-organized, and immediately useful to team members who weren't present at the meeting.

Multiple Prompting Approaches:

Approach 1: Comprehensive Summary

This approach creates a complete overview of the meeting, capturing all major discussion points, decisions, and outcomes. It's ideal when you need a full record of what happened.

Try this prompt:

Create a pre-read outline for next week's service department meeting based on the action items and topics discussed in this transcript. Format as a structured outline with: agenda items, background information, discussion points, and expected outcomes.

Analysis Focus: Evaluate how comprehensive the output is. Does it capture all important points? Is anything missing that should be included?

Approach 2: Structured Extraction

This method asks Copilot to extract specific types of information and organize it in a structured format. It's useful when you need particular details formatted consistently.

Try this prompt:

Extract key information from this meeting to create a pre-read document. Include: background context, key decisions that affect next week's meeting, action items that need follow-up, and discussion topics that should be continued. Format as a concise pre-read.

Analysis Focus: Notice how structured prompting ensures consistent formatting and complete extraction. Compare this to the comprehensive summaryβ€”which approach better serves your needs?

Approach 3: Executive Summary

This approach creates a concise, high-level overview suitable for busy managers who need key information quickly. It focuses on what matters most and why it's important.

Try this prompt:

Create an executive pre-read summary for next week's meeting. Highlight: key topics to discuss, decisions that need to be made, action items requiring follow-up, and background information managers need to know. Keep it concise and actionable.

Analysis Focus: Compare the executive summary to the comprehensive summary. How does the level of detail differ? Which format is more appropriate for different audiences?

πŸ’‘ Key Insights to Explore:

  • What topics should be on next week's agenda? How do you determine what's most important?
  • What background information is needed for next week's discussion? How can you provide context efficiently?
  • What decisions need to be made in the next meeting? What information is required to make them?
  • How can the pre-read improve meeting efficiency? What makes a pre-read effective?

Questions to Work Through:

  1. Can Copilot identify which topics need more discussion time? Try asking it to estimate time needed for each agenda item.
  2. How can Copilot help identify missing information needed for next week's meeting? What gaps exist in the current discussion?
  3. What happens when you ask Copilot to estimate time needed for each agenda item? How accurate are these estimates?

πŸ’‘ Activity 4: Creative Problem Solving

Duration: 10 minutes | Focus: Schedule Template Creation

Why this matters: Build a practical scheduling template that helps manage maintenance activities efficiently. This activity shows how Copilot can help you create tools that improve operational planning and resource allocation.

πŸ“ Reference Data (Optional):

Parts_Inventory.csv

This reference data may be helpful for your scenario, but feel free to be creative and think beyond what's provided. The goal is to solve the problem effectively, not to use every available resource.

Your Scenario:

Create a preventive maintenance schedule template. Think creatively about how Copilot can help you build something practical and useful for Western Tractor's operations.

Multiple Prompting Approaches:

Approach 1: Functional Requirements

Start by clearly defining what the solution needs to do. This approach ensures you build something that meets actual business needs rather than just being technically impressive.

Try this prompt:

Create a preventive maintenance schedule template for equipment. Include: service intervals, required tasks, parts needed, and service history tracking. Format as an easy-to-use schedule.

Analysis Focus: Evaluate whether the output meets all functional requirements. Is it complete? Does it solve the problem effectively?

Approach 2: Enhanced Features

After creating a basic version, iterate to add enhancements that make the solution more powerful and user-friendly. This demonstrates how Copilot can help you refine and improve your work.

After creating the basic version, try:

Enhance the maintenance schedule by adding: cost tracking, parts inventory integration, service reminders, and maintenance history reports. Make it more functional.

Analysis Focus: Notice how iterative prompting allows you to build complexity gradually. Compare the enhanced version to the basic oneβ€”what improvements were made?

Approach 3: Integration with Data

This approach explores how your solution can connect with existing data sources, making it more powerful and reducing manual data entry. It demonstrates Copilot's ability to help you think about system integration.

Try this prompt:

Create a maintenance schedule that integrates with parts inventory data. Include automatic parts ordering suggestions and cost tracking based on actual parts prices.

Analysis Focus: Consider how data integration makes your solution more powerful. What additional capabilities does this approach enable? How practical are these integrations?

πŸ’‘ Key Insights to Explore:

  • What features does the schedule include? Are they practical and useful?
  • How can the schedule be made more practical? What would make it easier to use?
  • What would make this schedule more effective? How can you ensure adherence?
  • How can you test the schedule with actual equipment? What real-world factors matter?

Questions to Work Through:

  1. Can Copilot help optimize the schedule timing? What factors affect timing?
  2. How can you use Copilot to add reminders? What triggers would be helpful?
  3. What happens when you ask Copilot to create a mobile-friendly version? What changes?
← Back to Main Page