Analyze Data in Seconds | Microsoft 365

Microsoft 365 · Beginner ·📊 Data Analytics & Business Intelligence ·4w ago

About this lesson

Want to turn raw workout data into actionable insights? In this video, we’ll show you how to use Microsoft 365 Copilot to analyze workout data like workout type, duration, frequency, and dates — all with simple prompts. What You’ll Learn: • How to prompt Copilot to analyze raw data effectively • How to generate charts and visual insights automatically • How to identify missing or incomplete data points • How to discover workout trends and performance patterns • How to turn suggestions into an actionable fitness plan Timecodes: 00:00 – Introduction 00:12 – Start with baseline analysis 00:31 – Identify gaps in your data 01:00 – Turn suggestions into an actionable plan Whether you’re looking to build muscle or training for a hike, Copilot can help you uncover insights faster without needing advanced data analysis skills. Try it now in Excel: https://msft.it/6053vcn9d No Microsoft 365 subscription? Try out Copilot and other features free for one month: https://msft.it/6054vcn9e If you found this helpful, make sure to like, subscribe, and comment with other datasets you want to analyze using Copilot. See what else you can do with Copilot in Excel: https://msft.it/6055vcn95 #FitnessTracking #DataAnalysis #WorkoutData

Full Transcript

Let me show you how Copilot can help analyze raw data in Excel. [music] I've been tracking my workouts including things like workout type, duration, and dates and I want to understand the patterns and areas for improvement. To start, I'll ask Copilot for a baseline [music] analysis of my current routine with a prompt like, "Clean up and analyze my workout data, give me insights on my routine, [music] and include charts to visualize any trends and key takeaways." Copilot quickly breaks everything down so it's easy to understand and calls [music] out key observations. Now, let's take this a step further. I'm going on a hiking trip soon that includes some long, challenging [music] trails. I want to see how well I'm preparing for that currently and if there's anything I should adjust, so I'll ask, "Based on this workout data, identify gaps in my routine if I'm preparing for a hiking trip with long distances and elevation. Suggest areas I can improve." Copilot highlights what's working [music] and where I could shift my routine with ideas like adding more leg strength or longer workouts to help build endurance. Let's take these suggestions and turn them into an actionable [music] plan. I can just ask, "In a new tab, create an updated weekly workout plan in a table format based on these new suggestions. Include a column to track completions and a summary section that updates total workouts done and highlights activities missed." And Copilot builds out a structured plan directly in my worksheet so I have something I can actually follow. Now, you can take your data and actually use it to make [music] smarter decisions. Follow along for more ways to get the most out of Copilot.

Original Description

Want to turn raw workout data into actionable insights? In this video, we’ll show you how to use Microsoft 365 Copilot to analyze workout data like workout type, duration, frequency, and dates — all with simple prompts. What You’ll Learn: • How to prompt Copilot to analyze raw data effectively • How to generate charts and visual insights automatically • How to identify missing or incomplete data points • How to discover workout trends and performance patterns • How to turn suggestions into an actionable fitness plan Timecodes: 00:00 – Introduction 00:12 – Start with baseline analysis 00:31 – Identify gaps in your data 01:00 – Turn suggestions into an actionable plan Whether you’re looking to build muscle or training for a hike, Copilot can help you uncover insights faster without needing advanced data analysis skills. Try it now in Excel: https://msft.it/6053vcn9d No Microsoft 365 subscription? Try out Copilot and other features free for one month: https://msft.it/6054vcn9e If you found this helpful, make sure to like, subscribe, and comment with other datasets you want to analyze using Copilot. See what else you can do with Copilot in Excel: https://msft.it/6055vcn95 #FitnessTracking #DataAnalysis #WorkoutData
Watch on YouTube ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Related Reads

📰
Database Internals: 4 Things Every Developer Should Learn Before Writing More Code
Learn database internals to improve coding efficiency and scalability
Medium · Machine Learning
📰
Ranking Numeric Values using Power Query(.pbix included)
Learn to rank numeric values in Power Query for data analysis and comparison
Medium · Data Science
📰
The Data Foundation for Finance Transformation at Enterprise Scale
Learn how to build a canonical finance data repository for enterprise-scale finance transformation, enabling a single source of truth for over 1M daily transactions
Medium · Data Science
📰
Your Pipeline Is 25.4h Behind: Catching Defence Sentiment Leads with Pulsebit
Learn to use Pulsebit's News Sentiment API to catch defence sentiment leads and optimize your pipeline with real-time sentiment analysis
Dev.to · Pulsebit News Sentiment API

Chapters (4)

Introduction
0:12 Start with baseline analysis
0:31 Identify gaps in your data
1:00 Turn suggestions into an actionable plan
Up next
This could be the most perfect data frontend
Matt Williams
Watch →