Note details

Study: GPT-4 outperforms Data Analysts

BY wkil7
June 5, 2025
Public
Private
8387 views

Research Paper Summary: Evaluating GPT-4 as a Data Analyst

Objective

The research paper explores the performance and efficiency of GPT-4 as a data analyst compared to human analysts. The study aims to discover how GPT-4 can be integrated into the data analysis process to enhance productivity without causing job anxiety.

Study Framework

The study outlines a framework to explore three major job scopes of a data analyst:

  1. Data Collection: Involves using SQL to connect databases and extract insights.
  2. Data Visualization: Utilizes Python to create graphs and charts.
  3. Data Analysis: Extracts major insights into a bullet-like format for actionable data.

Experimental Set-Up

  • Prompt Design: GPT-4 was tasked with solving business questions involving SQL databases and generating visual data outputs.
  • Data Sets and Questions: Involved over 1,000 questions tested across databases spanning five domains and supported seven types of visualizations.
  • Comparison: GPT-4's performance was compared against two senior analysts, two junior analysts, and one intern analyst.

Key Findings

  1. Cost Efficiency:

    • GPT-4 incurs minimal costs compared to human analysts, costing 5 cents per instance.
    • Cost efficiency compares as follows: 2.5% of intern cost, 71% of junior analyst cost, 0.45% of senior analyst cost.
  2. Speed:

    • GPT-4 was significantly faster in completing tasks, averaging around a minute for tasks, compared to minutes for human analysts.
  3. Performance:

    • GPT-4 outperformed junior analysts and interns, with comparable performance to senior analysts in many cases.
    • GPT-4 lacked domain knowledge without internet access, yet performed adequately in dependent data scenarios from databases.
  4. Practicality and Scenarios:

    • The study used specific questions, leading to considerations that practical, open-ended questions might present different challenges.
    • GPT-4 was challenged in practical scenarios where questions were less specific and more open-ended.

Conclusion

  • GPT-4 has the potential to supplement human data analysts by enhancing efficiency, particularly in routine tasks.
  • Further studies are recommended to explore the integration of GPT-4 and similar technologies in data analysis, especially in understanding its limitations and capabilities in real-world, less structured tasks.

Implications

  • The study emphasizes the exploration of AI capabilities to assist human analysts rather than replacing them, promoting collaboration between AI tools and human expertise to optimize workflows in data analytics.

Call to Action

Explore further studies and applications of AI in data analytics. Consider how AI can be utilized to streamline various stages of data analysis to enhance productivity.

    Study: GPT-4 outperforms Data Analysts