Advanced SQL: MySQL Data Analysis & Business Intelligence

Udemy

Expert

Online

₹ 599 4099

particular

details

                                    Medium of instructions
                                    English

                                    Mode of learning
                                    Self study

                                    Mode of Delivery
                                    Video and Text Based

Getting Started

Course Structure & Outline
READ ME: Important Notes for New Students
DOWNLOAD: Course Resources
Introducing the Course Project - Play the Role of Business Analyst
Setting Expectations - Focus on Business Analysis, NOT MySQL Administration

Prerequisite Skills

Introduction
Prerequisite Skills - Taught in my SQL Database for Beginners course
Prerequisite Skills Quiz

MySQL Intro & Setup

Introduction
MySQL Installation Overview - MySQL Community Server & MySQL Workbench
Mac Download - MySQL Community Server
Mac Download - MySQL Workbench
PC Download - MySQL Community Server & MySQL Workbench
Connecting MySQL Workbench to the Server
MySQL Workbench Interface
Prepare to Create the Database
Creating the Maven Fuzzy Factory Database
Getting to Know the Database
USE mavenfuzzyfactory;

Analyzing Traffic Sources

Introduction
Analyzing Top Traffic Sources
ASSIGNMENT: Finding Top Traffic Sources
SOLUTION: Finding Top Traffic Sources
ASSIGNMENT: Traffic Source Conversion Rates
SOLUTION: Traffic Source Conversion Rates
Bid Optimization & Trend Analysis
ASSIGNMENT: Traffic Source Trending
SOLUTION: Traffic Source Trending
ASSIGNMENT: Bid Optimization for Paid Traffic
SOLUTION: Bid Optimization for Paid Traffic
ASSIGNMENT: Trending w/ Granular Segments
SOLUTION: Trending w/ Granular Segments

Analyzing Website Performance

Introduction
Analyzing Top Website Pages & Entry Pages
ASSIGNMENT: Finding Top Website Pages
SOLUTION: Finding Top Website Pages
ASSIGNMENT: Finding Top Entry Pages
SOLUTION: Finding Top Entry Pages
Analyzing Bounce Rates & Landing Page Tests
ASSIGNMENT: Calculating Bounce Rates
SOLUTION: Calculating Bounce Rates
ASSIGNMENT: Analyzing Landing Page Tests
SOLUTION: Analyzing Landing Page Tests
ASSIGNMENT: Landing Page Trend Analysis
SOLUTION: Landing Page Trend Analysis
Building Conversion Funnels & Testing Conversion Paths
ASSIGNMENT: Building Conversion Funnels
SOLUTION: Building Conversion Funnels
ASSIGNMENT: Analyzing Conversion Funnel Tests
SOLUTION: Analyzing Conversion Funnel Tests

Mid-Course Project

Introduction
Assignment: Mid-Course Project
Solution: Mid-Course Project

Analyzing Business Patterns And Seasonality

Analyzing Business Patterns & Seasonality
Assignment: Analyzing Seasonality
Solution: Analyzing Seasonality
Assignment: Analyzing Business Patterns
Solution: Analyzing Business Patterns

Product Analysis

Introduction
Analyzing Product Sales & Product Launches
Assignment: Product-Level Sales Analysis
Solution: Product-Level Sales Analysis
Assignment: Analyzing Product Launches
Solution: Analyzing Product Launches
Analyzing Product-Level Website Pathing
Assignment: Product-Level Website Pathing
Solution: Product-Level Website Pathing
Assignment: Building Product-Level Conversion Funnels
Solution: Building Product-Level Conversion Funnels
Cross-Selling & Product Portfolio Analysis
Assignment: Cross-Sell Analysis
Solution: Cross-Sell Analysis
Assignment: Product Portfolio Expansion
Solution: Product Portfolio Expansion
Analyzing Product Refund Rates
Assignment: Analyzing Product Refund Rates
Solution: Analyzing Product Refund Rates

User Analysis

Introduction
Analyzing Repeat Visit & Purchase Behavior
Assignment: Identifying Repeat Visitors
Solution: Identifying Repeat Visitors
Assignment: Analyzing Time To Repeat
Solution: Analyzing Time To Repeat
Assignment: Analyzing Repeat Channel Behavior
Solution: Analyzing Repeat Channel Behavior
Assignment: Analyzing New & Repeat Conversion Rates
Solution: Analyzing New & Repeat Conversion Rates

Final Project

Introduction
Assignment: Final Project
Solution: Final Project

Wrapping Up

Resources & Next Steps
Bonus Lecture: More From Maven

Popular Courses

Popular Platforms

Popular Searches

Advanced SQL: MySQL Data Analysis & Business Intelligence

Expert

Online

₹ 599 4099

Quick Facts

Course and certificate fees

Fees information

certificate availability

certificate providing authority

The syllabus

Getting Started

Prerequisite Skills

MySQL Intro & Setup

Analyzing Traffic Sources

Analyzing Website Performance

Mid-Course Project

Analysis For Channel Portfolio Management

Analyzing Business Patterns And Seasonality

Product Analysis

User Analysis

Final Project

Wrapping Up

Articles

Popular Articles

Latest Articles

Courses of your Interest

More Courses by Udemy

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Thank You!

Download the Careers360 App on your Android phone