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: Product-level sales analysis

Assignment: Product-level sales analysis - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Assignment: Product-level sales analysis

“

- [Instructor] Hi, everyone. We're ready for your assignment on product-level sales analysis. For this assignment, Cindy is about to launch a new product and wants to do a deep dive on monthly sales performance for your current product. She'd like you to pull number of sales, total revenue, and the total margin generated for the business. She's coming to you on January 4th, 2013, so approach this as if you were an analyst receiving this email at that moment and limit your date range accordingly. Your data should look like this with year and month as your dimensions; that's how you'll create your trend. Then you'll want to pull the number of sales, the total revenue, and the total margin. And just a reminder, total margin is total revenue minus total cost of goods sold. This one should be fairly straightforward for you. It's a good way to get some initial exposure to order and revenue data, and then some of the assignments will get more complicated as the business adds additional…

Contents