E-commerce Data Analysis with SQL

This project uses SQLite to analyze transactional data from an e-commerce dataset.

Download Dataset

link= "https://www.kaggle.com/datasets/carrie1/ecommerce-data"

Dataset Schema

Table Name: transactions

Column	Type
InvoiceNo	TEXT
StockCode	TEXT
Description	TEXT
Quantity	INTEGER
InvoiceDate	TEXT
UnitPrice	REAL
CustomerID	INTEGER
Country	TEXT

SQL Queries Included

1. View First 10 Records

Displays a sample of the data for validation.

2. Total Revenue Per Invoice

Calculates the total revenue generated by each invoice.

3. Top Products Sold

Lists the top 10 products based on quantity sold.

4. Average Order Value Per Customer

Calculates average revenue per order for each customer.

How to Use

1. Open the database in DB Browser for SQLite.
2. Go to the "Execute SQL" tab.
3. Paste the queries from the .sql file and run them.
4. Use the "Browse Data" tab to view results or use SQL queries for analysis.