|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/data-analysis-with-spreadsheets-and-sql
课程评论：没有评论
课程名称：使用电子表格和SQL进行数据分析 概述：本课程将指导您如何使用电子表格和SQL查询进行数据分析和提取数据。您将学习如何实际应用OSEMN数据分析框架和电子表格功能来清理数据、计算摘要统计、评估相关性等。此外，您还将深入了解常见的数据可视化技术，并学习如何使用仪表板讲述数据故事。 课程目标： • 使用电子表格清理数据 • 运用常见电子表格功能进行数据分析 • 通过SQL提取数据 • 进行数据可视化并创建仪表板 课程大纲： 1. 数据处理基础：本周您将学习电子表格的基本知识及其在数据分析中的实用性，并识别如何在电子表格中应用OSEMN框架。 2. 使用电子表格进行数据分析：本周您将学习如何使用基础的电子表格功能清理数据，计算摘要统计，并识别数据趋势及变量之间的关系。 3. 使用SQL提取数据：本周您将接触SQL及其在电子表格中的应用，使用基本查询和函数处理数据。 4. 数据可视化：本周您将了解常见的图表类型，并学习如何确定最适合呈现数据集的图表类型，还将使用Google Sheets和Tableau创建这些图表。 5. 创建仪表板：在最后一周，您将学习仪表板的基本概念及其在商业环境中的进展报告功能，并学会如何在Tableau中创建仪表板，以讲述数据发现的故事。 通过本课程的学习，您将掌握使用电子表格和SQL进行数据分析的基本技能，为数据驱动的决策提供支持。
Name:Working with Data in Spreadsheets
Description:This week you learn the basics of spreadsheets and their usefulness in data analysis. You will also identify how to apply the OSEMN framework when working with data in spreadsheets.
Name:Data Analysis with Spreadsheets
Description:This week you will learn how to clean data in spreadsheets using foundational spreadsheet functions. You will also learn how to calculate summary statistics in spreadsheets as well as how to identify data trends and relationships between variables.
Name:Extracting Data with SQL
Description:This week you will be introduced to SQL and how it is used in spreadsheets. You will utilize basic queries and functions for handling data with SQL.
Name:Data Visualization
Description:This week you will learn about common chart types and how to determine the best type of chart for the dataset you want to present. You will also learn how to create these charts using both Google Sheets and Tableau.
Name:Creating Dashboards
Description:In the final week you will be introduced to dashboards and how to use them to report on progress within a business setting. You will also learn how to create dashboards in Tableau and use these to tell a story when presenting your data findings.
This course introduces you to how to use spreadsheets and SQL queries to analyze and extract data. You will learn how to practically apply the OSEMN data analysis framework and spreadsheet functions to clean data, calculate summary statistics, evaluate correlations, and more. You’ll also dive into common data visualization techniques and learn how to use dashboards to tell a story with your data. By the end of this course you will be able to: • Clean data with spreadsheets • Use common spreadsh
