This repository contains the code I used to solve the assigments of the course SQL - Advanced MySQL for Analytics & Business Intelligence by Maven Analytics at Udemy. All code is my own, and, sometimes, my solution is different than the one from the course. In some instances, I present my and the course’s solution to a specific problem and comment on the differences. I also tried to use different approaches to solve similar problems (i.e. subqueries, temporary tables and common table expressions).
The code for each section of the course is located in a separate file.
Section 4: Analyzing Traffic Sources
- Traffic source analysis
- Conversion rates
- Trend analysis and Bid optimization
Section 5: Analyzing Website Performance
- Analyzing top website pages and entry pages
- Analyzing bounce rates and lading page tests
- Building conversion funnels and testing conversion paths
Section 7: Analysis for Channel Portfolio Management
- Analyzing channel portfolios
- Comparing channel characteristics
- Cross-channel bid optimization
- Analyzing direct, brand-driven traffic
Section 8: Analyzing Business Patterns and Seasonality
- Analyzing seasonality
- Analyzing business patterns
- Analyzing product sales and product launches
- Analyzing product-level website pathing
- Building product-level conversion funnels
- Cross-sell analysis
- Analyzing product refund rates
- Analyzing repeat visit and purchase behavior