CHAPTER 36
Working Directly with the Internal Data Model
Up until now, you used the Power Pivot Ribbon interface to work with the internal data model. As you will discover in this chapter, however, you can use a combination of PivotTables and Excel data connections to interact directly with the internal data model—without the Power Pivot Ribbon interface.
|
Most of the examples in this chapter are available on this book's website at |
Directly Feeding the Internal Data Model
Imagine that you have the Transactions table shown in Figure 36.1. On another worksheet, you have an Employees table (see Figure 36.2) that contains information about the employee.
FIGURE 36.1 This table shows transactions by employee number.
FIGURE 36.2 This table...
