Detecting anomalies in financial transaction data

In this example, we will work on the datasets we used in the Dealing with large financial datasets using data validation section in Chapter 5, Using Business Intelligence Tools to Fix Data Integrity Issues. We will test whether we can validate the data against another table containing the correct values. The steps are as follows:

1. Create a new chat using the Data Analysis GPT, as illustrated in Figure 10.7:
   

   Figure 10.7 – Using the Data Analysis GPT

   To access the Data Analysis GPT, click on Explore in the sidebar and select Data Analysis from the list of GPTs available. If you can’t see the GPTs, feel free to use the following link to access this: https://chat.openai.com/g/g-HMNcP6w7d-data-analysis.

Note

You may also search for chatgpt data analysis gpt via Google Search; you should find the GPT in the list of results. Alternatively, you may use GPT-4 as it has the Advanced...