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