niladri-dey / ecommerce-data-analysis Goto Github PK

e Commerce Database Analysis for Maven Fuzzy Factory, an online retailer which has just launched their first product.

STEP 1: In MySQL Workbench, click File from the top menu, then select Run SQL Script

STEP 2: Navigate to the create_mavenfuzzyfactory.sql,This code will automatically generate the entire database that we’ll be exploring throughout the course, modeling a real-world eCommerce product company

We will be working with six related tables, which contain eCommerce data about:

• Website Activity

• Products

• Orders and Refunds

TASK1:TRAFFIC SOURCE ANALYSIS

1.Finding top traffic sources
2.Traffic sources conversion rates
3.Bid optimization and trend analysis
4.Monitor searching activiy on device level

TASK2:ANALYZING WEBSITE PERFORMANCE

1.Analyzing top website pages and entry pages
2.Analyzing bounce rates and landing page test
3.Landing page trends analysis
4.Building conversion funnel 
5.Testing conversion paths

TASK3:ANALYSIS FOR CHENNEL PORTFOLIO MANAGEMENT

1.Analyzing channel portfolios
2.Comparing channel characteristics
3.Cross-Channel bid Optimization
4.Analyzing channel portfolio trends
5.Analyzing direct and brand driven traffic