Database Reference
In-Depth Information
Figure 5-16 shows the second clean-up step where you rename your columns
to something more usable. You can right click on the column header and select
Rename. This will then edit the model right there and persist the change. You
can see this renaming in Figure 5-16.
FI gu R e 5-16
Renaming columns
STEP 3: DoES your MoDEL WorK?
To test your model, let's explore it in Excel. Click the PivotTable button on the
Home tab in the Ribbon, as shown in Figure 5-17.
Now that we know we can use our model, let's take a look at some things that
Excel can do for us. The next section will build some tables and visualization
on top of this foundation.
