E-commerce Data Analysis

Project Objectives/Deliverables

The goals of this project are as follows:

    A. Data cleaning and summary statistics

Create a tableau dashboard to monitor the following metrices:
       1. Revenue by month, region and product category.
       2. Converstion rates for the whole store and by each product category.
       3. Identify the trend of purchases by time and day of week.
       4. Average checkout duration. see the dashboard here

    B. Customer Progress in in the Sales Funnel

Conduct a funnel analysis to identify bottleneck in the sales journey.

    C. Classify Zipcodes in terms of economic status

Using US Census ZCTAs data apply K-means classification to group the zipcodes.

    D. Customer Segmentation

Methods Used	Techologies
Data Visualization Machine Learning-Kmeans Classification	pandas Python Tableau

Project Description

Data Source: Kaggle or find raw data stored here in this repository.