PowerPivot – Combine Data from Multiple Relational Tables into One Table in PowerPivot for Excel
Posted by Dattatrey Sindol (Datta)
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.
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 Ad-hoc Reporting, Excel, Microsoft BI, Microsoft Excel, MSBI, Power Pivot, Self-Service BI, SQL Server, SQL Server BI. Bookmark the permalink. 1 Comment.