From the course: Excel: Working Together with Power Query and Power Pivot
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Prepare your query
From the course: Excel: Working Together with Power Query and Power Pivot
Prepare your query
- The best way to prepare our data is to set up something called a query. A query applies steps or mashes up our data, making it easier to analyze down the track. Let's head over to the Query Menu Option here, and then go ahead and select Edit. Clicking this button opens up the Power Query Editor window, and you'll notice Excel's attempt at determining the data type for each column, such as the DOL transaction date here, which is the Department of Licensing transaction date. The calendar icon here identifies that we're working with a date field. When using the query editor, it's only a preview. So any edits that we make here don't actually impact the underlying source data, which is the CSV file. And in fact, when we run the query, it's only applying changes in our Excel data model, not the CSV data that we connected to earlier. Have a look on the right hand side here under Query Settings. You'll see that we already have…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.