Bonus Activities - Microsoft 365 Copilot Training

🎯 Bonus Activities & Advanced Datasets

Explore advanced Copilot scenarios with diverse datasets covering currency analysis, market research, customer segmentation, sales performance, stock market data, and supply chain management. These activities are perfect for teams who want to go beyond the basics.

💱 Currency Comparison Analysis

Dataset: Currency_Comparison.csv (630 rows)

Analyze exchange rate trends, currency volatility, and market movements across USD, CAD, EUR, GBP, JPY, AUD, and MXN over 90 days.

📥 Download Currency Comparison Data

Sample Prompts:

Analyze the currency exchange rate data and identify: which currencies showed the most volatility over the 90-day period, correlation between currency movements, best and worst performing currencies, and any patterns in daily changes. Create a summary report with visualizations.

Compare CAD and EUR exchange rates to USD. Identify periods of significant change, calculate average rates, and provide insights on which currency would be better for international equipment purchases during this period.

Create a currency risk analysis report. Identify currencies with highest volatility, recommend hedging strategies for international transactions, and suggest optimal timing for currency conversions based on historical trends.

📊 Market Analysis & Research

Dataset: Market_Analysis.csv (300 rows)

Comprehensive market data across 5 regions (North America, Europe, Asia-Pacific, Latin America, Middle East) for 5 product categories over 12 months.

📥 Download Market Analysis Data

Sample Prompts:

Analyze market data by region and product category. Identify: largest markets by size, fastest growing markets, regions with highest market share, and seasonal trends. Create a comprehensive market analysis report with recommendations for expansion.

Compare market performance across regions for tractors and combines. Calculate growth rates, identify opportunities, and recommend which regions Western Tractor should prioritize for marketing and sales efforts.

Create a competitive analysis report. Identify markets with highest competitor counts, analyze pricing trends, and provide strategic recommendations for market positioning and pricing strategies.

👥 Customer Segmentation & Analysis

Dataset: Customer_Segmentation.csv (200 rows)

Detailed customer data including purchase history, lifetime value, satisfaction scores, and segmentation by type and region.

📥 Download Customer Segmentation Data

Sample Prompts:

Analyze customer segmentation data and identify: highest value customer segments, customer lifetime value by type, regional distribution patterns, correlation between purchase frequency and satisfaction, and customers at risk of churning. Create a segmentation analysis with recommendations.

Identify customers who: have high lifetime value but low service appointment frequency, purchased equipment 3+ years ago without recent purchases, or have satisfaction scores below 4.0. Create a targeted marketing campaign list with recommended actions.

Calculate customer retention metrics by segment. Analyze: average years as customer by type, purchase frequency patterns, service appointment correlation with retention, and create a customer health score model.

💰 Sales Performance Analysis

Dataset: Sales_Performance.csv (150 rows)

Detailed sales transaction data including sales rep performance, product sales, payment methods, financing terms, and trade-in values.

📥 Download Sales Performance Data

Sample Prompts:

Analyze sales performance data and identify: top performing sales reps by revenue, most popular products, payment method trends, average financing terms, trade-in patterns, and location performance. Create a comprehensive sales analysis report.

Compare sales performance across locations. Calculate: total revenue by location, average sale price, financing vs cash sales ratios, and identify which locations have the highest trade-in activity. Provide recommendations for improving underperforming locations.

Analyze financing trends. Identify: average financing terms by customer type, correlation between financing and warranty purchases, impact of trade-ins on financing decisions, and create recommendations for financing product offerings.

📈 Stock Market Analysis

Dataset: Stock_Market.csv (390 rows)

Daily stock market data for 6 major agricultural equipment companies including prices, volumes, market cap, P/E ratios, and dividend yields.

📥 Download Stock Market Data

Sample Prompts:

Analyze stock market data for agricultural equipment companies. Identify: best and worst performing stocks, volatility patterns, correlation between companies, volume trends, and provide investment insights. Create a stock analysis report with recommendations.

Compare Deere & Company (DE) performance against competitors. Analyze: price trends, volume patterns, P/E ratios, dividend yields, and market cap changes. Provide insights on relative performance and investment attractiveness.

Create a market sector analysis. Identify: overall sector trends, company-specific patterns, risk factors, and create a portfolio recommendation for investing in agricultural equipment stocks with risk assessment.

🚚 Supply Chain & Logistics Analysis

Dataset: Supply_Chain.csv (2,028 rows)

Comprehensive supply chain data including orders, suppliers, parts, delivery times, shipping methods, and warehouse locations over 6 months.

📥 Download Supply Chain Data

Sample Prompts:

Analyze supply chain data and identify: supplier performance metrics (on-time delivery rates), most ordered parts, average delivery times by shipping method, cost trends, and warehouse efficiency. Create a supply chain optimization report.

Identify supply chain issues: suppliers with highest delay rates, parts with longest delivery times, cost variations by supplier, and shipping method efficiency. Create an action plan to improve supply chain reliability and reduce costs.

Analyze inventory and ordering patterns. Identify: parts with highest order frequency, seasonal ordering trends, optimal reorder points, supplier cost comparisons, and create recommendations for inventory management and supplier relationships.

💡 Tips for Using Bonus Activities

Start with the data: Download the CSV file and open it in Excel to familiarize yourself with the structure
Use Copilot in Excel: Upload or open the CSV in Excel and use Copilot to analyze the data
Iterate on prompts: Start with basic analysis and refine prompts to dive deeper into specific insights
Combine datasets: Try analyzing relationships between different datasets (e.g., sales performance vs. customer segmentation)
Create reports: Use Word Copilot to create professional reports based on your Excel analysis
Share insights: Use PowerPoint Copilot to create presentations summarizing your findings

Ready to Explore?

Download any dataset and start analyzing with Microsoft 365 Copilot!

← Return to Main Training Page