|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/google-data-studio-master-the-advanced-concepts/
课程评论：没有评论
课程名称：Google Data Studio - 掌握高级概念 课程概述：在本课程中，您将掌握 Google Data Studio 的高级功能，以理解可用于将数据集和数据可视化转换为所需格式的所有选项。 目标群体：本课程适合那些具备 Google Data Studio 中级知识、希望获得更高级知识的人士。参与者应具备 Data Studio 使用经验、Excel 函数经验和/或基本的 SQL 知识，并希望了解 Google Data Studio 提供的全方位功能。 课程内容： 1. 可视化：学习使用透视表、组合图表与双轴图表、堆叠条形图和区域图。 2. 布局：设置全局色彩调色板的方法。 3. 数据集转换：使用计算字段和 Data Studio 支持的一系列函数（如 Median（中位数）、Variance（方差）、Percentile（分位数）、Concat（连接）、Substr（子串）），以及用于分组维度值的 Case 语句来转换指标和维度。 4. 超链接和可点击图像：为数据表添加图像和链接，以在报告中展示和链接至产品。 5. 过滤器：使用组级和页面级过滤器，对报告添加更多控制。 6. 嵌入：如何将报告嵌入外部应用或网站。 7. 数据库：连接 SQL 数据库表、视图和自定义查询，连接 BigQuery。 适用角色： - 在线营销人员 - 产品分析师 - 数据分析师 - 财务分析师 - 产品负责人/经理 - 小企业主 您可能已使用的数据源包括：Google Analytics、Adwords 或其他 Google 产品、Google Sheets、Excel、SQL 数据库（如 MySQL、BigQuery、PostGresQL）。 Google Data Studio 的强大之处在于其直观设计，让您创建比 GA 和 Google Sheets 更直观的仪表板设计；构建可共享的仪表板，保存在 Google Drive 中以扩展您的洞察；快速生成报告和可视化，以在几分钟内回答问题；用户友好的模板和布局，使用户更容易解读数据。 Google Data Studio 是 Google 创建的数据可视化工具，是 Google 套件中的一部分，包括 Google Docs、Google Sheets 和 Google Slides。Data Studio 免费，并允许您连接多种数据源。它是创建强大且互动的仪表板以探索基础数据的绝佳工具。期待您与我一起掌握 Google Data Studio 中的高级概念，充分理解您掌握的各种能力。
In this course you'll master the advance features in Google Data Studio, so that you understand all the options available for transforming your data sets and data visualisations into the format you need. Target Audience This course is for people who have an intermediate knowledge of Google Data Studio and want to gain advance knowledge. You already have experience with Data StudioYou have experience with Functions in Excel and/or Basic knowledge of SQLWant to understand the full range of capabilities that Google Data Studio offers Curriculum In this course you will cover in detail: Visualisations - Pivot Tables, Combination & Dual Axis Charts, Stacked Bar & Area Charts Layout - How to set global colour palettes Transforming Data Sets - Transforming Metrics & Dimensions with Calculated Fields and a range of functions that Data Studio supports e.g Median(), Variance(), Percentile(), Concat(), Substr() as well as Case Statements for grouping dimension values together. Hyperlinks and Clickable images - Adding images and links to data tables to show and link through to your products in your reports Filters - Group and Page Level filters to add more control to your reports Embedding - How to embed your reports into an external application or website. Databases - Connecting to SQL database tables, views and custom queries. We will connect to BigQuery. Roles Your role might fall into one of the following Online MarketerProduct AnalystData AnalystFinance AnaystProduct Owners/ManagerSmall business Owner Data Sources you may already use Google Analytics, Adwords or other Google Product Google Sheets Excel SQL Database e.g MySQL, BigQuery, PostGresQL The Power of Data Studio Intuitive Design - create dashboard designs that are more intuitive than dashboards in GA & Google SheetsScale your insights - build shareable dashboards saved in Google DriveSpeed up time to insight - build reports and visualisations to answer questions within minutesUser friendly Templates and Layouts - will make it easier for users to interpret the data. Data Studio is a Data Visualisation Tool created by Google. It is part of the Google Suite including Google Docs, Google Sheets and Google Slides. Data Studio is FREE and allows you to connect to a range of data sources. It's an incredible tool to create powerful and interactive dashboards for you to explore your underlying data. I look forward to showing you how to master the advance concepts in Google Data Studio so that you understand the full range of capabilities at your fingertips.
