{"repo":"AmirhosseinHonardoust/Sales-Insights-SQL","free":true,"listed":false,"github":"https://github.com/AmirhosseinHonardoust/Sales-Insights-SQL","clone":"git clone https://github.com/AmirhosseinHonardoust/Sales-Insights-SQL.git","description":"Analyze retail sales data using SQL and Python. Build a SQLite database from CSV, run SQL queries for key KPIs (revenue, top products, AOV, trends), and visualize results with Matplotlib. A portfolio-ready project demonstrating SQL + data analytics + reporting automation.","language":"Python","stars":28,"topics":["analytics-projects","business-analytics","data-analysis","data-science","data-visualization","matplotlib","pandas","portfolio-project","python","retail-analytics"],"license":"MIT","category":"databases-storage","readme_excerpt":"Sales Insights with SQL and Python Analyze a retail sales dataset using SQL (SQLite) for data aggregation and Python for visualization. This project demonstrates how to move from raw transactional data → structured SQL database → actionable business insights with clear visuals. --- Project Overview This project combines data engineering , SQL analytics , and data visualization to uncover key sales insights from a retail dataset. You’ll see how SQL handles powerful data aggregation, while Python brings the results to life with visualizations. Workflow: 1. Load CSV data → SQLite database 2. Run SQL queries for KPIs 3. Export insights to CSV 4. Visualize results with charts --- Project Structure --- Dataset A synthetic dataset of 10 products sold across 4 regions (North, South, East, West) over one year. Column Description -------- -------------- order id Unique order identifier date Order date (YYYY-MM-DD) region Sales region product Product name quantity Quantity sold unit price Unit price of the product revenue Calculated as quantity × unit price Example preview: order id date region product quantity unit price revenue ----------- ------------ -------- ----------- ----------- ------------- ---------- 1001 2024-01-01 North Laptop 2 1050.00 2100.00 1001 2024-01-01 North Mouse 1 23.50 23.50 1002 2024-01-01 South Printer 1 145.00 145.00 --- Setup & Usage Create Virtual Environment Create SQLite Database Run SQL Analytics + Visualization --- SQL Queries Summary Inside src/queries.","default_branch":null,"files":null,"tree":[],"storefront":"/r/AmirhosseinHonardoust","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/AmirhosseinHonardoust/Sales-Insights-SQL/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}