DEV Community

Cover image for Introducing BizAnalyst AI: Open Source Bu โ€” siness Data Analyst with AI-Powered Insights ๐Ÿ“Š
Amar
Amar

Posted on

Introducing BizAnalyst AI: Open Source Bu โ€” siness Data Analyst with AI-Powered Insights ๐Ÿ“Š

After weeks of development, I'm excited to announce BizAnalyst AI a professional-grade, open-source business data analysis tool that brings AI-powered insights to your spreadsheets.

Why I Built This

Working with business data often means juggling between Excel, Python scripts, and expensive BI tools. I wanted to create something that's:
Free and open source
Easy to use โ€” no coding required
AI-powered โ€” get instant insights by asking questions
Self-hostable โ€” run it locally or deploy anywhere

What Can BizAnalyst AI Do?

๐Ÿ“Š Interactive Visualizations

Automatically generate distributions,correlations, trends, and scatter plots from your data.

๐Ÿค– AI-Powered Insights

Connect your Google Gemini API key and ask natural language questions about your data:

"What are the top 5 products by revenue?"
"Show me sales trends for last quarter"
"Are there any anomalies in this dataset?"

๐Ÿงน Smart Data Cleaning

One-click data cleaning with:
Outlier detection
Missing value imputation
Duplicate removal
Format standardization

๐Ÿ“ Multiple File Formats

Support for CSV and Excel files (.csv, .xlsx,.xls)

๐Ÿ“ท Export & Present

Download charts as PNG
Presentation mode for meetings
Global filters across all views

Quick Start

Try Without Installation

npx bizanalyst-ai
Enter fullscreen mode Exit fullscreen mode




Or Install Globally


npm install -g bizanalyst-ai
Enter fullscreen mode Exit fullscreen mode




Or Run from Source

git clone https://github.com/anonymous243/BizAnalyst-AI
cd BizAnalyst-AI
npm install
npm run dev

Then open http://localhost:3001

Tech Stack

Frontend: React 19 + TypeScript
Build: Vite
Styling: Tailwind CSS
Charts: Recharts
AI: Google Gemini API
Data: Papa Parse (CSV), XLSX (Excel)

## Try It Now
๐Ÿ“ฆ npm: https://www.npmjs.com/package/bizanalyst-ai
๐Ÿ™ GitHub: https://github.com/anonymous243/BizAnalyst-AI

Contributing:
This is an open source project under Apache 2.0 license. Contributions are welcome!

Ways to contribute:
๐Ÿ› Report bugs
๐Ÿ’ป Submit features
๐Ÿ“ Improve docs
โญ Star on GitHub

What's Next?

Planned features:
Database connections (PostgreSQL, MySQL)
More AI providers (OpenAI, Anthropic)
Collaborative features
Advanced forecasting models

Links:
GitHub: https://github.com/anonymous243/BizAnalyst-AI
npm: https://www.npmjs.com/package/bizanalyst-ai
Let me know what you think in the comments! ๐Ÿš€

Top comments (0)