PROJECT 01·Intermediate

E-Commerce Sales Analysis

TechCart · E-Commerce · 15 Tasks · ~90 min

You'll need a free account to save your progress.

Welcome to TechCart

You've just been hired as a Junior Data Analyst at TechCart, one of India's fastest-growing e-commerce companies. Every day, thousands of customers visit the platform, place orders, make payments, and buy products across dozens of categories.

The management team relies on the Data Analytics department to guide every major business decision — and now that includes you.

Your job is to analyze TechCart's sales data and answer real business questions using SQL. You won't be learning new concepts — you'll be applying everything you already know to solve problems that matter.

This project is your bridge from learner to practitioner.

“Good morning! We have our weekly management meeting in one hour. I need several reports about our sales, customers, products, and payments. Can you prepare them?”

It's Monday morning. Your manager needs answers — fast. This project walks you through 15 real analytical tasks, each representing a request that Data Analysts receive in their daily work. You have one hour. Let's get to it.

What You'll Do

💰
Revenue
How much has the company generated from successful payments?
🧑‍🤝‍🧑
Customers
Who are our best customers, and which ones are at risk of going inactive?
📦
Products
Which products and categories drive the most sales and revenue?
💳
Payments
What payment methods are most popular, and how many transactions failed?
📈
Trends
What daily, monthly, and behavioral patterns can we identify in our data?

SQL Skills You'll Apply

Querying & Filtering
WHEREHAVINGCASE WHEN
Aggregation & Grouping
Aggregate FunctionsGROUP BYORDER BYLIMIT
Joins & Relationships
INNER JOINMultiple JOINsPrimary KeysForeign Keys
Advanced Techniques
CTEsWindow FunctionsViewsUNIONDate FunctionsString Functions

The Database

You'll be working with TechCart's real e-commerce database (ecommerce) — the same live SQLite sandbox used throughout SQLab Hub.

users
Registered customers
id, first_name, last_name, email, city, country, created_at, status, is_premium
orders
Customer orders
id, user_id, total, discount, item_count, status, order_date, shipped_date, shipping_city, shipping_country
products
Product catalog
id, name, category, price, cost, stock, status, rating
order_items
Line items linking orders to products (bridge table)
id, order_id, product_id, quantity, unit_price, subtotal
payments
Payment transactions
id, order_id, user_id, amount, method, status, paid_at

Lessons to Review First

Each task builds on a topic from the lessons. If one feels unfamiliar, review it and come back, or warm up in the SQL Playground and the practice challenges.