|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analysis-using-domo/
课程评论：没有评论
课程名称：使用Domo进行数据分析 概述：本课程旨在为希望获得Domo认证考试的学生和专业人士教授Domo的使用。课程涵盖多样的目标，涉及以下主题：基础SQL函数，包括聚合函数、数学函数及处理空值的函数；用于数据清洗和处理的字符串和日期函数；不同类型的SQL连接，如左连接、右连接和内连接；窗口函数，如排名、密集排名、行号及其他实用函数；通过Domo连接各种数据源，如云数据库、文件、谷歌表格和邮箱；使用SQL和ETL进行数据转换和清洗，包括在Domo中进行数据混合；创建卡片和仪表板，利用Domo中各种类型的图表及其应用；在数据流上创建警报，允许在Domo的管理员设置中输入的主要邮箱地址接收通知；通过创建授权策略来个性化数据权限；在Domo中安排报告；遵循Domo中的最佳实践。 通过覆盖这些目标，学生将能够实际掌握使用Domo的技能，包括连接不同数据源、使用SQL和ETL进行数据清洗和转换、以仪表板和卡片的形式创建可视化内容、创建个性化的数据权限和警报，同时学习如何安排报告并遵循Domo的最佳实践，以最大限度地发挥其潜力。
This course is focused on teaching Domo to students and professionals who aim to attain the Domo certification exam. The objectives covered in the course are diverse and encompass a range of topics, including:Basic SQL functions such as aggregate functions, mathematical functions, and functions to handle null values.String and date functions that can be used for data cleaning and manipulation.Different types of SQL joins like left, right and inner joins.Window functions like rank, dense rank, row number, and other useful functions.Connecting various data sources with Domo like cloud databases, files, Google sheets, and email.Transforming and cleaning data using SQL and ETL, including data blending in Domo.Creating cards and dashboards, utilizing various types of charts available in Domo and their applications.Creating alerts on data flow, allowing for notifications to be sent via email to the primary email address as entered in the Admin Settings in Domo.Personalizing data permissions through the creation of Entitlement Policies.Scheduling reports in Domo.Following best practices in Domo.By covering these objectives, the students will gain a practical understanding of working with Domo, including connecting various data sources, cleaning and transforming data using SQL and ETL, creating visualizations in the form of dashboards and cards, and creating personalized data permissions and alerts. They will also learn how to schedule reports and follow best practices in Domo to maximize its potential.
