|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/google-2-in-1-quick-starter-looker-studio-and-google-sheets/
课程评论：没有评论
课程名称：Google 2合1快速入门：Looker Studio与Google Sheets 课程概述：本课程适合所有对Google Sheets和Google Looker Studio感兴趣的初学者。学员将学习如何使用Looker Studio创建一个简单的互动仪表板，并以Google Sheets作为数据源。本课程以多个投资账户（如个人投资账户和退休账户）的股市投资案例为背景，讲解如何使用Google Sheets中的GOOGLEFINANCE功能获取持有股票的实时信息。这一强大的速成课程将帮助学员建立一个集中视图，使得管理财务资产更加简便。学完本课程后，学员可以测试自己的投资策略，甚至与他人进行无风险的策略对比。 课程内容包括： - Google Sheets部分： - 理解并使用GOOGLEFINANCE函数 - 创建下拉选择列表用于列 - 跟踪多种投资的多列数据 - Looker Studio部分： - 将Google Sheets作为数据源 - 理解指标和维度 - 讨论数据类型 - 创建包含表格、图形、计分卡和下拉控制的互动仪表板 - 掌握三种过滤层级 - 定义表格的条件格式 - 提供其他实用技巧 总之，本课程将实用与趣味结合，适合任何希望提升数据处理与展示能力的学员。
Either you are new to Google Sheets and/or Google Looker Studio you will learn to create a simple interactive dashboard in Looker Studio. We will use the Google Sheet as the data source in this crash course.What you will learn can be applied to many situations.I will use the case of multiple investments in the stock market within multiple accounts, e.g. personal investment account and retirement account. You will learn how to use the google finance function in google sheets to get current information on a held position.This powerful crash course will help you create a consolidated view. Having a single view of your investments can simplify the ongoing management of your financial assets.After learning this course you could test your investment strategy over time. You could even have a challenge with another person to see who's investment strategy is performing better without any real money or getting an account at a financial institution. Below is what you will learn in each Google Sheets and Looker StudioSheetsGOOGLEFINANCE function and useBuild dropdown picklists for columnsCreate multiple columns to track the investmentsLooker StudioUse that google sheet as the data sourceLearn about metrics and dimensionsDiscuss data typesCreate an interactive dashboard that will contain a table, graphs, scorecard & dropdown controlUnderstand 3 levels of filtersDefine conditional formatting on a tableOther useful tips
