Pivot tables allow us to manipulate and display complex data sets into user friendly formats. This can be extraordinarily helpful when trying to extract data from massive database extracts or when reformatting internal data for distribution to other users. However this is the greatest use I have found for pivot tables when trying to align various complex systems. For the purpose of this exercise, we will say we are attempting to align a Change Control Database and an Earned Value System. The data sets used in this example are greatly simplified, but no matter how large or complex your systems may be, these same techniques will allow you to find the deltas between your systems.
This training content is exclusive to members of Plan Academy.
Members can login immediately and get access to this content and a wide collection of eBooks, Webinars, Tutorials and of course our Primarvera Video Course materials. Read our FAQ if you would like more information.Start YOUR Primavera P6 Training Now!