It shows the task hours of two resources in different months. Let’s begin to understand pivot tables with the help of an example. As an alternative, if the MSP data is not too large, you can simply copy and paste from MSP’s Gantt Chart View to an Excel worksheet. This can be easily done by going to File > Save Project As File, and choosing Excel Workbook as the file type. In order to use Excel’s pivot tables for analyzing MSP data, you will have to first export MSP data to MS Excel.
Using excel for data analysis how to#
This article follows up on my previous article, where I covered the utility of Excel for scheduling and how to import Excel data in MSP. In this article, you will learn how to exploit Excel’s pivot tables for analyzing MSP data. I have written this article to take you beyond MSP’s Visual Reports capabilities. In fact, these Visual Reports use Excel’s data analysis features to analyze MSP schedule data. Microsoft introduced Visual Reports in MSP 2010, but as a whole, MSP still lacks universal appeal. The advantage of Excel is that it is more commonly used and can analyze any type of data. It also provides different views like Resource Usage View and Tracking Gantt View for analyzing different aspects of a project schedule.Īre these features are enough? Can MS Excel help you in any way beyond those items? You probably know that MSP has a whole host of features for analyzing project schedules like Task Filters, Sorting, and Reports. So, which one should you use for schedule analysis? Excel is also a great tool for analyzing any type of data. MS Project (MSP) is an excellent tool for preparing and tracking project schedules.