Data Analysis

Tutorial: Finding Insights from Excel Data

Analyze data just by chatting with AI—no complex analysis tools needed. Ask what you're curious about and the AI explores the data to find answers.

Scenario

You have a CSV file with a year's worth of customer purchase data. You want to understand which products sell well and what the customer purchasing patterns are.

Getting Started

Step 1: Understand the Data

First, check what the data looks like:

"@purchases.csv Show me the structure of this file"

The AI reads the file and summarizes column info, row count, and basic statistics.

Step 2: Ask Questions

Now ask what you're curious about:

"What's the monthly sales trend?"

"What are the top 10 best-selling products?"

"Is there a difference in sales by day of week?"

The AI analyzes the data and shows results.

Step 3: Visualize with Charts

When numbers alone don't tell the story:

"Create a chart showing monthly sales"

The AI generates a chart and saves it as an image file.

Step 4: Compile Insights

Once analysis is complete, organize the results:

"Compile everything we've analyzed into an insights report"

A document with key findings and recommendations is created.

Going Deeper

After basic analysis, you can ask more in-depth questions:

Pattern Analysis

"Is there a difference in purchasing patterns between repeat and new customers?"

Correlation

"Is there a correlation between discount rate and purchase volume?"

Outlier Detection

"Let me know if there are any abnormally high transactions"

Forecasting

"What's the expected sales for next quarter at this rate?"

Analysis Tips

• Ask specifically: "Analyze monthly sales trends" is better than "analyze this"
• Work in stages: Don't ask everything at once—see results and follow up with next questions
• Use visualization: Charts reveal patterns in complex data

Supported File Formats

Excel (.xlsx, .xls), CSV, JSON