ChatGPT Data Analysis Improvements May 2024

OpenAI has rolled out several enhancements to the data analysis capabilities of ChatGPT, enabling users to integrate cloud storage, interact with data in real-time, and create presentation-ready visualizations. These updates are available for ChatGPT Plus, Team, and Enterprise users via the GPT-4o model.

Core Data Analysis Workflow

ChatGPT performs data analysis by writing and executing Python code on the user's behalf. This process allows the model to handle complex data tasks such as cleaning large datasets, merging files, and uncovering insights through natural language commands. This workflow is designed to support both beginners performing in-depth analysis and experts seeking to automate routine data-cleaning tasks.

Direct Cloud Storage Integration

Users can now upload files directly from Google Drive and Microsoft OneDrive, eliminating the need to download files to a local desktop before uploading. This integration supports a variety of file types, including:

  • Google Workspace: Sheets, Docs, and Slides.
  • Microsoft 365: Excel, Word, and PowerPoint.

Interactive Tables and Real-Time Analysis

When a dataset is uploaded, ChatGPT generates an interactive table. This table can be expanded to a full-screen view, allowing users to monitor updates as the analysis progresses. Users can interact with the data by clicking on specific areas to ask follow-up questions or using suggested prompts to deepen the analysis. For example, users can request the creation of pivot tables categorized by expense type from combined spreadsheets of monthly expenses.

Customizable and Downloadable Charts

ChatGPT now supports interactive bar, line, pie, and scatter plot charts. Users can hover over chart elements, change colors, and ask additional questions to refine the visualization. Once finalized, these charts can be downloaded for use in external documents and presentations. For chart types not explicitly supported as interactive, ChatGPT will generate a static version.

Data Privacy and Security

OpenAI maintains specific privacy controls for different user tiers:

  • ChatGPT Team and Enterprise: Data from these customers is not used for model training.
  • ChatGPT Plus: Users can opt out of training through the system's Data Controls.

Enterprise users also have access to SAML SSO, data encryption, and compliance features to ensure secure data handling.

Sources