|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/comprehensive-google-sheets-master-class/
课程评论：没有评论
**课程名称：** Comprehensive Google Sheets Master Class (综合版 Google 表格大师班) **课程概述：** 本课程是一门互动式数据分析课程，专注于利用 Google 表格解决实际商业问题。在课程中，我们将以一家名为“Prime Tech Academy”的教育科技公司为例，该公司面临客户满意度下降的问题。作为产品经理，您将受命进行一项全球客户满意度调查，以找出问题根源，深入分析并提供数据驱动的解决方案。 **核心内容：** 1. **通过 Google 表单收集数据：** 学习如何设计和部署 Google 表单以收集客户信息。 2. **将数据同步至 Google 表格进行清洗和格式化：** 掌握将表单数据导入 Google 表格，并进行数据清洗和规范化处理的技巧。 3. **利用 Google 表格公式和函数进行数据分析：** 学习使用各种 Google 表格的内置函数和公式来分析收集到的数据。 4. **通过 Google 表格进行数据分析并制作仪表盘展示结果：** 学习如何利用 Google 表格的强大功能进行深入分析，并创建可视化仪表盘来呈现分析结果。 **课程亮点：** * **实战导向：** 课程以解决真实商业问题为主线，让学习者在实践中掌握 Google 表格的应用。 * **流程完整：** 涵盖了从数据收集、清洗、分析到结果呈现的完整数据分析流程。 * **工具聚焦：** 专注于 Google 表格，并指出其与其他电子表格软件（如 Microsoft Excel）的共通之处，强调知识的通用性。 * **平台优势：** 强调 Google 表格的免费、基于网页、实时协作和版本历史记录等优势。 **目标人群：** 任何希望提升数据分析能力，特别是熟练掌握 Google 表格工具的学习者。 **课程价值：** 通过本课程的学习，您将能够独立完成一项由数据收集到结果呈现的完整数据分析项目，并为解决实际商业问题提供有力的数据支持。
An interactive Data Analysis Course with Google Sheets.In this course, we will be solving a real life business problem."Prime Tech Academy is an EdTech company that produces different educational products for schools and students. The company has branches across the globe. Recently, they are having customer satisfaction problems. Customers are beginning to lose interest in them and their products.Emily, the company's Vice President has commissioned you (the Product Manager) to conduct a survey to check the level of customer satisfaction across the globe in order to find the missing puzzle, deep dive into the issues and proffer data-driven solutions.After meeting with your team, you agreed to use a google form to get information from clients. This will then be compiled and analysed using Google sheets."We will solve the Prime Tech Academy's problem using step-by-step Google Sheets data analysis. We will1. Collect Data via Google Forms2. Sync Data with Google Sheets for Cleaning and Formatting3. Analyse Data with Google Sheets Formulas and Functions4. Analyse Data with Google Sheets and Presenting Results on a DashboardThe two most commonly used spreadsheet programs by data analysts around the world are Microsoft Excel and Google Sheets.Almost everything you do in one relates to the other. The knowledge of one is certainly applicable in the other. Basically the same functions, structure and manipulations.But for the sake of this course, we will concentrate on Google sheets. If you are comfortable with Excel 95% of what this course teaches is applicable.Google Sheets is a free, web-based spreadsheet application that is provided by Google within the Google Drive service. The application is also available as a desktop application on ChromeOS, and as a mobile app on Android, Windows, iOS, and BlackBerry. The Google Drive service also hosts other Google products such as Google Docs, Slides, and Forms.Google Sheets allows users to edit, organise, and analyse different types of information. It allows collaborations, and multiple users can edit and format files in real-time, and any changes made to the spreadsheet can be tracked by a revision history.
