Microsoft Office Tutorials and References
In Depth Information
Understanding the Internal Data Model
With a Data Model–driven pivot table, you can merge disparate data sources into one analytical
engine. Figure 17-13 demonstrates how you can build a view using data fields from the different
tables in the Data Model.
Figure 17-13: With a Data Model–driven pivot table, you can analyze data using the fields for each table in the
Using external data sources in your internal Data Model
The internal Data Model isn’t limited to using only data that already exists in your Excel workbooks.
You can fill your Data Model with all kinds of external data sources. In Chapter 18, you dive into
using external data sources in your dashboarding models. Now, though, take a look at how to bring
external data sources into the Data Model.
Say that you have an Access database that contains a normalized set of tables. You want to analyze
the data in that database in Excel. You decide to use the new internal Data Model to present the data
you need through a pivot table.
You can find the Facility Services Access database on this topic’s companion website at
On the Web
To use external tables in your Data Model, follow these steps.
1. On the Data tab of the Ribbon, select the From Access icon, as shown in Figure 17-14.
Figure 17-14: Click the From Access button to get data from your Access database.