DEV Community

Cover image for Graphic Guide: Stop Staring at Spreadsheets: Analyze Data with ChatGPT
LOGIHEART
LOGIHEART

Posted on

Graphic Guide: Stop Staring at Spreadsheets: Analyze Data with ChatGPT

A sales spreadsheet can contain hundreds of numbers and still leave a team unsure what to do next. How can ChatGPT help turn a table into useful analysis—and how can the team check that a plausible explanation is supported by evidence?

This comic follows a team working with fictional monthly sales data. They define the decision they need to support, inspect column names, units, and blanks, then use ChatGPT to calculate changes, visualize trends, and explore possible explanations. Along the way, they check formulas and source records and keep confirmed facts separate from hypotheses and next steps.

The team checks a blank against the fictional source note instead of treating it as zero, verifies a percentage formula and chart, and notices that a rising total can hide a fall in store sales. They consider several explanations for rising online sales, while leaving the effect of advertising unconfirmed because the available evidence does not establish it.

A practical workflow is to set the decision, check the data and units, verify calculations and charts, test explanations against more evidence, and report facts, hypotheses, and actions separately. This approach can also help with operations, surveys, and classroom data. Try it with fictional or otherwise permitted data, and check the source behind important numbers. When real business or personal data is involved, follow your organization’s data policy and use an approved AI environment.

LOGIHEART
Toward a society where people and AI understand each other, repair mistakes, and grow together.
LOGIHEART proposes a new relationship between people and AI.

This YouTube video highlights the need to equip future embodied AI that interacts with people with social capabilities. Be sure to check it out!

Top comments (0)