AI Data Analysis Tutorial: From Excel to Visualization

Data analysis sounds intimidating, but most everyday analysis tasks can be handled by AI. Whether you work in sales, operations, or administration, as long as you have a spreadsheet, AI can dig out valuable insights from rows of numbers.

This tutorial skips complex statistical formulas and teaches you how to use AI tools for the most practical data analysis tasks.

Why Use AI for Data Analysis

Traditional data analysis requires mastering Excel functions, pivot tables, or even Python. AI changes all that:

• No formulas needed — Tell AI what you want to see in plain language
• Auto-detect patterns — AI identifies trends and anomalies in your data
• One-click charts — AI picks the best chart type for your data
• Export reports — Analysis results can be exported as PDF or images

Getting Started

Before you begin, you'll need:

• A data file in Excel or CSV format
• An AI chat tool (ChatGPT, DeepSeek, Claude, etc.)
• An idea of what you want to analyze (e.g., monthly sales trends, department expense comparison)

If you use ChatGPT Plus or DeepSeek, you can upload files directly for analysis. With free versions, simply copy and paste your data into the chat.

Hands-on 1: Upload Data and Generate Analysis Reports

This is the most common use case. Let's say you have a monthly sales data spreadsheet.

Steps:

1. Open your AI tool (ChatGPT or DeepSeek recommended)
2. Click the attachment button or drag your file into the chat
3. Upload your Excel file
4. Enter this prompt: "Analyze this sales data and tell me: 1) Overall sales trend; 2) Best and worst months; 3) Year-over-year growth"
5. Wait for the analysis (usually 10-30 seconds)

AI automatically recognizes column names and data types, then provides a structured analysis. You can follow up with: "Can you show this as a chart?" or "Which month had the highest growth rate?"

Hands-on 2: Natural Language Data Filtering

In Excel, complex filtering requires multiple conditions. With AI, one sentence is enough.

Common filtering scenarios and prompts:

• "Find all orders with sales over 50,000"
• "List all products where inventory is below safety stock"
• "Filter new customers this month who are from Beijing"
• "Group all customers' phone numbers by region"

You don't need to remember any functions or filter syntax — just describe what you need in plain words.

Hands-on 3: Generate Visual Charts

Numbers alone aren't intuitive. Charts are the most compelling way to present data.

Steps:

1. Upload your data file
2. Enter: "Create a bar chart showing monthly sales trends and a pie chart showing product category distribution"
3. AI generates and displays charts in the chat
4. To adjust, say: "Change the bar chart to a line chart" or "Add percentage labels to the pie chart"
5. Right-click to save the image or ask AI to export as PDF

AI automatically selects appropriate chart types based on your data, but you can also specify which type you prefer.

Hands-on 4: Comparative and Growth Analysis

What managers care about most: "How does this compare to last year?" and "How does this month compare to last month?"

Example prompts:

• "Compare this year's and last year's monthly sales data and calculate year-over-year growth rates"
• "Calculate month-over-month changes for each product category"
• "Find the top three categories with the highest year-over-year growth"

AI automatically calculates growth rates, creates comparison tables, and highlights growing or declining metrics.

Hands-on 5: Generate Data Reports

After analyzing data, you need to organize results into a report. AI helps with this too.

Steps:

1. First, have AI complete the data analysis (using the steps above)
2. Enter: "Organize the analysis results into a complete report, including summary, data overview, trend analysis, recommendations, and conclusions"
3. AI generates a well-formatted report
4. If needed, say "Add charts" or "Translate the report into English"

The generated report can be copied directly into Word or PowerPoint, saving hours of formatting time.

Useful Prompt Templates

Here are some ready-to-use data analysis prompts:

Basic analysis:

• "Analyze this data and provide 5 key insights"
• "Are there any anomalies in this dataset?"
• "Help me identify patterns and trends in this data"

Advanced analysis:

• "Calculate mean, median, and standard deviation for each metric"
• "Group and summarize by region/time/category"
• "Create a funnel analysis showing user conversion flow"

Report generation:

• "Write the analysis report in professional business language"
• "Generate a one-page executive summary"
• "Write in Chinese first, then translate to English"

Important Notes

AI data analysis is powerful, but keep these points in mind:

• Data security — For sensitive data, prefer locally deployed AI tools (like DeepSeek local version)
• Verify results — AI analysis isn't always 100% accurate; cross-check key numbers with Excel
• File size limits — Uploads have size restrictions; sample large datasets first
• Chart precision — AI-generated charts are great for trends, but use tables for exact values

Summary

The core idea of AI data analysis is simple: hand your data to AI, describe what you want to know in natural language, and let AI find the answers. No formulas, no coding — just knowing how to ask the right questions.

Next time you're staring at a spreadsheet feeling overwhelmed, try handing that data to AI. You might find that data analysis is much simpler than you thought.