Data analysis & Business Intelligence | Advanced MySQL

Data analysis & Business Intelligence | Advanced MySQL

Data analysis & Business Intelligence | Advanced MySQL

Learn Advanced MySQL skills in real-world project as a Senior data analyst

Language: english

Note: 4.5/5 (8 notes) 3,497 students

Instructor(s): Mohannad Alhariri

Last update: 2022-04-11

What you’ll learn

  • Write Advanced SQL queries and analyze database
  • Learn TEMPORARY TABLES and SUBQUERIES to handle complex multistep data problem
  • Analyze data for eCommerce real-world case where you can solve tasks
  • Mastering JOIN statements across multiple tables
  • Get life time access to resources and videos

 

Requirements

  • Students are expected to have prior knowledge in SQL and solid grasp of SELECT statements, aggregate functions and join tables
  • If you do not have any experience or knowledge in SQL, I highly recommend to have the Data Analysis for Beginners with SQL or gain some knowledge in MySQL before participating in this course

 

Description

NOTE: This is an ADVANCED SQL course, built on topics and skills covered in the previous course or on prior knowledge in SQL queries….Please have the minimum prerequisite skills or complete the Beginner SQL course to be able to complete the course


In this course you will develop real-world analytics and Business Intelligence skills using Advanced SQL by Analyzing an ecommerce store to get insight for the performance of the website, products and user experience


GUARANTEED, instead of learning some advanced codes, in this course you will learn how to apply the advanced skills, analyzing the data and doing Business analysis too

We will walk through real project database of eCommerce store for toys  from scratch


You will be playing a role as Data Analyst working directly with executives CEO and Directors to help grow the business, analyzing performance and optimize the store, website, products, and user experience


You will use advanced skills such TEMPORARY TABLE, Subqueries to solve multistep data problem which make you THINK like an ANALYST


COURSE OUTLINES :

  • Introduction from downloading SQL server to connect the database

    In this section we will take about how to install MySQL workbench and connect the database to the server plus creating  a connection, after watching this part make sure you have the relevant skills including SELECT statements, Aggregate Functions and tables joins.


  • Analyzing Traffic source

    In this section we will warm up and do some review for some queries, then we will analyze where our traffic source coming from, how different sources perform in terms of traffic volume, calculate conversion rates, analyzing bids and optimize it, trend analysis


  • Analyzing website performance

    In this section we will analyze website pageviews and use TEMPORAY TABLE, calculate bounce rate, analyzing landing page, and use SUBQUERIES


  • Analyzing Channel portfolio management

    In this section we will compare channels and do multi channel bidding , also analyzing bid changes impact, traffic breakdown.


  • Analyzing Business Patterns and Seasonality

    In this section we will dig deeper into traffic analysis and explore more about organic and paid campaign, also seasonality and business patterns analysis


  • Product Analysis

    In this section we will break down sales on product level, conversion rates and cross-selling patterns and refund rates analysis to keep quality


  • User Analysis

    In this section we deep analyze user behavior and analyze the repeated sessions to identify most valuable customers and explore which channels they are coming from

 

Who this course is for

  • SQL users looking to develop advanced skills and master data analysis with Advanced SQL queries
  • Anyone looking to pursue a career in data analysis or business intelligence
  • Data analysts excel users looking to shift into business intelligence and optimize data analysis skills
  • Data Analyst or Business Analyst with SQL, BI professionals looking to analyze data in a real-world case database

 

Course content

  • Introduction
    • Introduction
    • 1.2 Connecting database to the server
    • 1.3 Creating the Database and intro to MySQL workbench
    • 1.4 Course Outlines and intro to database
  • Analyzing Traffic Source
    • Warming Up
    • 2.2 Analyzing Traffic Source
    • 2.3 Finding Top Traffic
    • 2.4 Traffic Source Breakdown
    • 2.5 Bid Analysis and Optimization- Part 1
    • 2.6 Bid Analysis and Optimization- Part 2
    • 2.7 Trend Analysis
  • Analyzing Website Performance
    • 3.1 Introduction and outlines
    • 3.2 Analyzing website pageviews- Temporary Table
    • 3.3 Calculating Bounce Rate
    • 3.4 Landing Page Analysis
    • 3.5 Landing Page Trend Analysis
    • 3.6 Building and Analyzing Conversion Funnel- Subquery
  • Analyzing Portfolio & Management
    • 4.1 Introduction
    • 4.2 Analyzing channel portfolio 1
    • 4.3 Analyzing Channel Portfolio
    • 4.4 Comparing Channels
    • 4.5 Multi Channel Bidding
    • 4.6 Bid Changes Impact
    • 4.7 Analyzing Direct – Brand Traffic
    • 4.8 Traffic Breakdown
  • Analyzing Seasonality and Business Patterns
    • 5.1 Seasonality and Business Patterns
    • 5.2 Analyzing Seasonality
  • Product Analysis
    • 6.1 Introduction
    • 6.2 Analyzing Product sales
    • 6.3 Analyzing new product
    • 6.4 Analyzing website – Product level
    • 6.5 Analyzing website pathing
    • 6.6 Analyzing product conversion funnel
    • 6.7 Analyzing Cross-selling products
    • 6.8 Analyzing product expansion
    • 6.9 Analyzing product refund
  • User Analysis
    • 7.1 User Analysis Introduction
    • 7.2 Analyzing Repeat Behavior
    • 7.3 Identify Repeat Visitors
    • 7.4 Analyzing repeat behavior
    • 7.5 Analyzing repeat channels
    • 7.6 Conversion rates

 

Data analysis & Business Intelligence | Advanced MySQLData analysis & Business Intelligence | Advanced MySQL

Time remaining or 507 enrolls left

 

Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate