From the course: Advanced MySQL Data Analysis

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Solution: Analyzing product launches

Solution: Analyzing product launches - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Solution: Analyzing product launches

“

- [Instructor] Hi, everyone. Here's the solution video for your assignment on product launch sales analysis. As a reminder, Cindy's coming to you on April 5th, 2013, and she's asking you for help analyzing the impact of the new product launch back on January 6th. She'd like to see monthly order volume, overall conversion rates, revenue per session, and then a breakdown of sales by product. And she'd like to look at data since April 1st. Your results should look like this with year and month as your breakdown, and then orders, conversion rate, revenue per session, product one orders and product two orders as your metrics. Let's jump into workbench and walk through the solution. All right, so here we have our website sessions table, and we're left joining to orders. At this point, this should be totally nothing new to you guys where we're going to need to count sessions and orders in order to get conversion rate, and we're limiting to the dates that are part of the assignment. This is…

Contents