How is Maven Fuzzy Factory Doing?

This project is based on the eCommerce firm that manufactures and sells teddy bears, Maven Fuzzy Factory. The database includes data from March 2013 to March 2015. I aimed to use SQL to perform exploratory analysis on the Maven Fuzzy Factory database and visualize my findings. I focused on website session trends, order totals, and business refunds.

My dashboard flows in an up-and-down pattern to simulate the funnel of the business, from website sessions at the top down to refunds at the bottom of the funnel.

I also created an EER diagram of the Maven Fuzzy Factory database that can be found in my additional images, along with screenshots of the SQL code I wrote.

I used MySQL and Excel to complete this project. Here are a couple of the SQL techniques I used:

• Aggregate functions such as MAX and COUNT
• CASE statements
• YEAR and MONTH to group data
• LEFT JOIN
• DISTINCT