Database Reference
In-Depth Information
How to do it...
The following steps will show you how to create the report for this recipe.
Data model design
This recipe's steps begin with your data model design:
1. Open the Microsoft Excel workbook with this recipe's example query. Click on the
POWERPIVOT
tab and then on the
Manage
button. PowerPivot for Excel is
launched, and you can start editing the data model, as shown in the following
screenshot:
2. In the
Home
tab, select
Diagram View
to see the relationships between the differ-
ent queries in your workbook:
◦ Based on matching data in each table, you can create a relationship
between two tables of data so that Excel can cross-reference rows in one
table with those of another table
◦ In a data model, table relationships can be one-to-one or one-to-many, but
not many-to-many
◦ The data types in the two columns must be compatible