This project contains all my practice files that i had completed for the course Advanced SQL - MySQL for Analytics Business Intelligence
- Link course: https://www.udemy.com/course/advanced-sql-mysql-for-analytics-business-intelligence/
- Course overview:
- Write advanced SQL queries to explore and analyze databases with MySQL Workbench
- Learn how to use subqueries and temporary tables to handle complex multi-step data problems
- Solve practical hands-on assignments and real-world eCommerce use cases
- Analyze data across multiple tables with powerful MySQL JOIN statements
- MySQL Workbench download: https://dev.mysql.com/downloads/workbench/
- Traffic Analysis & Optimization: calculate session volumne, conversion rate, optimize budgets
- Website Measurement & Testing: comparing traffic and conversion rate,...
- Channel Analysis & Optimization: time-series analysis, case-when expression, breakdown performance by device type,...
- Product-Level Analysis: calculate sales and conversion rates, analyze cross-selling patterns, and use refund rates to keep a pulse on quality.
- Advancing my SQL skill