Building Data Relationships in PowerPivot

This post is a follow-up to the previous post titled: “Using PowerPivot’s Copy-Paste Support for Importing Data from Word”.

In this post we will see how we can import data from Microsoft Word using PowerPivot’s copy-paste feature, create relationships on the data and perform aggregations that is BI! :)

For example, consider the two following tables which exist in a sample Word document:

Read more...