Data analysis & Business Intelligence | Advanced MySQL

注意：这是一门高级 SQL 课程，建立在上一课程中涵盖的主题和技能或 SQL 查询方面的先验知识之上。…请具备最低必备技能或完成初级 SQL 课程才能完成课程

在本课程中，您将使用高级 SQL 开发现实世界的分析和商业智能技能

保证，在本课程中，您将学习如何应用高级技能，分析数据和进行业务分析，而不是学习一些高级代码

我们将从头开始浏览玩具电子商务商店的真实项目数据库

您将扮演数据分析师的角色，直接与行政总裁和董事合作，帮助发展业务、分析绩效并优化商店、网站、产品和用户体验

您将使用诸如临时表、子查询等高级技能来解决多步数据问题，让您像分析师一样思考

课程大纲

从下载SQL server连接数据库的介绍

在本节中，我们将介绍如何安装 MySQL 工作台并将数据库连接到服务器以及创建连接，看完这部分后，请确保您具备包括 SELECT 语句、聚合函数和表连接在内的相关技能。

分析流量来源

在本节中，我们将热身并针对一些查询做一些回顾，然后我们将分析我们的流量来源，不同来源在流量方面的表现，计算转化率，分析出价并优化它，趋势分析

分析网站性能

在本节中，我们将分析网站综合浏览量并使用 TEMPORAY TABLE、计算跳出率、分析着陆页和使用 SUBQUERIES

分析渠道组合管理

在本节中，我们将比较渠道并进行多渠道竞价，同时分析竞价变化的影响，流量细分。

分析业务模式和季节性

在本节中，我们将深入研究流量分析，并探索更多关于有机和付费活动，以及季节性和业务模式分析

产品分析

在本节中，我们将细分产品级别的销售、转化率和交叉销售模式以及退款率分析以保持质量

用户分析

在本节中，我们深入分析用户行为并分析重复会话，以识别最有价值的客户并探索他们来自哪些渠道

MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 42 lectures (7h 3m) | Size: 3.23 GB

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

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

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