|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/sql-data-science-capstone
课程评论：没有评论
课程名称：SQL数据科学顶点项目 课程概述：数据科学是一个不断发展且日益增长的职业领域，成功需要扎实的SQL知识和技能。本课程旨在为您提供一个坚实的基础，以通过SQL技能分析数据并解决实际商业问题。无论您是已经成功完成了“数据科学基础SQL学习专门化”中的其他课程，还是仅选修本课程，此项目都是您应用所学知识和技能的良机，实践重要的SQL查询并利用数据解决问题。您将参与个人或职业的旅程，从头到尾创建一个有价值的作品集。您将选择一个数据集并制定项目提案，探索您的数据并进行初步统计分析。您将揭示定性数据的分析，并考虑在分析中浮现的模式所带来的新指标。最终，您将以演示的形式汇总您的全部工作，讲述您的发现过程。在这个过程中，您将通过同行评审获得反馈，这个学习者社区将为您提供额外的建议，帮助您改进数据分析的方式，并向客户和管理层展示您的发现。 课程大纲： 1. 入门与里程碑1：项目提案与数据选择/准备 - 描述：在第一个里程碑中，您将选择客户并导入数据集。您将开始探索数据，以了解其特征并对数据进行假设。您将草拟一份项目提案，作为您探索数据时的指南，以验证或推翻您的假设。 2. 里程碑2：描述性统计与数据理解 - 描述：在这一里程碑中，您将开始执行项目提案，查看数据，进行初步统计模型的探索，确定可用数据。 3. 里程碑3：超越描述性统计（深入分析/广泛研究） - 描述：在此里程碑中，您将超越上一步的描述性统计，深入分析数据，可能需要分析定性数据或文本数据，以获取完整的分析图景。 4. 里程碑4：呈现您的发现（讲故事） - 描述：在这一里程碑中，您将展示您的发现，识别您的观众，并创建针对他们的演示文稿。您将能够讲述分析的故事并提出建议。
Name:Getting Started and Milestone 1: Project Proposal and Data Selection/Preparation
Description:In this first milestone, you will select your client and import your dataset. You will begin to explore your data to understand it and make assumptions about your data. You will draft a project proposal to act as a guide as you explore your data and prove or disprove your hypotheses.
Name:Milestone 2: Descriptive Stats & Understanding Your Data
Description:In this milestone, you will start to execute your project proposal. You will start looking at your data and perform initial statistic models to explore your data and determine what you have available to you.
Name:Milestone 3: Beyond Descriptive Stats (Dive Deeper/Go Broader)
Description:In this milestone, you will go beyond the descriptive statistics you completed in the last milestone. This milestone is really about diving deeper to analyze your data, beyond descriptive stats. Maybe you need to analyze qualitative data or textual data to get a full picture.
Name:Milestone 4: Presenting Your Findings (Storytelling)
Description:In this milestone, you will present your findings. You will identify your audience and create a presentation tailored to them. You will be able to tell the story of analyses and make recommendations.
Data science is a dynamic and growing career field that demands knowledge and skills-based in SQL to be successful. This course is designed to provide you with a solid foundation in applying SQL skills to analyze data and solve real business problems. Whether you have successfully completed the other courses in the Learn SQL Basics for Data Science Specialization or are taking just this course, this project is your chance to apply the knowledge and skills you have acquired to practice important SQL querying and solve problems with data. You will participate in your own personal or professional journey to create a portfolio-worthy piece from start to finish. You will choose a dataset and develop a project proposal. You will explore your data and perform some initial statistics you have learned through this specialization. You will uncover analytics for qualitative data and consider new metrics that make sense from the patterns that surface in your analysis. You will put all of your work together in the form of a presentation where you will tell the story of your findings. Along the way, you will receive feedback through the peer-review process. This community of fellow learners will provide additional input to help you refine your approach to data analysis with SQL and present your findings to clients and management.
