Skip to content

Pratikchetry/Sales_Intelligence_Platform

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

πŸ“Š Smart Sales Intelligence Dashboard

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.


πŸ”— Live App URL

Streamlit App: https://salesintelligenceplatform-ztvbawwvr74weynohuzuhl.streamlit.app/


πŸ’‘ Project Overview

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

οΏ½οΏ½ Features

  • πŸ” 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

🧰 Tech Stack

  • Python
  • Streamlit
  • SQLite
  • Pandas
  • Matplotlib / Seaborn
  • Faker (for synthetic data)

πŸ—‚οΈ Folder Structure

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               

βš™οΈ How to Run Locally

Step 1: Clone the repository

git clone https://github.com/Pratikchetry/Sales_Intelligence_Platform.git
cd Sales_Intelligence_Platform

Step 2: Install dependencies

pip install -r requirements.txt

Step 3: Generate dummy data and SQLite database

python3 app/etl.py

Step 4: Run the Streamlit dashboard

streamlit run app/dashboard.py

πŸ“ˆ Dashboard Snapshots

  • 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

πŸ“Œ Future Enhancements

  • Connect to real-time API or cloud database
  • Add forecast/prediction using ML
  • Add login/authentication features
  • Improve UI responsiveness for mobile

πŸ‘€ About the Author

Name: Pratik Chetry GitHub: https://github.com/Pratikchetry LinkedIn: https://www.linkedin.com/in/pratik-chetry/ Email: chetrypratik2002@gmail.com


πŸ“œ License

This project is open-source and free for personal or academic use.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors