An AI Agent built for business analysis scenarios. After connecting a data source, users simply ask questions in natural language — the system automatically handles:
- Data schema discovery
- SQL generation & execution
- Chart generation
- Business insight analysis
© 2026 Zafer-Liu · Chinese software copyright registration applied (Acceptance No. 2026R11S0817877, Software: Natural-Language Interactive Business Data Analysis Software V1.0) · Licensed under CC BY-NC 4.0. Unauthorized commercial use is prohibited; contact the author for commercial licensing.
💬 Official Community: QQ Group
991636855· Telegram Group · Discord
📝 Changelog · ✨ Highlights · 🧩 Agent Manager · ⚙️ Installation · 📈 Examples · 🤖 LLM Setup · ❓ FAQ
📚 Full Table of Contents
Current version
v1.2.0 LTS· July 17, 2026 · 📦 Download Installer
v1.2.0 LTS focuses on a smoother, more reliable data-analysis experience:
- AI Team Collaboration: Break complex work into tasks for specialist Agents, with progress and results clearly visible.
- Business Canvas and Skills: Map business relationships, reuse proven analysis methods, and create dashboards and visual results faster.
- More Reliable Data Processing: Long-running tasks and local-data workflows are more dependable and reassuring.
- Local Data Cleanup: Review storage and cleanup candidates in Settings → Storage; files go to the Recycle Bin first and important data remains protected.
- Refined Everyday Experience: Chat, workspace, and frequent actions are clearer and easier to use.
Thank you to the following sponsors for supporting this project!
Thank you to Bloome for sponsoring this project! Bloome lets multiple AI agents (Claude, ChatGPT, DeepSeek, etc.) collaborate in a single conversation — zero setup, cloud-based, works on web and mobile, and you can share your configured agents with your team.
Thank you to DolOffer for supporting this project! DolOffer is a platform focused on digital product recommendations and deal sharing, helping users quickly discover useful tools, services, and limited-time offers. The platform provides popular subscription services such as YouTube Premium, Claude, ChatGPT Plus, Spotify, Apple Music, and more, with prices as low as 30% of the official price or even lower. All services are genuine, stable, and backed by reliable after-sales support. Register through our exclusive link and use the coupon code AI8888 when topping up to enjoy an additional 10% discount.
Thank you to Atlas Cloud for supporting this project! Atlas Cloud is an all-modal AI inference platform that provides developers with a unified AI API interface, covering video generation, image generation, and large language model APIs. Instead of integrating multiple providers separately, you can connect once and access more than 300 carefully selected all-modal models through a single interface. Check out Atlas Cloud’s newly launched coding plan promotion to get more cost-effective API access.
Business Analyst Agent is a conversational business data analysis system, designed to let non-technical users perform data analysis just by chatting.
After uploading an Excel/CSV file or connecting a database, users can ask questions directly:
What is the sales trend for the last three months?
Which region has the highest profit?
Generate a user growth chart for me
The system will automatically:
- Understand the intent of the question
- Analyze the data structure (Schema)
- Auto-generate SQL
- Execute the query
- Recommend a chart type
- Output business insights
All delivered via SSE (Server-Sent Events) streaming, showing the analysis process in real time.
One demonstration is worth a thousand screenshots.
demo.mp4
Product demo — Chinese
Business Analytics Agent can run independently or with Agent Manager for a more convenient desktop management experience.
Learn how Agent Manager manages this project
Agent Manager is a unified control center for local AI Agent projects. After adding Business Analytics Agent, you can:
- Start or stop the Agent with one click
- View logs and port status in real time
- Open the web analysis interface inside the desktop app
- Ask the Manager Agent to start or open this project in natural language
- Create a temporary public sharing link for demos
Example:
Start Business Analytics Agent and open its interface.
This is especially useful when you frequently demonstrate, debug, or run multiple Agent projects.
👉 Project: Agent Manager
No SQL required — just type in plain language:
Monthly order volume trend for this year
The system will automatically:
- Generate SQL
- Query the data
- Recommend a chart
- Summarize the analysis
Supports uploading and connecting to multiple data sources:
- Files: Excel / CSV
- Databases: SQLite, MySQL, PostgreSQL, SQL Server
- Planned: DuckDB, Spark
Based on your query results, the system automatically recommends the most appropriate chart from 6 major categories:
| Category | Chart Types |
|---|---|
| COMPARING | Marimekko_ABS, Marimekko_PCT, Bar_Chart, Grouped_Bar_Chart, Stacked_Bar_Chart, Diverging_Bar_Chart, Dot_Plot, Waffle, Bullet_Chart, Sankey_Chart, Heatmap, Waterfall |
| TIME | Line_Chart, Circular_Line_Chart, Slope_Chart, Sparkline, Bump_Chart, Cycle_Chart, Area_Chart, Stacked_Area_Chart, Horizon_Chart, Connected_Scatter |
| DISTRIBUTION | Histogram_Pareto_chart, Pyramid_Chart, Error_Bar_Chart, Box-and-Whisker_Plot, Violin_Chart, Ridgeline_Plot, Beeswarm_Plot, stem_leaf |
| GEOSPATIAL | Flow_Map, Dot_Density_Map, Choropleth_Map |
| RELATIONSHIP | Scatter_Plot, Bubble_Plot, Radar_Charts, Chord_Diagram, Arc_Chart, Network_Diagram, Parallel_Coordinates_Plot |
| PART-TO-WHOLE | Treemap, Sunburst_Diagram, Nightingale_Chart, Pie_Chart |
The analysis process is visible in real time:
[1/4] Reading data structure...
[2/4] Generating SQL...
[3/4] Executing query...
[4/4] Generating chart and insights...
More transparent and interactive than traditional BI tools.
Supports the following model providers:
- DeepSeek
- OpenAI
- AtlasCloud
- Any OpenAI SDK-compatible API
Supports custom base_url, model, and api_key. Default configurations:
| Provider | Default Model |
|---|---|
| DeepSeek | deepseek-v4-flash |
| OpenAI | gpt-4o-mini |
| AtlasCloud | deepseek-v4-pro |
Currently supported analysis features:
- Outlier handling (trimming and winsorizing)
- Decile grouping analysis
- K-Means clustering
- Decision tree modeling
- And more...
Supports exporting:
- Formatted Excel spreadsheets
- Reports in
.docxformat - Built-in styled PowerPoint presentations
Supports connecting to local or remote MCP servers to expand the Agent's capabilities.
- Tutorial: MCP_tutorial
Supports uploading business knowledge to help the Agent better understand your data.
- Tutorial: repository_tutorial
Download the latest version from GitHub Releases:
| Platform | File |
|---|---|
| Windows | BusinessAnalyticsAgent_v1.0.0_LTS.exe |
Prerequisites: Python 3.10+ and 64-bit Windows 10 / 11.
Run the installer and follow the setup wizard. After installation, launch Business Analytics Agent from the desktop or Start Menu.
Prerequisite: Python 3.10+ Don't have it? Download here (Windows: check "Add Python to PATH" during install)
Step 1: Download and extract
Step 2: Double-click to launch
| OS | Action |
|---|---|
| Windows | Double-click start.bat |
| macOS | ① Open Terminal (Command + Space → type Terminal → Enter) ② Run the following (replace the path with your actual extraction location): chmod +x ~/Downloads/Data-Analysis-Agent/start.command then xattr -d com.apple.quarantine ~/Downloads/Data-Analysis-Agent/start.command ③ Double-click start.command |
First launch will automatically create a virtual environment and install dependencies — this takes about 3–5 minutes. Subsequent launches are instant.
Step 3: Browser auto-opens at http://localhost:5001
Step 4: Configure your API Key
Step 5: Future updates
Windows (run in PowerShell):
iwr -useb https://raw.githubusercontent.com/Zafer-Liu/Data-Analysis-Agent/main/install.ps1 | iexAfter installation, double-click data-analysis-agent.bat on your desktop, or run:
cd $env:USERPROFILE\.data-analysis-agent\Data-Analysis-Agent
.\.venv\Scripts\activate
python app.pymacOS / Linux (run in Terminal):
curl -fsSL https://raw.githubusercontent.com/Zafer-Liu/Data-Analysis-Agent/main/install.sh | shAfter installation, run:
data-analysis-agentIf you see command not found, add the following to ~/.zshrc or ~/.bashrc, then restart Terminal:
export PATH="$HOME/.local/bin:$PATH"git clone https://github.com/Zafer-Liu/Data-Analysis-Agent.git
cd Data-Analysis-Agent
pip install -r requirements.txt
python app.pyOpen http://localhost:5001 in your browser and configure your API Key.
| Command | Status | Description |
|---|---|---|
/chart |
✅ | Force chart generation as the priority output |
/sql |
✅ | Execute SQL directly |
/analyze |
✅ | Deep statistical analysis |
/tree |
✅ | Decision tree analysis |
/kmeans |
✅ | K-Means clustering analysis |
/data |
✅ | Data exploration and preview |
/inset |
✅ | Missing value imputation |
/winsorize |
✅ | Winsorizing (replace extreme values) |
/trimming |
✅ | Trimming (remove extreme values) |
/export |
✅ | Export data file |
/report |
✅ | Export Word/PDF report |
/ppt |
✅ | Export PowerPoint presentation |
/status |
✅ | View task status |
User input:
Sales trend for the last 12 months
System output:
- SQL query
- Trend line chart
- Sales growth analysis
User input:
Which region has the highest profit?
System output:
- Regional profit rankings
- Bar chart
- Regional business insights
User input:
/chart User growth overview
The system will prioritize generating a visualization.
In the sidebar ⚙, fill in:
API Key
Base URL
Model
to switch between models.
📦 Installation & Startup
Network timeout while installing dependencies?
The script will automatically switch to the Tsinghua mirror and retry.
If it still fails, run manually:
pip install -r requirements.txt -i https://pypi.tuna.tsinghua.edu.cn/simplepip install error / dependency installation failed?
The script automatically retries using a domestic mirror (Tsinghua).
If it still fails, specify the mirror manually:
pip install -r requirements.txt -i https://pypi.tuna.tsinghua.edu.cn/simpleAlso ensure at least 2 GB of free disk space is available.
Wrong Python version (requires 3.10+)?
Check your current version:
python --versionIf below 3.10, download the latest version at:
Double-clicking start.bat does nothing or flashes briefly?
Python is not correctly added to the system PATH.
Reinstall Python and check "Add Python to PATH", then restart your computer and try again.
macOS blocks start.command from running?
Run this in Terminal to remove the restriction:
xattr -d com.apple.quarantine /your/path/to/start.commandIf you see:
"Cannot be opened because the developer cannot be verified"
You can:
- Right-click
start.command - Select "Open"
- Click "Open" again
🔑 API Configuration
Prompted that LLM is not configured?
Enter your API Key in the sidebar ⚙ and save.
How do I get an API Key?
Using DeepSeek as an example:
🗄️ Database Connection
How do I connect to a SQL database?
Use the following connection format:
mysql+pymysql://username:password@host:port/database_name
Example:
❌ Wrong:
mysql://user:pass@host:3306/dbname
✅ Correct:
mysql+pymysql://user:pass@host:3306/dbname
📊 Charts & Files
Chart links broken after restart?
Generated charts are saved locally at:
outputs/charts
You can open the corresponding HTML files directly in your browser.
We welcome every kind of contribution, whether you are fixing a bug, improving documentation, or adding a feature.
- Fork this repository
- Create a feature branch
git checkout -b feature/your-feature-name
- Commit your changes
We recommend following the Conventional Commits specification.
git add . git commit -m "feat: add your feature"
- Push your branch
git push origin feature/your-feature-name
- Open a Pull Request
- Describe your changes
- Include screenshots or a recording for new UI features
- Link related issues, if any
- Follow PEP 8 for Python code
- Run
flake8before submitting changes - Add relevant tests for new features
- Keep commit messages clear and concise
Report bugs through GitHub Issues and include:
- 📋 Steps to reproduce
- 🎯 Expected behavior
⚠️ Actual behavior- 📸 Screenshots, when applicable
- 💻 Environment details, including OS and Python version
A great open-source project is never a solo act. We're building a data tool that can genuinely handle complex business scenarios — one that races through massive datasets, navigates multi-table logic with ease, and surfaces insights on visual dashboards. We've hit a few deeply challenging, high-value problems. If you love solving hard technical problems, we need you:
- Multi-sheet inter-table logic optimization — How do you intelligently map dependencies and calculations across dozens of sheets?
- Visualization dashboard interactivity & performance — Making data stories flow more smoothly, intuitively, and powerfully.
- Model capability enhancement for specialized business scenarios — The edge cases that general-purpose tools can't handle.
- Remote server invocation — Building a framework for remote GPU calls.
- You'll tackle real, deep, non-toy technical challenges
- Your code will directly impact the productivity of front-line business users
- Contribute freely, collaborate flexibly — submit a PR or reach out directly, entirely up to you
- Outstanding contributors may be invited to become project Committers
- Open a Pull Request directly — we review within 24 hours
- Or contact us at:
rusboldtshanti34@gmail.com(please note "Contributor + area of expertise") - Join the official community: QQ Group
991636855or Telegram Group or Discord
This software is licensed under CC BY-NC 4.0 and a Chinese software copyright registration has been applied for (Acceptance No. 2026R11S0817877, Software: Natural-Language Interactive Business Data Analysis Software V1.0).
See the LICENSE file for the full terms.
Unauthorized commercial use is prohibited; contact the author for a separate commercial license.
Leave the process to Business Analytics Agent, and save your time for thinking.
⭐️ If this project helps you, please give it a star!
Made with ❤️ by Zafer-Liu