Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай Advanced SQL: MySQL Data Analysis & Business Intelligence, а также все другие курсы, прямо сейчас!
Премиум
  • Урок 1. 00:02:08
    Course Structure & Outline
  • Урок 2. 00:02:17
    Introducing the Course Project - Play the Role of Business Analyst
  • Урок 3. 00:02:18
    Setting Expectations - Focus on Business Analysis, NOT MySQL Administration
  • Урок 4. 00:00:35
    Introduction
  • Урок 5. 00:04:39
    Prerequisite Skills - Taught in my SQL Database for Beginners course
  • Урок 6. 00:00:26
    Introduction
  • Урок 7. 00:02:28
    MySQL Installation Overview - MySQL Community Server & MySQL Workbench
  • Урок 8. 00:04:54
    Mac Download - MySQL Community Server
  • Урок 9. 00:02:52
    Mac Download - MySQL Workbench
  • Урок 10. 00:07:42
    PC Download - MySQL Community Server & MySQL Workbench
  • Урок 11. 00:02:21
    Connecting MySQL Workbench to the Server
  • Урок 12. 00:01:35
    MySQL Workbench Interface
  • Урок 13. 00:07:53
    Creating the Maven Fuzzy Factory Database
  • Урок 14. 00:04:21
    Getting to Know the Database
  • Урок 15. 00:02:28
    USE mavenfuzzyfactory;
  • Урок 16. 00:00:20
    Introduction
  • Урок 17. 00:19:00
    Analyzing Top Traffic Sources
  • Урок 18. 00:02:18
    ASSIGNMENT: Finding Top Traffic Sources
  • Урок 19. 00:04:04
    SOLUTION: Finding Top Traffic Sources
  • Урок 20. 00:01:06
    ASSIGNMENT: Traffic Source Conversion Rates
  • Урок 21. 00:04:52
    SOLUTION: Traffic Source Conversion Rates
  • Урок 22. 00:15:55
    Bid Optimization & Trend Analysis
  • Урок 23. 00:00:59
    ASSIGNMENT: Traffic Source Trending
  • Урок 24. 00:04:51
    SOLUTION: Traffic Source Trending
  • Урок 25. 00:02:14
    ASSIGNMENT: Bid Optimization for Paid Traffic
  • Урок 26. 00:05:13
    SOLUTION: Bid Optimization for Paid Traffic
  • Урок 27. 00:01:32
    ASSIGNMENT: Trending w/ Granular Segments
  • Урок 28. 00:05:43
    SOLUTION: Trending w/ Granular Segments
  • Урок 29. 00:00:20
    Introduction
  • Урок 30. 00:16:43
    Analyzing Top Website Pages & Entry Pages
  • Урок 31. 00:01:00
    ASSIGNMENT: Finding Top Website Pages
  • Урок 32. 00:03:16
    SOLUTION: Finding Top Website Pages
  • Урок 33. 00:01:09
    ASSIGNMENT: Finding Top Entry Pages
  • Урок 34. 00:07:59
    SOLUTION: Finding Top Entry Pages
  • Урок 35. 00:14:22
    Analyzing Bounce Rates & Landing Page Tests
  • Урок 36. 00:00:41
    ASSIGNMENT: Calculating Bounce Rates
  • Урок 37. 00:09:27
    SOLUTION: Calculating Bounce Rates
  • Урок 38. 00:02:13
    ASSIGNMENT: Analyzing Landing Page Tests
  • Урок 39. 00:11:57
    SOLUTION: Analyzing Landing Page Tests
  • Урок 40. 00:01:10
    ASSIGNMENT: Landing Page Trend Analysis
  • Урок 41. 00:07:41
    SOLUTION: Landing Page Trend Analysis
  • Урок 42. 00:17:20
    Building Conversion Funnels & Testing Conversion Paths
  • Урок 43. 00:01:27
    ASSIGNMENT: Building Conversion Funnels
  • Урок 44. 00:07:54
    SOLUTION: Building Conversion Funnels
  • Урок 45. 00:01:50
    ASSIGNMENT: Analyzing Conversion Funnel Tests
  • Урок 46. 00:06:58
    SOLUTION: Analyzing Conversion Funnel Tests
  • Урок 47. 00:00:14
    Introduction
  • Урок 48. 00:01:38
    ASSIGNMENT: Mid-Course Project
  • Урок 49. 00:30:04
    SOLUTION: Mid-Course Project
  • Урок 50. 00:00:33
    Introduction
  • Урок 51. 00:09:05
    Analyzing Channel Portfolios
  • Урок 52. 00:01:22
    ASSIGNMENT: Analyzing Channel Portfolios
  • Урок 53. 00:04:45
    SOLUTION: Analyzing Channel Portfolios
  • Урок 54. 00:00:51
    ASSIGNMENT: Comparing Channel Characteristics
  • Урок 55. 00:04:12
    SOLUTION: Comparing Channel Characteristics
  • Урок 56. 00:01:13
    ASSIGNMENT: Cross-Channel Bid Optimization
  • Урок 57. 00:03:23
    SOLUTION: Cross-Channel Bid Optimization
  • Урок 58. 00:01:07
    ASSIGNMENT: Analyzing Channel Portfolio Trends
  • Урок 59. 00:07:24
    SOLUTION: Analyzing Channel Portfolio Trends
  • Урок 60. 00:07:22
    Analyzing Direct, Brand-Driven Traffic
  • Урок 61. 00:01:52
    ASSIGNMENT: Analyzing Direct Traffic
  • Урок 62. 00:08:23
    SOLUTION: Analyzing Direct Traffic
  • Урок 63. 00:06:37
    Analyzing Business Patterns & Seasonality
  • Урок 64. 00:01:08
    ASSIGNMENT: Analyzing Seasonality
  • Урок 65. 00:05:34
    SOLUTION: Analyzing Seasonality
  • Урок 66. 00:01:20
    ASSIGNMENT: Analyzing Business Patterns
  • Урок 67. 00:09:17
    SOLUTION: Analyzing Business Patterns
  • Урок 68. 00:00:21
    Introduction
  • Урок 69. 00:07:04
    Analyzing Product Sales & Product Launches
  • Урок 70. 00:01:06
    ASSIGNMENT: Product-Level Sales Analysis
  • Урок 71. 00:02:19
    SOLUTION: Product-Level Sales Analysis
  • Урок 72. 00:01:07
    ASSIGNMENT: Analyzing Product Launches
  • Урок 73. 00:04:27
    SOLUTION: Analyzing Product Launches
  • Урок 74. 00:09:44
    Analyzing Product-Level Website Pathing
  • Урок 75. 00:01:43
    ASSIGNMENT: Product-Level Website Pathing
  • Урок 76. 00:10:45
    SOLUTION: Product-Level Website Pathing
  • Урок 77. 00:01:56
    ASSIGNMENT: Building Product-Level Conversion Funnels
  • Урок 78. 00:13:08
    SOLUTION: Building Product-Level Conversion Funnels
  • Урок 79. 00:09:34
    Cross-Selling & Product Portfolio Analysis
  • Урок 80. 00:01:21
    ASSIGNMENT: Cross-Sell Analysis
  • Урок 81. 00:12:29
    SOLUTION: Cross-Sell Analysis
  • Урок 82. 00:01:01
    ASSIGNMENT: Product Portfolio Expansion
  • Урок 83. 00:04:48
    SOLUTION: Product Portfolio Expansion
  • Урок 84. 00:05:00
    Analyzing Product Refund Rates
  • Урок 85. 00:01:12
    ASSIGNMENT: Analyzing Product Refund Rates
  • Урок 86. 00:04:07
    SOLUTION: Analyzing Product Refund Rates
  • Урок 87. 00:00:17
    Introduction
  • Урок 88. 00:06:49
    Analyzing Repeat Visit & Purchase Behavior
  • Урок 89. 00:00:58
    ASSIGNMENT: Identifying Repeat Visitors
  • Урок 90. 00:05:50
    SOLUTION: Identifying Repeat Visitors
  • Урок 91. 00:00:56
    ASSIGNMENT: Analyzing Time to Repeat
  • Урок 92. 00:04:41
    SOLUTION: Analyzing Time to Repeat
  • Урок 93. 00:01:01
    ASSIGNMENT: Analyzing Repeat Channel Behavior
  • Урок 94. 00:03:24
    SOLUTION: Analyzing Repeat Channel Behavior
  • Урок 95. 00:00:53
    ASSIGNMENT: Analyzing New & Repeat Conversion Rates
  • Урок 96. 00:02:54
    SOLUTION: Analyzing New & Repeat Conversion Rates
  • Урок 97. 00:00:24
    Introduction
  • Урок 98. 00:01:55
    ASSIGNMENT: Final Project
  • Урок 99. 00:26:44
    SOLUTION: Final Project