Data analysis & Business Intelligence | Advanced MySQL

Description

NOTE: That is an ADVANCED SQL course, constructed on matters and abilities coated within the earlier course or on prior data in SQL queries….Please have the minimal prerequisite abilities or full the Newbie SQL course to have the ability to full the course

On this course you’ll develop real-world analytics and Business Intelligence abilities utilizing Advanced SQL by Analyzing an ecommerce retailer to get perception for the efficiency of the web site, merchandise and consumer expertise

GUARANTEED, as a substitute of studying some superior codes, on this course you’ll learn to apply the superior abilities, analyzing the information and doing Business analysis too

We are going to stroll via actual mission database of eCommerce retailer for toys  from scratch

You’ll be enjoying a task as Data Analyst working immediately with executives CEO and Administrators to assist develop the enterprise, analyzing efficiency and optimize the shop, web site, merchandise, and consumer expertise

You’ll use superior abilities such TEMPORARY TABLE, Subqueries to unravel multistep knowledge downside which make you THINK like an ANALYST

COURSE OUTLINES :

• Introduction from downloading SQL server to attach the database

  On this part we’ll take about the way to set up MySQL workbench and join the database to the server plus creating  a connection, after watching this half ensure you have the related abilities together with SELECT statements, Mixture Capabilities and tables joins.

• Analyzing Visitors supply

  On this part we’ll heat up and do some evaluate for some queries, then we’ll analyze the place our visitors supply coming from, how totally different sources carry out by way of visitors quantity, calculate conversion charges, analyzing bids and optimize it, pattern analysis

• Analyzing web site efficiency

  On this part we’ll analyze web site pageviews and use TEMPORAY TABLE, calculate bounce fee, analyzing touchdown web page, and use SUBQUERIES

• Analyzing Channel portfolio administration

  On this part we’ll examine channels and do multi channel bidding , additionally analyzing bid adjustments affect, visitors breakdown.

• Analyzing Business Patterns and Seasonality

  On this part we’ll dig deeper into visitors analysis and discover extra about natural and paid marketing campaign, additionally seasonality and enterprise patterns analysis

• Product Analysis

  On this part we’ll break down gross sales on product degree, conversion charges and cross-selling patterns and refund charges analysis to maintain high quality

• Person Analysis

  On this part we deep analyze consumer habits and analyze the repeated periods to establish Most worthy prospects and discover which channels they’re coming from