Data Analysis with Redash ( redash | 14 hours )

Prerequisites:
  • 了解数据分析和资料库概念
  • 经验 SQL

观众

  • 数据科学家
  • 开发人员
Overview:

Redash 是一种开源商业智慧工具,用于创建数据可视化和互动式仪表板。它使用 SQL 来查询和提取来自不同资料库源的数据,例如 Postgres、MySQL、MongoDB、Presto、Snowflake 等。

这种由讲师指导的即时培训(在线或现场)面向希望使用 Redash 运行基于 SQL 的查询并可视化来自多个来源的数据科学家和开发人员。

在本次培训结束时,参与者将能够:

  • 设置并安装 Redash 以开始创建资料可视化和仪表板。
  • 将 Redash 连接到不同的数据源,例如 Postgres、MongoDB、Databricks 等。
  • 了解如何查询和组合来自多个资料库源的复杂数据。
  • 编写和执行 SQL 查询,并构建协作数据可视化和仪表板。
  • 使用 Redash 的 API 端点启用与其他 Web 应用程式的整合。

课程形式

  • 互动讲座和讨论。
  • 大量的练习和练习。
  • 在即时实验室环境中动手实施。

课程自定义选项

  • 要申请本课程的定制培训,请联系我们进行安排。
Course Outline:

介绍

  • Redash vs Metabase vs Superset
  • Redash 特性和优势概述

开始

  • 安装 Redash
  • 支持的数据源
  • 连接到不同的数据源
  • 配置使用者和组

查询数据

  • 创建、编辑和发布查询
  • 从 QRDS 运行查询
  • 添加查询参数
  • 计划查询
  • 使用我的最爱和标记
  • 下载查询结果
  • 使用查询筛选条件和代码段

创建可视化和仪表板

  • 添加、编辑和嵌入可视化
  • 设置图表视觉化效果
  • 其他可视化类型
  • 在仪表板中组合可视化
  • 管理控制面板许可权
  • 共用和嵌入仪表板

设置警报

  • 创建警报
  • 添加警报目标
  • 自订通知消息
  • 配置多列警报

使用整合和 API

  • Access使用 Python 建立 API
  • 连接 Redash 到 Zapier
  • 将查询结果导入 Google 电子表格
  • 使用 API 配置 SSH 隧道

最佳实践和故障排除

总结和后续步骤

Sites Published:

United Arab Emirates - Data Analysis with Redash

Qatar - Data Analysis with Redash

Egypt - Data Analysis with Redash

Saudi Arabia - Data Analysis with Redash

South Africa - Data Analysis with Redash

Brasil - Data Analysis with Redash

Canada - Data Analysis with Redash

中国 - Data Analysis with Redash

香港 - Data Analysis with Redash

澳門 - Data Analysis with Redash

台灣 - Data Analysis with Redash

USA - Data Analysis with Redash

Österreich - Data Analysis with Redash

Schweiz - Data Analysis with Redash

Deutschland - Data Analysis with Redash

Czech Republic - Data Analysis with Redash

Denmark - Data Analysis with Redash

Estonia - Data Analysis with Redash

Finland - Data Analysis with Redash

Greece - Data Analysis with Redash

Magyarország - Data Analysis with Redash

Ireland - Data Analysis with Redash

Luxembourg - Data Analysis with Redash

Latvia - Data Analysis with Redash

España - Data Analysis with Redash

Italia - Data Analysis with Redash

Lithuania - Data Analysis with Redash

Nederland - Data Analysis with Redash

Norway - Data Analysis with Redash

Portugal - Data Analysis with Redash

România - Data Analysis with Redash

Sverige - Data Analysis with Redash

Türkiye - Data Analysis with Redash

Malta - Data Analysis with Redash

Belgique - Data Analysis with Redash

France - Data Analysis with Redash

日本 - Data Analysis with Redash

Australia - Data Analysis with Redash

Malaysia - Data Analysis with Redash

New Zealand - Data Analysis with Redash

Philippines - Data Analysis with Redash

Singapore - Data Analysis with Redash

Thailand - Data Analysis with Redash

Vietnam - Data Analysis with Redash

India - Data Analysis with Redash

Argentina - Data Analysis with Redash

Chile - Data Analysis with Redash

Costa Rica - Data Analysis with Redash

Ecuador - Data Analysis with Redash

Guatemala - Data Analysis with Redash

Colombia - Data Analysis with Redash

México - Data Analysis with Redash

Panama - Data Analysis with Redash

Peru - Data Analysis with Redash

Uruguay - Data Analysis with Redash

Venezuela - Data Analysis with Redash

Polska - Data Analysis with Redash

United Kingdom - Data Analysis with Redash

South Korea - Data Analysis with Redash

Pakistan - Data Analysis with Redash

Sri Lanka - Data Analysis with Redash

Bulgaria - Data Analysis with Redash

Bolivia - Data Analysis with Redash

Indonesia - Data Analysis with Redash

Kazakhstan - Data Analysis with Redash

Moldova - Data Analysis with Redash

Morocco - Data Analysis with Redash

Tunisia - Data Analysis with Redash

Kuwait - Data Analysis with Redash

Oman - Data Analysis with Redash

Slovakia - Data Analysis with Redash

Kenya - Data Analysis with Redash

Nigeria - Data Analysis with Redash

Botswana - Data Analysis with Redash

Slovenia - Data Analysis with Redash

Croatia - Data Analysis with Redash

Serbia - Data Analysis with Redash

Bhutan - Data Analysis with Redash

Nepal - Data Analysis with Redash