Overview

This project is part of the Maven Analytics for Advanced SQL: MySQL Data Analysis & Business Intelligence Course.

Project Context

Maven Fuzzy Factory (MFF) is given to us as a newly launched eCommerce start-up located in the US.

The organization’s business growth strategy is based on leveraging data to discover new business opportunities and identify underlying business issues.

These are the five business concepts that were analyzed in this project:

The business concepts are arranged in the order in which they were explored.

<aside> 💡 All the queries written here are compiled on GitHub

</aside>

Groundwork

Before I started to analyze the five business concepts introduced above, I needed to have a better understanding of the database. I accomplished this by:

• Studying relevant eCommerce metrics and terminology.
• Mapping out the MFF database in detail.

Analysis

Using MySQL, the five business concepts follow a four-step process: Request, Process, Output, and Insight. Here are the highlights for each concept:

01. Traffic analysis and optimization: optimizing marketing strategies with traffic source comparison