From the course: Excel: Creating a Dashboard with Power Query (Microsoft 365)

Download files to follow along

From the course: Excel: Creating a Dashboard with Power Query (Microsoft 365)

Start my 1-month free trial

Download files to follow along

“

- [Instructor] If you want to create this dashboard from scratch with me, what you need to do first is to save the exercise files to your drive. Now, this is a zipped file, so you're going to need to unzip it. Next, you have a choice to make. Either you can start from scratch so you will start from the file that's called Dashboard_version1. And then you're going to continue with this file until we reach the end. Or if you don't want to start from scratch, but you want to jump in somewhere in the middle what you can do is to download the latest status of the dashboard that's available after each lecture. You're going to find the label of the dashboard at the beginning of that lecture. But here's something that you need to keep in mind because if you're working with one of these solution files, you're going to need to update the source in Power Query for two of the queries that I've listed here. Now, the reason for this is that we're importing external data. This external data was for me sitting on my C drive in this path right here. If you've saved your file somewhere else, and you have a different path for your file, then you need to do this step right here, because otherwise you're going to get this error. Now to do that, I've put this step here. You need to open Power Query so you need to go to Queries and Connections, click on the Queries here, jump back to the source step and browse for the file on your drive. Once you found your file click OK and you'll establish a connection. Okay. So next, let's start with a draft of our dashboard.

Contents