Aliaksei Kuzniatsou
회원 가입일: 2023
다이아몬드 리그
34520포인트
회원 가입일: 2023
중급 Looker에서 데이터 모델 관리하기 기술 배지 과정을 완료하여 다음 기술을 입증하세요. LookML 프로젝트 상태 유지하기, 데이터 검증을 위한 SQL Runner 활용하기, LookML 권장사항 적용하기, 성능을 위한 쿼리 및 보고 최적화하기, 영구 파생 테이블 및 캐싱 정책 구현하기
초급 Looker에서 LookML 객체 빌드 기술 배지 과정을 완료하여 새로운 측정기준 및 측정값, 뷰, 파생 테이블을 빌드하고, 요구사항에 따라 측정 필터 및 유형을 설정하고, 측정기준과 측정값을 업데이트하고, Explore를 빌드 및 미세 조정하고, 기존 Explore에 뷰를 조인하고, 비즈니스 요구사항에 따라 생성할 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에서 ML API용으로 데이터 준비하기 기술 배지를 완료하여 Dataprep by Trifacta로 데이터 정리, Dataflow에서 데이터 파이프라인 실행, Dataproc에서 클러스터 생성 및 Apache Spark 작업 실행, Cloud Natural Language API, Google Cloud Speech-to-Text API, Video Intelligence API를 포함한 ML API 호출과 관련된 기술 역량을 입증하세요.
초급 Looker 대시보드 및 보고서를 위해 데이터 준비하기 기술 배지 과정을 완료하면 데이터를 필터링, 정렬, 피벗팅하고, 다른 Looker Explore의 결과를 병합하고, 함수 및 연산자를 사용해 데이터 분석 및 시각화를 위한 Looker 대시보드 및 보고서를 빌드하는 기술 역량을 입증할 수 있습니다.
이 과정에서는 Looker에서 고급 LookML 개념을 적용하는 실무를 직접 경험해 봅니다. Liquid를 사용하여 동적 측정기준과 측정항목을 맞춤설정 및 생성하고 동적 SQL 파생 테이블 및 맞춤설정된 기본 파생 테이블을 만들고 확장을 사용하여 LookML 코드를 모듈화하는 방법을 알아봅니다.
중급 BigQuery ML로 ML 모델 만들기 기술 배지 과정을 완료하면 BigQuery ML로 머신러닝 모델을 만들고 평가하여 데이터 예측을 수행하는 기술 역량을 입증할 수 있습니다.
초급 BigQuery 데이터에서 인사이트 도출 기술 배지 과정을 완료하여 SQL 쿼리 작성, 공개 테이블 쿼리, BigQuery로 샘플 데이터 로드, BigQuery의 쿼리 검사기를 통한 일반적인 문법 오류 문제 해결, BigQuery 데이터를 연결해 Looker Studio에서 보고서를 생성하는 작업과 관련된 기술 역량을 입증하세요.
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 Sheets에서 함수, 수식, 차트 사용하기 기술 배지 과정을 완료하여 함수로 데이터 분석하는 방법, 차트를 사용한 데이터 시각화 방법, 데이터를 검증, 형식 지정, 표시하는 방법에 대한 기술 역량을 입증하세요.
클라우드 협업 및 생산성 워크플로 구현 과정을 완료하고 초급 기술 배지를 획득하세요. 이 과정에서는 Google의 협업 플랫폼에 대해 소개하고, Gmail, Calendar, Meet, Drive, Sheets, 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.