From the course: Copilot in Excel: AI-Powered Financial Planning & Analysis

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Solution: Import and analyze new data from Power Query

Solution: Import and analyze new data from Power Query

From the course: Copilot in Excel: AI-Powered Financial Planning & Analysis

Start my 1-month free trial Buy for my team

Solution: Import and analyze new data from Power Query

“

(bright electronic music) - [Instructor] So, how did you do? In this challenge, I asked you to use the 2018 and 2019 data and analyze which 10 employees were issuing the most discounts, and further, whether there appeared to be a relationship between the discounts they're giving and the total net orders. So, in other words, were discounts leading to higher sales numbers as we might expect or not? So, let's take a look. The first step that I'm going to do is I'm going to go into my Excel file. I'm going to make sure that AutoSave is on, and I'm going to go over here to my Data ribbon. On the left, I'm going to click on Get Data, From File, From Folder. Now, here, I have the ability to choose which folder I want to be locating. In this case, I'm going to locate the Red30 Sales Data. Within the Red30 Sales Data, while you cannot currently see it, I do have the 2018 and 2019 data. I'm going to click Open, and there we go. Just for good measure, I'm going to show you what the individual…

Contents