This is an interactive, end-to-end Sales Intelligence Platform built using Python, Streamlit, SQLite, and Pandas. It allows users to explore synthetic sales data through a visually engaging dashboards, apply filters, search queries, and download custom reports β all in real time.
Streamlit App: https://salesintelligenceplatform-ztvbawwvr74weynohuzuhl.streamlit.app/
This platform simulates how businesses can monitor and analyze sales performance. From high-level KPIs to customer-level drill-downs, this project demonstrates key business intelligence capabilities, including:
- Revenue insights
- Product and customer analytics
- Region-wise performance
- Real-time data exploration
- Downloadable custom datasets
- π Search + Filters: Filter by customer, product, region, brand, or date range
- π Revenue Trends: Line chart of monthly revenue
- π Top Products & Customers: Bar charts of top 5 products and customers
- π Region Analysis: Revenue distribution by region
- π₯ Gender Distribution: Pie chart visualization
- π Live Data Table: Filtered data preview
- β¬οΈ Download CSV: Export filtered data in one click
- Python
- Streamlit
- SQLite
- Pandas
- Matplotlib / Seaborn
- Faker (for synthetic data)
Sales_Intelligence_Platform/
βββ app/
β βββ dashboard.py
β βββ etl.py
β
βββ data/
β βββ dim_customer.csv
β βββ dim_product.csv
β βββ fact_sales.csv
β
βββ db/
β βββ sales.db
β
βββ notebooks/
β βββ eda.ipynb
β
βββ sql/
β βββ create_tables.sql
β
βββ .streamlit/
β βββ config.toml
β
βββ requirements.txt
βββ README.md
git clone https://github.com/Pratikchetry/Sales_Intelligence_Platform.git
cd Sales_Intelligence_Platformpip install -r requirements.txtpython3 app/etl.pystreamlit run app/dashboard.py- Monthly Revenue Trend (Line chart)
- Top 5 Products & Customers (Bar charts)
- Sales by Region (Bar chart)
- Customer Gender Split (Pie chart)
- Interactive Data Table with Download Option
- Connect to real-time API or cloud database
- Add forecast/prediction using ML
- Add login/authentication features
- Improve UI responsiveness for mobile
Name: Pratik Chetry GitHub: https://github.com/Pratikchetry LinkedIn: https://www.linkedin.com/in/pratik-chetry/ Email: chetrypratik2002@gmail.com
This project is open-source and free for personal or academic use.