Home/ Part XII — Building Real Products (End-to-End Projects)/36. Project 5: Data-to-Insights Analyst Tool

36. Project 5: Data-to-Insights Analyst Tool

Overview and links for this section of the guide.

On this page

The Vision
How It Works
Where to go next

The Vision

Business users have data (Excel/CSV) but don't know Python. They want to ask: "Show me sales by region for Q3."

We will build a tool where:

1. User uploads a CSV. 2. User asks a question in plain English. 3. AI writes a Python script (using Pandas/Matplotlib) to answer it. 4. System executes the script in a sandbox. 5. User sees the chart and the answer.

How It Works

This is the most dangerous project because the AI writes code that we execute. Security is the main challenge. We will use a "Code Interpreter" pattern with strict sandboxing (e.g., Docker or WebAssembly).