|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/extract-transform-and-load-data
课程评论:没有评论
课程名称:提取、转换与加载数据 课程概述:本课程旨在为希望学习数据科学过程首个技术阶段(即提取、转换与加载,简称ETL)的商务和数据专业人士提供指导。学习者将学习如何从多个来源收集数据,以便进行后续的转换和清理,然后深入探讨收集到的数据集,为后续的分析和建模做好准备。课程结束时,学习者将把数据加载到最终目的地,以便进行分析。 适合人群:本课程的典型学员在数据处理方面具备一定的经验,并且具备计算机编程的能力。 课程大纲: 1. 提取数据: - 描述:数据科学流程中的第一个实际操作技术阶段是ETL,它由相关任务组成。在这一阶段,数据科学从业者开始塑造数据,以便为后续的数据科学步骤提供最大效用,课程将顺序介绍每个ETL任务,从“E”(提取)开始。 2. 转换数据: - 描述:ETL过程中的下一步是数据转换。在这一模块中,学员将调整数据,使其处于更有用的状态。 3. 加载数据: - 描述:ETL过程的最后一步是数据加载。在这一模块中,学员将把转化后的数据放入目的格式和位置,为后续项目的进一步工作做好准备。 4. 应用所学知识: - 描述:学员将参与一个项目,实际应用在本课程中所学的知识,解决具体情境中的问题。 此课程将帮助学员掌握ETL过程中的关键技能,以便更有效地处理和分析数据。
Name:Extract Data
Description:The first truly hands-on technical phase of the data science process is actually a combination of related tasks known as extract, transform, and load (ETL). This is where you, the data science practitioner, start to mold and shape the data so that it can be as useful as possible for the later steps in the data science process. In this course, you'll go through each ETL task in order, starting with "E" (extract).
Name:Transform Data
Description:The next step in the ETL process is transformation. You'll spend this next module adjusting your data so that it's in a more useful state.
Name:Load Data
Description:The last step in the ETL process is loading. In this module, you'll take the data you transformed and put it into a destination format and location, where it will be ready for you to work on as the project progresses.
Name:Apply What You've Learned
Description:You'll work on a project in which you'll apply your knowledge of the material in this course to a practical scenario.
This course is designed for business and data professional seeking to learn the first technical phase of the data science process known as Extract, Transform and Load or ETL. Learners will be taught how to collect data from multiple sources so it is available to be transformed and cleaned and then will dive into collected data sets to prepare and clean data so that it can later be loaded into its ultimate destination. In the conclusion of the course learners will load data into its ultimate destination so that it can be analyzed and modeled. The typical student in this course will have experience working with data and aptitude with computer programming.