Back to Knowledge Hub
Use Cases

Data Analysis & Code Execution in the Chat

Upload a CSV, ask a question, get a chart. Sandboxed Python execution for data analysis without leaving the conversation.

From spreadsheet to insight in seconds

1

Upload your data

Drop a CSV, Excel, or text file into the conversation. The AI reads the structure (column names, data types, row counts) and confirms what it found.

2

Ask a question

"What were our top 10 customers by revenue last quarter?" or "Show me a trend chart of monthly churn rates." Natural language, not SQL.

3

Code runs in a sandbox

The AI writes and executes Python code (pandas, numpy, matplotlib) in a sandboxed environment. The code is visible and transparent. You can see exactly what it did.

4

Get your result

Charts, tables, and summaries appear directly in the conversation. Download the chart as an image or copy the processed data. Iterate with follow-up questions.

Capabilities

Sandboxed Python

pandas, numpy, matplotlib, and more. Code executes in an isolated sandbox. No access to the network or file system outside the conversation.

Charts & visualisations

Bar charts, line graphs, pie charts, scatter plots, and heatmaps. Generated from your data and rendered directly in the chat.

File processing

Upload CSV, Excel (.xlsx), and text files. The AI parses your data automatically and works with it in the conversation context.

Secure execution

Code execution happens in an isolated sandbox within your Azure tenant. Your data never leaves the environment. No external API calls from the sandbox.

Iterative analysis

Ask follow-up questions to refine your analysis. "Now filter for only European customers" or "Add a trendline to that chart." Build on previous results.

Example: quarterly revenue analysis

“I uploaded our Q3 revenue data. Show me revenue by region as a bar chart, then calculate the quarter-over-quarter growth rate for each region.”

The AI reads the spreadsheet, groups revenue by the “Region” column, generates a matplotlib bar chart, and calculates growth rates by comparing to Q2 data. The chart and a summary table appear directly in the chat. Your finance team gets the answer without opening a BI tool.

Ready to see it in action?

Schedule a personalised demo and see how the Plainsight AI Assistant fits your organisation.

Request a demo