Database Reference
In-Depth Information
Make sure the “Microsoft Office PowerPivot for Excel 2013” check box is
selected. Now you'll see the PowerPivot tab in the top of the Ribbon and
you can get to work!
STEP 1: uNDErSTAND your DATA
The VI_UNData.bak database contains tables based on United Nations data
collected for a number of countries around the globe. It contains a number
of statistics and facts by country that we'll be using throughout the topic.
For this first example, we'll take a couple of tables and build a simple model.
Open a new workbook in Excel, go to the PowerPivot tab, and click the Manage
icon, as shown to the left in Figure 5-9.
FIguRe 5-9 The PowerPivot Ribbon in Excel 2010
STEP 2: CrEATE your FIrST MoDEL
Now that we have the right add-in configured, let's create our model. There
are a number of ways to do this, but the primary way is to import data from
one or many data sources. For this example, we are going to use the United
Nations data sample from the topic's downloadable iles.
Make sure you have the database restored to an accessible server and then
select your PowerPivot tab and click the Manage icon. Then click “Get External
Data” and choose SQL Server database. In this case, the database is the data-
base backup file you downloaded for this chapter that you should have restored
and made accessible somewhere in your environment. The next several sec-
tions will highlight the steps to load data into your model.
Step 2a: Select your Data Source and Data to Load into your Model
The UN data sample is a SQL database, but remember that the “power” in
PowerPivot comes from the ability to use virtually any source of data and
then combine it with data from other sources. See the following figures for
the process to get your data.
Search WWH ::




Custom Search