Handling missing financial reporting data with AI

In this section, we will use ChatGPT to help us understand what our sample Excel files contain and check for any outliers, missing values, and data inconsistencies. We will be using datasets created specifically for this section to get more appreciation for this tool’s capabilities. The steps are as follows:

1. Create a new chat using the Data Analysis GPT, as shown in Figure 10.34. As an alternative, you may use the Advanced Data Analysis feature (using GPT-4), as shown in Figure 10.13.
   

   Figure 10.34 – Using the Data Analysis GPT

Note

If you can’t access the Data Analysis GPT from the Explore section in the sidebar, you may use this link: https://chat.openai.com/g/g-HMNcP6w7d-data-analysis.

2. Load the 2022 Transactions.xlsx, Products.xlsx, and Sales Price.xlsx files and type this prompt:

   Please examine the contents of these three files and provide information as to...