• 

  home page

• 

  sql file upload

• 

  question asked

• 

  creating pie graph created

Video Preview -

https://drive.google.com/file/d/1387fUrMGixgj9hkqtb1wVfVpfYS3foSI/view?usp=sharing

Smart Data Analyst

""" Sometimes, we get lost in space, feeling like we’re falling in zero gravity. Then, the stars guide us toward our destination..… and that’s where Smart Data Analyst comes in —upload your data, ask questions, and get instant answers with charts.

Sometimes, the story begins after the end of the book. """

Inspiration

We wanted to democratize data analytics. Many users struggle with SQL, Python, or Excel formulas to extract insights. Our goal was to create a tool where anyone—whether a student, analyst, or teacher—can explore data, ask questions naturally, and get instant visual answers. We were inspired by the idea of making AI-driven insights accessible directly within Salesforce, helping businesses make faster and smarter decisions.

---

Smart Data Analyst allows users to:

What it does: Smart Data Analyst is designed to make data analysis simple, intuitive, and accessible to everyone—no coding required.

✨ Key Features:

Upload datasets in multiple formats: Supports CSV, Excel, TXT, and SQL for seamless integration with existing workflows. Natural Language Queries: Just type your question in plain English, like “Show all rows where city is New York” or “Compare revenue in 2023 vs 2024.” Instant Insights: Get answers instantly with interactive visualizations—bar charts, line graphs, and more. Conversation Memory: Track your entire chat history with all questions and answers, so you never lose context. Export & Share: Turn insights into professional PDF reports for presentations or sharing with teams. Native Salesforce Integration: Run the app directly inside your Salesforce org—no switching platforms, making analytics faster and more efficient.

---

💼 Business Use Cases:

Sales Teams: Upload sales data, ask questions like “Top 10 clients by revenue this quarter” or “Monthly sales growth vs last year”, and instantly generate reports for client meetings. Marketing Teams: Analyze campaign performance by simply asking, “Which channel brought the most leads in 2024?” or “Plot conversions by region.” Finance Departments: Compare revenue trends year-over-year, identify cost patterns, or forecast expenses without needing a data scientist. Executives & Managers: Quickly access insights during meetings without waiting for analysts to prepare dashboards.

---

📊 Scenario Example: Imagine you’re a regional sales manager preparing for a monthly review. Instead of digging into spreadsheets, you simply upload your sales file into Smart Data Analyst and ask:

“Show me sales in New York vs Los Angeles for Q1 2024.” “Plot revenue growth trend for the last 12 months.” “Generate a PDF report comparing 2023 vs 2024 performance.”

Within seconds, you have charts, answers, and a ready-to-share report—all without leaving Salesforce.

---

🛠 Technologies Powering Smart Data Analyst:

Natural Language Processing (NLP): Converts plain English queries into SQL-like commands. Machine Learning Models: Understands context, synonyms, and business terms for smarter query handling. Data Visualization Libraries: Generates interactive charts and dashboards instantly. Salesforce Integration (Apex + LWC): Ensures a smooth, native experience inside Salesforce orgs. Secure Backend (Python): Handles query processing, file parsing, and report generation.

---

✨ Smart Data Analyst bridges the gap between complex datasets and easy-to-understand insights—helping businesses save time, boost efficiency, and make data-driven decisions instantly.

---

How we built it

Frontend: HTML, CSS, JavaScript, Plotly for dynamic charts. Backend: Python Flask for endpoints to handle file upload, AI query, and PDF export. Data Handling: Pandas + SQLite for in-memory dataset processing. AI Engine: PandasAI + OpenAI API for natural language interpretation of queries. Export: PDF generation for reporting.

Architecture Flow: Browser (Upload) ➜ Flask (/upload) ➜ DataFrame ➜ Browser (/ask) ➜ AI Analysis ➜ Table + Chart ➜ Browser Render

---

Challenges we ran into

Handling large datasets in memory while keeping the app responsive. Integrating AI query processing with real-time visualization. Maintaining Salesforce platform compatibility and secure session management. Managing asynchronous API calls (OpenAI) for a seamless user experience.

---

Accomplishments that we're proud of

Successfully created a no-code AI-powered analytics tool. Enabled dynamic chart generation for better insights. Fully integrated with Salesforce, meeting hackathon platform requirements. Created a user-friendly interface that non-technical users can adopt immediately.

---

What we learned

Realized the importance of user experience in AI-driven analytics. Learned to optimize backend AI processing for speed and reliability. Understood how to build Salesforce-compatible web apps that work securely and efficiently.

---

What's next for Smart Data Analyst

Add real-time dashboards for continuous monitoring of datasets. Support collaboration features: shared queries and annotations. Enable custom AI models for domain-specific insights. Integrate alerting and automated reporting for business intelligence. Expand to support more file formats and cloud storage integrations.

Built With

• html
• javascript
• openai
• pandas
• pandasai
• plotly
• python