PowerPivot – Combine Data from Multiple Relational Tables into One Table in PowerPivot for Excel

This is the next post in the PowerPivot for Excel Series. In the previous post we saw how to create Linked Tables in Excel, which helps us to maintain a live connection between a working excel and PowerPivot table. In this post, we will see how to combine data from two or more relational tables into a single table in PowerPivot.

Let’s consider this scenario. You have a sales database with a large Sales table in your organization and the data in the Sales Table grows at a rapid pace. To keep the performance in check (and/or for any other reasons), you decide to archive or move the data from the Sales table into a separate table in the same or different database, say annually (to keep things simple). Now, when users need to analyze the sales data for past few years then it requires them to pull the data from all these different tables and consolidate into one single table. In this post let’s see how this scenario can be address by combining the data from multiple sales tables into a single table in PowerPivot for Excel.

To read the full article, go to this link: Combining Data from Multiple Relational Data Sources into One Table in PowerPivot for Excel.

Advertisements

About Dattatrey Sindol (Datta)

Datta is a Microsoft BI Enthusiast, passionate developer, and a blogger. View Full Profile

Posted on March 6, 2013, in MS Excel, MS Office, Power Pivot, Self-Service BI, SQL Server, SQL Server 2012 and tagged , , , , , , , , . Bookmark the permalink. 1 Comment.

What are your thoughts?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: