Database Reference
In-Depth Information
11. In the PowerPivot model designer, click Get External Data from Other
Sources to launch the Table Import Wizard again. This time select the
text file source. Browse to the
Carriers.csv
file and select the Use
First Row as Column Headers check box. Also change the Friendly
connection name to
Carriers
. You should see sample data similar to
Figure 11.18
Importing CSV data.
12. Repeat the procedure to import data from the
US_Airports.csv
file
with a connection name of
US_Airports
. You should end up with
three tables in the designer.
You use two views to work with the model: the data view and the diagram
view. The data view shows each table in a tab with the data in a grid (see
Figure 11.19
). The area below the grid is where you define measures such as
sum or count to aggregate the data.