Starting a pivot table from the internal data model
Using multiple tables with the internal data model
In the preceding chapters, you use the Power Pivot add-in to work with the internal data model. But as you’ll see in this chapter, you can use a combination of pivot tables and Excel data connections to directly interact with the internal data model, without the Power Pivot add-in.
You can find the sample files for this chapter on this book’s companion website at www.dummies.com/go/excelpowerpivotpowerqueryfd2e. These include the Chapter 5 Sample File.xlsx Excel workbook and the Facility Services.accdb Access database.
Directly Feeding the Internal Data Model
Imagine that you have the Transactions table you see in Figure 5-1, and on another worksheet you have an Employees table (see Figure 5-2) that contains information about the employees.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.