5.Create Pivot Table using joined Tables in Power Pivot

Hello Friends! In our previous video series, we have learned how to tame the unstructured data to a proper structure which is worth or self-sufficient to answer the business queries. If you have not visited the video series I would strongly recommend you to first have a look to it as it is the foundation of the entire Business Intelligence using Microsoft Excel. I will forward the link to the playlist below. https://www.youtube.com/watch?v=cQjUxoLDWlw&list=PL-FrRPAaIO08U3lfW4U7bymyi9_pnIv8a Once you are comfortable in handling unstructured data the next step would be to use the data model to create some sort of summary which would help you to judge the data and assist to solve the business problem. In this video series, you would learn how to use MS Power Pivot. In excel we have used Pivot table to create summaries however those Pivot Tables were single dimensional which can only handle single table at a time. In this video series we would see how Power Pivot helps you to play along with Multiple tables and gives you the capabilities to play around Multi-Dimensional environment. So, let’s start our journey… Happy Learning.