From the course: Microsoft Copilot for Excel

Unlock this course with a free trial

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

Profiling data

Profiling data

From the course: Microsoft Copilot for Excel

Start my 1-month free trial Buy for my team

Profiling data

“

- [Instructor] For the first demo in this section, I want to focus on profiling data. Now, that really is just another way of saying that I want to understand it. So it's not about finding any meaningful insights yet, but more so about making sure that the data here makes sense, it doesn't have any issues, and it passes a general gut check. Let's start by launching Copilot and asking if there are any outliers or extreme values in the data that we may need to be aware of. So, are there any outliers? Send that across. And let's wait to see what we get here. So it looks, let's wait for that to finish up, that it's returning the same insight with the outliers that it suggested when we were analyzing the data earlier. So it's this one right here. So it didn't look for any new insights. It just used the one that it had in its back pocket, which, as we know, wasn't very useful. So, let's try to be more specific and maybe ask if there are any outliers in the age column. Let's send that over…

Contents