This project demonstrates end-to-end data analysis skills using SQL and Tableau. The goal was to analyze an e-commerce store's customer behavior, product performance, and sales trends.
- Database Management: SQLite, DB Browser for SQLite
- Data Analysis: SQL (Joins, Aggregations, CTEs)
- Data Visualization: Tableau Public
- Version Control: Git, GitHub
Files are already uploaded. These are some of the files. [Upcustomer_id,name,email,signup_date,city 1,John Smith,john@email.com,2024-01-15,New York 2,Maria Garcia,maria@email.com,2024-02-10,Los Angeles 3,David Chen,david@email.com,2024-03-05,Chicago 4,Lisa Taylor,lisa@email.com,2024-01-20,Miami 5,Robert Kim,robert@email.com,2024-02-28,Seattle 6,Sarah Wilson,sarah@email.com,2024-03-15,Boston order_items.csv orders.csv order_id,customer_id,order_date,total_amount 1,1,2024-03-01,1049.98 2,2,2024-03-02,179.98 3,3,2024-03-03,162.98 4,1,2024-03-05,59.98 5,4,2024-03-06,199.98 6,5,2024-03-07,124.97 7,2,2024-03-08,49.99 8,6,2024-03-09,999.99 products.csv product_id,product_name,category,price 1,Laptop Pro,Electronics,999.99 2,Wireless Mouse,Electronics,29.99 3,Desk Chair,Furniture,149.99 4,Notebook,Stationery,12.99 5,Coffee Mug,Home Goods,9.99 6,Desk Lamp,Home Goods,34.99 7,Backpack,Accessories,49.99 8,Water Bottle,Accessories,24.99