![](/images/ORS/Volunteering/ProBono/Pro-Bono-case-studies/Pursing%20Independent%20paths%20image.jpg)
The Approach
The project was split broadly into 3 phases: i) Understand, (ii) Deliver and (iii) Refine.
The Understand phase involved discussions with PIP employees around the data they were collecting and the objectives of the project.
The Deliver phase involved the development and testing of an Excel VBA tool to import data collected by PIP, analysis of the overall data set and display of information in graphical and tabular formats.
The Refine phase involved use of the tool by PIP employees through which a number of enhancements were identified and delivered.
"We are thrilled with the analysis tool and I know it has already helped us make sense of the data we are collecting."