An interactive sales analytics dashboard built with Python, Streamlit, Plotly, Pandas, and Groq LLM.
The dashboard helps users explore sales performance through interactive visualizations while generating AI-powered business insights and recommendations based on the selected dashboard filters.
🔗 https://YOUR-STREAMLIT-URL.streamlit.app
- Interactive KPI dashboard
- Region-based filtering
- Sales trend visualization
- Product performance analysis
- Profit distribution analysis
- AI-generated executive summaries
- Natural language business Q&A
- Python
- Streamlit
- Pandas
- Plotly Express
- Groq API
- Llama 3.3 70B Versatile
Clone the repository
git clone <repository-url>Move into the project folder
cd sales-dashboard-aiInstall dependencies
pip install -r requirements.txtCreate a .streamlit/secrets.toml file and add your Groq API key:
GROQ_API_KEY = "your_api_key_here"Run the application
streamlit run app.pyGenerates a concise business report from the dashboard metrics including:
- Executive Summary
- Key Observations
- Business Recommendations
Allows users to ask business questions such as:
- How can we improve profit?
- Which category needs attention?
- Which month performed best?
- What trends stand out?
The AI answers strictly based on the dashboard data.
sales-dashboard-ai/
│
├── data/
│ └── sales.csv
│
├── .streamlit/
│ └── secrets.toml
│
├── app.py
├── requirements.txt
├── .gitignore
└── README.md
CSV Dataset │ ▼ Pandas Processing │ ▼ Dashboard KPIs │ ▼ Summary Generation │ ▼ Groq LLM │ ▼ Executive Summary / Ask AI
- Export AI report as PDF
- Additional dashboard filters
- Compare multiple regions
- Enhanced prompt engineering
Vaishnavi Goel