Excel Video 512 Multiple Datasets in 3D Maps
To add more features to our discussion of mapping in Excel, we need to add Multiple Datasets in 3D Maps. Excel Video 512 will do just that. Our objective to is plot different sources of data in one tour, or group of maps. For example, we won’t just track referral data, but we will also track the population in each of the zip codes we analyze to give us some perspective on which zip codes should have the most referrals.
Watch how I can create more than one tour in 3D Maps. Also note how when I add multiple datasets in 3D Maps that Excel builds a new layer for each new set of data. Now that I have data, I can manage those layers and the new tour.
Also notice that even though I have multiple datasets in 3D Maps, I can’t mix and match data from the different datasets in one map. If I want to use fields from multiple datasets in 3D Maps, I need to use the Excel Data Model. For more information about the Excel Data Model, watch Excel Video 474 and Excel Video 475. For more information about relationships in the Excel Data Model, watch Excel Video 477. I will much more to say about the Excel Data Model, especially when we get to PowerPivot.
In the meantime, we have multiple datasets in 3D Maps and can start to build layers and customize tours. We’ll start on that in the next Excel Video. Thanks for watching.