|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analysis-business-intelligence-advanced-mysql/
课程评论：没有评论
课程名称：商业智能与数据分析高级 MySQL 概述：本课程为高级 SQL 课程，建立在先前课程的主题和技能基础之上，要求参加者具备最低的先决条件，或完成初学者 SQL 课程。课程旨在通过分析电子商务商店的数据，帮助学员提升实际分析和商业智能技能，获取网站、产品及用户体验的洞察。学员将不只是学习高级代码，而是将这些技能应用于数据分析与商业分析中。课程将从零开始，全面讲解玩具电子商务商店的真实项目数据库。 课程内容： 1. 编写高级 SQL 查询并分析数据库。 2. 学习使用临时表和子查询处理复杂多步骤的数据问题。 3. 分析电子商务实际案例，解决相关任务。 4. 掌握多表连接（JOIN）语句。 课程大纲： - 介绍：从下载 SQL 服务器到连接数据库，讲解如何安装 MySQL Workbench 并创建数据库连接。学员需掌握 SELECT 语句、聚合函数和表连接。 - 分析流量来源：复习查询知识，分析流量来源及其表现，包括流量量、转化率、出价分析及趋势分析。 - 分析网站性能：分析网页浏览量，使用临时表计算跳出率，分析着陆页，使用子查询。 - 分析渠道组合管理：比较不同渠道，进行多渠道出价，分析出价变化的影响与流量分布。 - 分析商业模式与季节性：深入流量分析，探索有机与付费活动，讨论季节性与商业模式分析。 - 产品分析：深入销售，转化率，交叉销售模式与退款率分析，确保质量。 - 用户分析：深度分析用户行为，分析重复会话，以识别最有价值的客户及其渠道来源。 通过这个高级课程，学员将培养分析师思维，运用先进的 SQL 技能进行全面的数据分析。
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 experienceGUARANTEED, 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 tooWe will walk through real project database of eCommerce store for toys from scratch What you will 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 tablesYou will use advanced skills such TEMPORARY TABLE, Subqueries to solve multistep data problem which make you THINK like an ANALYSTCOURSE 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 sourceIn 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 analysisAnalyzing website performanceIn this section we will analyze website pageviews and use TEMPORAY TABLE, calculate bounce rate, analyzing landing page, and use SUBQUERIESAnalyzing Channel portfolio managementIn this section we will compare channels and do multi channel bidding , also analyzing bid changes impact, traffic breakdown.Analyzing Business Patterns and SeasonalityIn this section we will dig deeper into traffic analysis and explore more about organic and paid campaign, also seasonality and business patterns analysisProduct AnalysisIn this section we will break down sales on product level, conversion rates and cross-selling patterns and refund rates analysis to keep qualityUser AnalysisIn 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
