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 seasonality

Assignment: Analyzing seasonality - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Assignment: Analyzing seasonality

“

- [Narrator] All right, you're ready for your assignment on analyzing business seasonality. For this assignment, Cindy is coming to you trying to understand monthly and weekly volume patterns in website sessions and order volume. This is a fairly common request so that a business can think about how they should plan for any seasonality that may exist in their marketplace. Cindy's coming to you on January 2nd, 2013 so treat this like an analyst receiving the email in that present moment and limit your date range accordingly. Your results should look like this, and you're going to do two separate queries. For your first query, you'll want to have year and month as your dimensions, and then you'll want the volume of sessions and orders for the second query. It'll be a very similar exercise. The only thing that's different is you'll be grouping by week and you'll want to put a nice Week Start label on there. The two queries should feel very similar. If you can get one, you'll certainly be…

Contents