Aliaksei Kuzniatsou
成为会员时间:2023
钻石联赛
34520 积分
成为会员时间:2023
完成 Looker 資料模型管理技能徽章中階課程,即可證明您具備下列技能:維護 LookML 專案的健全性、運用 SQL Runner 驗證資料、採用 LookML 最佳做法、改良查詢及 報表,並執行永久衍生資料表和快取政策。
完成「在 Looker 建構 LookML 物件」技能徽章入門課程, 即可證明您具備下列技能: 建立新的維度和測量指標、檢視畫面和衍生資料表;根據需求設定測量指標篩選器和類型; 更新維度和測量指標; 建構及調整「探索」;將檢視表彙整至現有「探索」;以及配合業務需求決定要建立哪些 LookML 物件。
Data Catalog is deprecated and will be discontinued on January 30, 2026. You can still complete this course if you want to. For steps to transition your Data Catalog users, workloads, and content to Dataplex Catalog, see Transition from Data Catalog to Dataplex Catalog (https://cloud.google.com/dataplex/docs/transition-to-dataplex-catalog). Data Catalog is a fully managed and scalable metadata management service that empowers organizations to quickly discover, understand, and manage all of their data. In this quest you will start small by learning how to search and tag data assets and metadata with Data Catalog. After learning how to build your own tag templates that map to BigQuery table data, you will learn how to build MySQL, PostgreSQL, and SQLServer to Data Catalog Connectors.
完成 在 Google Cloud 為機器學習 API 準備資料 技能徽章入門課程,即可證明您具備下列技能: 使用 Dataprep by Trifacta 清理資料、在 Dataflow 執行資料管道、在 Dataproc 建立叢集和執行 Apache Spark 工作,以及呼叫機器學習 API,包含 Cloud Natural Language API、Google Cloud Speech-to-Text API 和 Video Intelligence API。
完成「為 Looker 資訊主頁和報表準備資料」技能徽章入門課程, 即可證明您具備下列技能:可篩選、排序和 pivot 資料、合併不同的 Looker 探索結果, 還能使用函式和運算子建構 Looker 資訊主頁和報表,取得資料分析結果和圖表。
在本課程中,您將透過實際操作,瞭解如何在 Looker 應用進階 LookerML 概念。您將學習如何使用 Liquid 自訂和建立動態維度 和測量指標、建構動態 SQL 衍生資料表和自訂的原生衍生資料表, 並運用擴充參數將 LookML 程式碼模組化。
完成「運用 BigQuery ML 建立機器學習模型」技能徽章中階課程,即可證明您具備下列技能: 可使用 BigQuery ML 建立及評估機器學習模型,並根據資料進行預測。
完成 從 BigQuery 資料取得深入分析結果 技能徽章入門課程,即可證明您具備下列技能: 撰寫 SQL 查詢、查詢公開資料表、將樣本資料載入 BigQuery、使用 BigQuery 的查詢驗證工具 排解常見語法錯誤,以及在 Looker Studio 中 透過連結 BigQuery 資料建立報表。
This course empowers you to develop scalable, performant LookML (Looker Modeling Language) models that provide your business users with the standardized, ready-to-use data that they need to answer their questions. Upon completing this course, you will be able to start building and maintaining LookML models to curate and manage data in your organization’s Looker instance.
這堂初級課程將介紹 Google Cloud 的資料分析工作流程,以及用於探索、分析資料並以圖表呈現的工具。您也能學會如何與相關人員分享自己的發現結果。本課程包含個案研究、實作實驗室、講座、測驗和示範,實際展示如何將原始資料集轉化為清晰的資料,進而呈現出能發揮成效的圖表和資訊主頁。無論您是資料領域從業人員、想瞭解如何透過 Google Cloud 取得成功,或有意在職涯中更上一層樓,本課程都能協助您踏出第一步。絕大多數在工作上執行或運用資料分析的學員,都能從本課程受益。
In this quest, you will get hands-on experience with LookML in Looker. You will learn how to write LookML code to create new dimensions and measures, create derived tables and join them to Explores, filter Explores, and define caching policies in LookML.
In this course, you learn how to do the kind of data exploration and analysis in Looker that would formerly be done primarily by SQL developers or analysts. Upon completion of this course, you will be able to leverage Looker's modern analytics platform to find and explore relevant content in your organization’s Looker instance, ask questions of your data, create new metrics as needed, and build and share visualizations and dashboards to facilitate data-driven decision making.
This course teaches you how to implement various capabilities that include data organization and management, application security, actions and integrations in your app using AppSheet. The course also includes topics on managing and upgrading your app, improving performance and troubleshooting issues with your app.
This course helps you recognize the need to implement business process automation in your organization. You learn about automation patterns and use cases, and how to use AppSheet constructs to implement automation in your app. You learn about the various features of AppSheet automation, and integrate your app with Google Workspace products. You also learn how to send email, push notifications and text messages from your app, parse documents and generate reports with AppSheet automation.
In this course you will learn the fundamentals of no-code app development and recognize use cases for no-code apps. The course provides an overview of the AppSheet no-code app development platform and its capabilities. You learn how to create an app with data from spreadsheets, create the app’s user experience using AppSheet views and publish the app to end users.
Workspace is Google's collaborative applications platform, delivered from Google Cloud. In this introductory-level course you will get hands-on practice with Workspace’s core applications from a user perspective. Although there are many more applications and tool components to Workspace than are covered here, you will get experience with the primary apps: Gmail, Calendar, Sheets and a handful of others. Each lab can be completed in 10-15 minutes, but extra time is provided to allow self-directed free exploration of the applications.
完成在 Google 試算表使用函式、公式及圖表技能徽章中階課程, 即可證明您具備下列技能:運用函式分析資料、使用圖表呈現資料、設定資料格式,以及搜尋、 驗證與顯示資料。
完成「實現雲端協作與生產力工作流」課程,即可獲得入門級技能徽章。本課程將介紹 Google 的協作平台, 帶您瞭解如何使用 Gmail、日曆、Meet、雲端硬碟、試算表和 AppSheet。
This course builds on some of the concepts covered in the earlier Google Sheets course. In this course, you will learn how to apply and customize themes In Google Sheets, and explore conditional formatting options. You will learn about some of Google Sheets’ advanced formulas and functions. You will explore how to create formulas using functions, and you will also learn how to reference and validate your data in a Google Sheet. Spreadsheets can hold millions of numbers, formulas, and text. Making sense of all of that data can be difficult without a summary or visualization. This course explores the data visualization options in Google Sheets, such as charts and pivot tables. Google Forms are online surveys used to collect data and provide the opportunity for quick data analysis. You will explore how Forms and Sheets work together by connecting collected Form data to a spreadsheet, or by creating a Form from an existing spreadsheet.
In this course, we introduce you to Google Chat, Google’s chat software included with Google Workspace. You will learn about messaging individuals and groups in Google Chat. You will also discover customization options, collaboration features and how Google Chat integrates with other Google Workspace products. We will explore the use of spaces in Google Chat, showing you how to create, manage, search, and join them. Additionally, you will understand the distinctions between using a space and a group chat. You also explore Google Chat apps and learn how to search for and use apps within Google Chat. Aside from course videos, you will complete hands-on activities to practice what you’ve learned. Consider inviting a colleague or two to interact with you in Google Chat as you complete the activities.
In this course, we introduce you to Google Meet, Google’s video conference software included with Google Workspace. You learn how to create and manage video conference meetings using Google Meet. You explore different ways to open Google Meet and add people to a video conference. You also learn how to join meetings from different sources like calendar events or meeting links. We discuss how Google Meet can help you better communicate, exchange ideas, and share resources with your team wherever they are. You learn how to customize the Google Meet environment to fit your needs and how to effectively use chat messages during a video conference. You also explore different ways to share resources, such as by using calendar invites or attachments. You learn about using host controls in Google Meet to manage participants and utilize interactive moderation features. You also learn how to record and live stream video conferences.
With Google Slides, you can create and present professional presentations for sales, projects, training modules, and much more. Google Slides presentations are stored safely in the cloud. You build presentations right in your web browser—no special software is required. Even better, multiple people can work on your slides at the same time, you can see people’s changes as they make them, and every change is automatically saved. You will learn how to open Google Slides, create a blank presentation, and create a presentation from a template. You will explore themes, layout options, and how to add and format content, and speaker notes in your presentations. You will learn how to enhance your slides by adding tables, images, charts, and more. You will also learn how to use slide transitions and object animations in your presentation for visual effects. We will discuss how to organize slides and explore some of the options, including duplicating and ordering your slides, importi…
In this course we will introduce you to Google Sheets, Google’s cloud-based spreadsheet software, included with Google Workspace. With Google Sheets, you can create and edit spreadsheets directly in your web browser—no special software is required. Multiple people can work simultaneously, you can see people’s changes as they make them, and every change is saved automatically. You will learn how to open Google Sheets, create a blank spreadsheet, and create a spreadsheet from a template. You will add, import, sort, filter and format your data using Google Sheets and learn how to work across different file types. Formulas and functions allow you to make quick calculations and better use your data. We will look at creating a basic formula, using functions, and referencing data. You will also learn how to add a chart to your spreadsheet. Google Sheets spreadsheets are easy to share. We will look at the different ways you can share with others. We will also discuss how to track changes…
With Google Docs, your documents are stored in the cloud, and you can access them from any computer or device. You create and edit documents right in your web browser; no special software is required. Even better, multiple people can work at the same time, you can see people’s changes as they make them, and every change is saved automatically. In this course, you will learn how to open Google Docs, create and format a new document, and apply a template to a new document. You will learn how to enhance your documents using a table of contents, headers and footers, tables, drawings, images, and more. You will learn how to share your documents with others. We will discuss your sharing options and examine collaborator roles and permissions. You will learn how to manage versions of your documents. Google Docs allows you to work in real time with others on the same document. You will learn how to create and manage comments and action items in your documents. We will review a few of the G…
Google Drive is Google’s cloud-based file storage service. Google Drive lets you keep all your work in one place, view different file formats without the need for additional software, and access your files from any device. In this course, you will learn how to navigate your Google Drive. You will learn how to upload files and folders and how to work across file types. You will also learn how you can easily view, arrange, organize, modify, and remove files in Google Drive. Google Drive includes shared drives. You can use shared drives to store, search, and access files with a team. You will learn how to create a new shared drive, add and manage members, and manage the shared drive content. Google Workspace is synonymous with collaboration and sharing. You will explore the sharing options available to you in Google Drive, and you will learn about the various collaborator roles and permissions that can be assigned. You’ll also explore ways to ensure consistency and save time…
With Google Calendar, you can quickly schedule meetings and events and create tasks, so you always know what’s next. Google Calendar is designed for teams, so it’s easy to share your schedule with others and create multiple calendars that you and your team can use together. In this course, you’ll learn how to create and manage Google Calendar events. You will learn how to update an existing event, delete and restore events, and search your calendar. You will understand when to apply different event types such as tasks and appointment schedules. You will explore the Google Calendar settings that are available for you to customize Google Calendar to suit your way of working. During the course you will learn how to create additional calendars, share your calendars with others, and access other calendars in your organization.
Gmail is Google’s cloud based email service that allows you to access your messages from any computer or device with just a web browser. In this course, you’ll learn how to compose, send and reply to messages. You will also explore some of the common actions that can be applied to a Gmail message, and learn how to organize your mail using Gmail labels. You will explore some common Gmail settings and features. For example, you will learn how to manage your own personal contacts and groups, customize your Gmail Inbox to suit your way of working, and create your own email signatures and templates. Google is famous for search. Gmail also includes powerful search and filtering. You will explore Gmail’s advanced search and learn how to filter messages automatically.