D.A.T.A. – The Simple Protocol to Master Data Analysis Using AI

Protocol: D.A.T.A. (Define, Adjust, Transform, Analyze)

The D.A.T.A. protocol simplifies the process of analyzing any dataset using ChatGPT. This clear and actionable framework allows you to move through the key stages of data interpretation, cleaning, transformation, and analysis. With each step, ChatGPT assists you by executing commands that enhance your data’s quality and provide meaningful insights.

Step 1: Define – Understand the Data

The first step is to upload your dataset and have ChatGPT define its structure and content. This is crucial because ChatGPT needs to fully comprehend the data before providing meaningful results.

Action: Upload a .csv file (or any preferred file format) that contains your data.

Prompt: "Act as an expert data analyst with decades of experience and insight.? Please interpret this data using best practices. Once you understand all aspects of it, respond with: 'I understand all aspects of this data and am ready for the next instruction.'"

What Happens:

• ChatGPT examines the dataset, identifies columns and types of data (e.g., numeric, categorical), and flags any initial discrepancies or questions.
• It asks clarifying questions, if necessary, to ensure it understands all key elements of the data.

Once ChatGPT responds with confirmation that it fully understands the data, you are ready to move on to the next step.

Step 2: Adjust – Clean the Data

Once the data is understood, the next step is to adjust or clean it. This ensures that any errors, inconsistencies, or missing data are handled appropriately, making the dataset ready for analysis.

Prompt: "Clean this data. If anything needs adjustment for better analysis, please execute those changes."

What Happens:

• ChatGPT will:
• After cleaning, ChatGPT will offer you a cleaned version of the dataset and provide an option to download it in the original format (e.g., .csv).

Tip: Save the cleaned data, either by replacing the original file or saving it as a separate version.

Step 3: Transform – Explore Patterns & Trends

With clean data, the next step is to transform it into insights. ChatGPT can now look for meaningful patterns, trends, and relationships within the data.

Prompt: "What patterns or trends can you identify in this data?"

What Happens:

• ChatGPT examines the data for:

ChatGPT may ask follow-up questions during this step to better understand the kind of analysis you're looking for. The more you engage with its questions, the deeper it can go into the analysis.

Step 4: Analyze – Visualize & Ask Questions

Finally, ChatGPT can visualize the results of the analysis in different types of charts and graphs to help you better understand the data.

Prompt: "Can you show this data in a [graph type]?"

You can request specific visualizations such as:

• Bar graphs
• Line charts
• Scatter plots
• Pie charts

What Happens:

• ChatGPT generates the requested graph or chart, helping you visualize relationships or trends that are otherwise hidden in raw numbers.
• You can continue asking for different types of visualizations or deeper insights into specific aspects of the data. For example:

By following the D.A.T.A. protocol—Define, Adjust, Transform, Analyze—you can simplify the process of working with data in ChatGPT. This step-by-step framework enables you to:

• Clearly define and understand your dataset.
• Adjust (clean) the data for higher accuracy.
• Transform raw data into meaningful insights.
• Analyze and visualize those insights to make informed decisions.

Make a note to try the DATA protocol on any key data you are currently working with.? Use this article as your guide. Execute each action using each prompt. Pro-Tip: Try this in Claude as well and compare the results. Once you complete your first DATA protocol, message us and let us know how it worked for you.??

SOURCES:

RushTree creates frameworks, protocols and acronyms to explain complex concepts in a simple manner to clients and friends. We consulted with ChatGPT 4o and Claude to experiment with our DATA protocol prompts.

KEY TAKEAWAY:

In the video below, Stephen Tracy shares some basic data analytics use-cases for AI, along with prompts. This may provide some ideas for your own use.

Please remember to like, subscribe and share this newsletter with family, friends and colleagues.

Thank you,

Paul

Paul Blocchi

Founder

rushtree.com