From the course: Excel: Working Together with Power Query and Power Pivot
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Scenario 3: New reports
From the course: Excel: Working Together with Power Query and Power Pivot
Scenario 3: New reports
- [Tutor] In my opinion, nothing highlights the value of a well designed and built Power Pivot and Power Query data model, than creating new reports. Why? Because if this is done correctly, it should only take a minute or so to create a new report using your data. Let's see how. With the Excel file for this video open, head over to the pivot worksheet. What you're looking at here is a report from a data model that we've already prepared. And it's showing electric vehicle sales from the Washington State Department of Licensing. This report shows new sales by location type. But what if I want to see annual sales by say, make and model a vehicle. Go ahead and click on a blank cell anywhere in this worksheet, and then go to insert, and then select pivot chart. What's the most important thing to do here, is select use these workbooks existing data model, and go ahead and select new worksheet. Let's go ahead and click…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.