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.

Assignment: Analyzing product launches

Assignment: Analyzing product launches - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Assignment: Analyzing product launches

“

- [Instructor] Hi, everyone. We're ready for your assignment on analyzing a product launch. For this assignment, Cindy's coming to you because she launched a second product back on January 6th, and she'd like your help understanding the impact of that launch. She'd like to see monthly order volume, overall conversion rates, revenue per session, and a breakdown of sales by product, all for the time period since last year on April 1st in 2012. She's coming to you with this request on April 5th, 2013, so limit your date range accordingly based on her ask and the current time period. Your results should look like this, with year and month as your dimensions and then orders, conversion rate, revenue per session, and then a column each for product one and product two to see the order volume for those. This one should be pretty neat. I'd like you to take a look at the data and come up with your own conclusion as to whether or not adding that second product was a good thing for the business…

Contents