Real-Time Analytics Streamlit App with AI-Insights
تفاصيل العمل
Interactive Sales Analytics App with AI-Powered Insights¶
Overview
This project is an advanced analytics dashboard built with Streamlit that provides comprehensive insights into Superstore sales data. The dashboard features AI-powered analysis using Google's Gemini model, interactive visualizations with Plotly, and a sophisticated dark theme UI design.
Key Features
Custom dark theme design with elegant color schemes
AI-powered analysis using Google Gemini
Interactive data visualizations using Plotly
Multi-level geographical analysis
Time-series trend analysis
Shipping analytics with 3D visualization
Category and product performance tracking
Dynamic filtering capabilities
Tech Stack
Frontend Framework: Streamlit
Database: PostgreSQL
Data Processing: Pandas, NumPy
Visualization: Plotly Express, Plotly Graph Objects
AI Integration: Google Generative AI (Gemini 1.5)
Additional Libraries:
streamlit_option_menu
psycopg2
PIL (Python Imaging Library)
Business Value Proposition
Instant Insights: Real-time analysis of sales performance across multiple dimensions
AI-Driven Analysis: Automated pattern recognition and trend analysis using Google's Gemini AI
Decision Support: Clear, actionable recommendations based on data patterns
Resource Optimization: Identify best-performing products, regions, and shipping methods
Performance Tracking: Monitor KPIs and track progress toward business goals
Features Breakdown
1. Navigation System
Custom sidebar with intuitive icons
Seven main sections: Home, Sales, Trends, Category, Product, Location, and Shipping
2. Filtering Capabilities
Region selection
State filtering
City-level filtering
Date range selection
3. Key Performance Indicators (KPIs)
Total Sales
Quantity Sold
Total Profit
Top Category
Top City
4. Visualization Sections
Sales Analysis
Category-wise sales distribution
Regional sales breakdown with percentage contributions
AI-powered insights for each visualization
Trends Analysis
Time-series analysis by category
Interactive line charts with markers
Trend identification and pattern analysis
Category Analysis
Quantity sold by category and sub-category
Segment analysis with stacked visualizations
Percentage contribution calculations
Product Analysis
Sub-category performance metrics
Sales and quantity distribution
Trend line overlays for pattern identification
Location Analysis
Top 10 cities by sales
Top 10 states by sales
Combined bar and line visualizations
Shipping Analysis
Sales by shipping mode using bubble charts
3D visualization of shipping mode, product category, and sales
Detailed shipping performance metrics
User Experience
The App features an intuitive dark theme design that reduces eye strain and highlights important data points. Key features include:
Intuitive Navigation: Easy-to-use menu system
Interactive Filters: Dynamic data exploration
Responsive Design: Adapts to different screen sizes
Custom Views: Personalized data visualization
AI-Powered Insights
Our integration with Google's Gemini AI provides:
Automated Analysis
Pattern recognition
Trend identification
Anomaly detection
Business Recommendations
Action items
Growth opportunities
Risk mitigation strategies
Natural Language Insights
Clear explanations
Context-aware analysis
Business-focused interpretation