The two most recognised tools in project planning are Microsoft Project and Primavera P6. Both have different approaches to managing project information and data, especially regarding the way information and data are handled.

MS Project: File-based approach

File structure:

MS Project uses a structure based on independent files. Project data is stored in files with extensions such as MPP, Microsoft Project Plan, MPX, Microsoft Project Exchange, and other compatible formats such as XML. Each file contains all project information, including tasks, resources, calendars, relationships and other data.

Portability and access:

MS Project files are portable, which means they can be easily transferred from one place to another, attached to emails and opened in different instances of the software, provided the version is compatible. This facilitates access and collaboration in environments where file sharing is common.

Scalability limitations:

Although MS Project is suitable for small and medium-scale projects, it can face limitations when handling very large projects or multiple interrelated projects because management is based on individual files. Managing shared data or concurrent updates can be more complicated.

Learning curve and ease of use:

One of the main advantages of MS Project is its similarity to Microsoft Excel, which significantly reduces the learning curve. As in Excel, MS Project allows formulas and calculations to be used to automate and customise project data. MS Project also allows the creation of charts similar to those that can be created in Excel, generating visual and easy-to-understand reports.

Primavera P6: Database-based approach

Database structure:

Primavera P6, on the other hand, uses a database-based approach. Project information is stored in a relational database, generally in systems such as Oracle or Microsoft SQL Server. This allows all information to be centralised and accessible from any instance of the software with the appropriate permissions.

Scalability and collaboration:

Thanks to its database structure, Primavera P6 is highly scalable and can manage very large and complex projects with multiple interdependencies. It allows simultaneous collaboration by multiple users, who can access and update project information in real time, ensuring that all data is always synchronised.

Security and access control:

Databases allow more robust access control, with the possibility of defining detailed roles and permissions for each user. This ensures that only authorised people can view or modify certain parts of the project information, increasing data security and integrity.

Summary of characteristics

Portability:

  • MS Project: High, because of its file-based approach, with files that can be transferred and shared easily.
  • Primavera P6: Low in terms of individual files, but high in terms of remote access through the centralised database.

Scalability:

  • MS Project: Limited, suitable for small and medium projects.
  • Primavera P6: High, ideal for large and complex projects.

Collaboration:

  • MS Project: More limited collaboration.
  • Primavera P6: Advanced collaboration with multiple users accessing and updating data simultaneously.

Security and access control:

  • MS Project: Basic, based on file system security.
  • Primavera P6: Advanced, with detailed access controls and user-level permissions.