From the course: Advanced MySQL Data Analysis

Unlock this course with a free trial

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

Assignment: Analyzing channel portfolio trends

Assignment: Analyzing channel portfolio trends - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Assignment: Analyzing channel portfolio trends

“

- [Instructor] Hi, everybody. We're ready for your assignment on channel portfolio trends. So based on your last analysis, Tom bid down bsearch nonbrand on December 2nd because it was underperforming against gsearch nonbrand. He'd like you to pull weekly session volume for gsearch and bsearch nonbrand, and he wants you to break that down by device since November 4th. He'd like you to include a comparison metric showing bsearch as a percent of gsearch so that it's really easy for him to see the relative volume. Per usual, you're approaching this as an analyst receiving this email on December 22nd, so limit your date range accordingly. Your results should look like this, with week start date on the left column, and then your various session volumes and comparison metrics on the right. This may feel similar, but a little more complicated than some other assignments where you've used the count and case pivot method. Give this one a try. I think if you can figure this one out, you'll be…

Contents