This challenge is very interesting. I have challenged ChatGPT to create a game chart from the data of a given project. I prepared a set of data in a CSV file to compare how good ChatGPT is. The result is surprisingly good. It’s Christian from Vision 6D, and I’m here to share my knowledge and help you level up your skills. I train and consult for companies. To achieve this result with ChatGPT, I worked with Advanced Data Analytics. The process we followed is called ETL (Extract, Transform, Load), which is well known by data analysts.
The first line of the extracted file is the header of the different columns, including the name of the test, duration, start date, finish date, resources, work, and costs. The duration column needs some transformations since it contains values in different units. In my first prompt, I asked ChatGPT to transform the duration to a consistent unit and remove the time from the date.
I also informed ChatGPT that NaN values are non-applicable and that weekends are non-working days. To validate the data, I asked ChatGPT to tell me about the project and provide the number of activities, start and finish dates. Based on the activities, ChatGPT informed me that the project consists of 34 activities, starting on April 17th and ending on October 2nd. It also identified the project as the installation of a CRM system.
This capability of interpreting the data is fascinating. As a project manager, it opens up new perspectives. To further validate the data, I asked ChatGPT to generate a table with all the information. It successfully generated the table, confirming that it has all the necessary information.
Next, I asked ChatGPT to generate a Gantt chart. Comparing the Gantt chart generated by ChatGPT with the one created in MS Project, we can see that the task names, duration, start date, and finish date are exactly the same in both representations. The Gantt chart from ChatGPT also includes milestones represented by red diamonds.
One thing that is not represented in the Gantt chart is the relations between tasks, such as predecessors and successors. However, this representation is still usable and provides valuable insights. Advanced data analytics is opening new perspectives for project managers.
To illustrate this, I asked ChatGPT to extract the different tasks for each resource in the project. The result was positive, showing how our profession as project managers is evolving. I’m excited to see your experiments and hear your feedback. See you soon in another module. Bye bye!
