Project Management Institute (PMI)® Professional Development Units (PDUs):
This Webinar is eligible for 1 PMI® PDU in the Technical category of the Talent Triangle.
Even though Project Pro for Office 365 is available through a monthly subscription, there are many companies and individuals who still use old versions of MS Project (Project 2010, Project 2007 and – believe or not – Project 2003) to track their schedules. All these people sometimes struggle on trying to create reports to quickly understand their project performance, once the reporting mechanism in old versions of the software is not as good as the mechanism that was introduced with the launch of Project 2013.
What most people do not know is that it is possible to export data from MS Project to a MS Access database. By doing this, we can then connect to the database with MS Excel and create beautiful, interactive dashboards, getting quick insights of the key project information. Also, this approach provides the user with the ability of keeping the report up-to-date, and also to reproduce the report for other projects if needed.
The key take-aways of this presentation are:
- Knowing how to export data from Project to a MS Access Database
- Knowing the information that is exported and how to manage it
- Knowing how to use MS Excel to connect to the database
- Creating a beautiful, interactive status report
- Keeping the report up-to-date
- Using the report for other schedules
Raphael Santos is a PPM enthusiast, with expertise in providing Microsoft Project and Project Server solutions. He has worked in several projects to implement PPM tools, including countries in Latin America (Brazil, Peru and Argentina) and Africa. He is also a trainer, with more than 10 years of experience in teaching users on how to use Project Management tools in a more productive way. Raphael works at Sensei Project Solutions, a company that offers a set of services to help an organization make their Microsoft PPM deployment successful, including full implementation and services, training as well as pre-configured solutions and Report Packs. You may contact him at email@example.com
Have you watched this webinar recording? Tell MPUG viewers what you think!