From the course: Learning Microsoft Copilot for Business Analysis

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Trend analysis with Copilot

Trend analysis with Copilot

- [Tutor] Trend analysis is all about identifying patterns and changes in your data over time. It helps you understand what has happened in the past and helps you predict what might happen in the future. Whether you're looking at sales trends, website traffic or customer behavior, Copilot can help you spot trends that matter. Here's how you can use Copilot for trend analysis. First, start by importing your dataset into Excel or Power BI. In this scenario, we'll be using Excel. Activate Copilot, and ask it to perform a trend analysis on the data. For example, you might want to see sales trends over the past year. Copilot will analyze the data and generate a line chart that shows how sales have changed month to month. One of the coolest things about Copilot is its ability to identify not just obvious trends, but also subtle patterns that you might miss. As is the case in this example where it's identified an outlier in discounts for Mexico on a particular date. In this way, it can…

Contents