Building Data Relationships in PowerPivot

This post is a follow-up to one of my previous posts, titled: “Using PowerPivot’s Copy-Paste Support for Importing Data from Word” and this time, we will be discussing about building data relationships in PowerPivot. To this end, in this post we will see how we can import data from Microsoft Word using PowerPivot’s copy-paste feature, … Read more…

Using PowerPivot’s Copy-Paste Support for Importing Data from Word

One of the great features of SQL Server PowerPivot is that it supports importing data directly from the clipboard. This is quite handy in cases you want to import and analyze data fast. An example of using the above feature is importing data from Microsoft Word. Let’s say you have a Word document containing the … Read more…