|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advanced-applied-sql-for-business-intelligence-and-analytics/
课程评论：没有评论
课程名称：高级应用 SQL 以支持商业智能与分析 课程概述：本课程以实例为基础，提供细致和互动的讲解。我们理解您可能会遇到的一些常见错误和误解，并帮助您掌握复杂的 SQL 概念。课程详细介绍了窗口函数的应用，解决与寻找首次订单或第 N 次事件、计算事件之间的时间间隔、以及客户的新旧购买行为相关的问题。您将学习如何从 SQL 到在 Tableau 中建立本地连接的整个工作流程，并进行相应的分析，这些都将对您的职业生涯大有裨益。课程将通过案例研究讲解诸如 CASE 语句、公共表表达式和子查询的概念。您还将使用 Python 生成网络分析获取来源数据，并创建表格以存储您的信息。课程结束时，您将完成所有实例的操作，并能够自信地应对复杂的问题。通过本课程，您将大幅提升数据处理能力，未来一到两年内将获得 100 倍的时间投资回报！ 作者简介：杰弗瑞·詹姆斯（Jeffrey James）自 2006 年以来一直从事分析和数据领域的工作。他在数字营销和网络分析方面有深厚的根基，已将分析技术应用于客户价值分析、财务预测、机器学习和流程自动化等问题上。在掌握的过程中，他也曾犯过许多错误，因此他深刻理解初学者的心态。
This example-driven course provides thoughtful and interactive commentary throughout. We understand the common mistakes and misconceptions you might make and help you navigate tricky SQL concepts.Window Functions are used in detail throughout the course to solve problems dealing with finding the first order or the Nth instance of an event, computing the timing between events, and new and repeat purchase behaviors among customers. You'll run through the workflow from SQL to a localhost connection in Tableau and also analysis, all of which you'll need in your professional life. Concepts such as CASE statements, common table expressions, and subqueries will be explained via case studies. You'll generate web analytics acquisition source data using Python and then create tables to store your information.By the end of the course, you will have gone through all the examples and coded them out, and you'll be ready to confidently tackle non-trivial problems. Supercharge your data productivity today with this course and get 100x your time investment back in the next year or two! About the Author Jeffrey James has been working in the analytics and data space since 2006. With roots in digital marketing and web analytics, he's applied analytical techniques to problems including customer value analysis, financial forecasting, machine learning, and process automation. He's made his share of mistakes on the way to mastery and understands the mindset of a beginner/learner.
