/SQL-Data-Analysis-Internship-Project-eCommerce-Dataset

Task 4 of my Data Analyst Internship (ELEVATE LABS): A complete SQL-based data analysis project using an eCommerce dataset. Includes relational queries, JOINs, subqueries, views, indexing, and aggregate functions using SQLite.

SQL-Data-Analysis-Internship-Project-eCommerce-Dataset

Task 4 of my Data Analyst Internship (ELEVATE LABS): A complete SQL-based data analysis project using an eCommerce dataset. Includes relational queries, JOINs, subqueries, views, indexing, and aggregate functions using SQLite.

Task 4: SQL for Data Analysis – Internship Project

This project is part of a Data Analyst Internship task (Task 4), which focuses on using SQL to analyze and extract insights from a structured relational dataset.

📁 Dataset

We used a simulated eCommerce dataset with 4 relational tables:

  • customers.csv
  • orders.csv
  • products.csv
  • order_items.csv

These tables were imported into SQLite for analysis.

🛠 Tools Used

✅ Task Requirements and SQL Features Used

Step Description
a. Used SELECT, WHERE, ORDER BY, GROUP BY
Task 4 A

| b. | Implemented INNER JOIN, LEFT JOIN, and simulated RIGHT JOIN | Task 4 B Inner-Join Task 4 B Left-Join Task 4 B Right-Join

| c. | Used subqueries to filter specific results | Task 4 C

| d. | Applied aggregate functions (SUM, AVG) | Task 4 D Sum Task 4 D AVG

| e. | Created a SQL VIEW to analyze high-value orders | Task 4 E Task 4 E-1

| f. | Created an INDEX on customer_id for optimization | Task 4 F

🧾 File Descriptions

  • task4_sql_analysis.sql: Contains all SQL queries for the task
  • customers.csv, orders.csv, products.csv, order_items.csv: Dataset files used for analysis

📸 Screenshots

Screenshots of query outputs were taken from SQLite Online and added to the repository under the /screenshots/ folder. All Screenshots of queries are attached under the queries in Task Requirements and SQL Features Used section.