Challenge

Project 1

Title: Analysis of User Database for a Customer-to-Customer E-commerce Platform

Description:

The aim of this project is to analyze the user database of a Customer-to-Customer (C2C) e-commerce platform in order to gain insights into user behavior and understand the business perspective. The platform allows customers to do business with each other, and the database contains information on user activity such as transactions, product listings, and user profiles.

The project will involve querying the database using SQL to answer key business questions, such as:

  1. What are the top selling products on the platform and which sellers are offering them?
  2. How frequently are users making purchases and what is the average transaction value?
  3. Are there any patterns in user behavior, such as peak buying times or popular product categories?

The project will include a SQL file containing the queries used to extract the necessary data, as well as a detailed report outlining the key insights and recommendations for the e-commerce platform based on the analysis.

Your portfolio, next

Ship work like this
in your own course.

Talk to a career counsellor

Free 20-minute call. We'll map the right course to where you want to work.

By submitting you agree to our Terms and Privacy Policy.