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.
Introduction - MySQL Tutorial
From the course: Advanced MySQL Data Analysis
Introduction
- Great work helping Cindy with that board presentation. It seemed like she was really impressed and that the company is off to a great start. In this next section, we're going to take our optimization game to the next level. We'll use the database to dive deeper into our channel mix. We'll explore paid traffic and free traffic. We'll start to slice and dice our data by device type, so looking at mobile versus desktop performance. And finally, we'll use time series analysis so that we can understand trends and seasonality. We've got a lot to cover. Let's get started.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
(Locked)
Introduction32s
-
(Locked)
Analyzing channel portfolios9m 4s
-
(Locked)
Assignment: Analyzing channel portfolios1m 20s
-
(Locked)
Solution: Analyzing channel portfolios4m 44s
-
(Locked)
Assignment: Comparing channel characteristics49s
-
(Locked)
Solution: Comparing channel characteristics4m 11s
-
(Locked)
Assignment: Cross-channel bid optimization1m 11s
-
(Locked)
Solution: Cross-channel bid optimization3m 22s
-
(Locked)
Assignment: Analyzing channel portfolio trends1m 6s
-
(Locked)
Solution: Analyzing channel portfolio trends7m 23s
-
(Locked)
Analyzing direct, brand-driven traffic7m 21s
-
(Locked)
Assignment: Analyzing direct traffic1m 50s
-
(Locked)
Solution: Analyzing direct traffic8m 22s
-
(Locked)
-
-
-
-