Data Analysis with Redash ( redash | 14 hours )

Prerequisites:
  • An understanding of data analytics and database concepts
  • Experience in SQL

Audience

  • Data scientists
  • Developers
Overview:

Redash is an open source business intelligence tool for creating data visualizations and interactive dashboards. It uses SQL to query and extract data from different database sources, such as Postgres, MySQL, MongoDB, Presto, Snowflake, etc.

This instructor-led, live training (online or onsite) is aimed at data scientists and developers who wish to use Redash to run SQL-based queries and visualize data from multiple sources.

By the end of this training, participants will be able to:

  • Set up and install Redash to start creating data visualizations and dashboards.
  • Connect Redash to different data sources such as Postgres, MongoDB, Databricks, etc.
  • Learn how to query and combine complex data from multiple database sources.
  • Write and execute SQL queries and build collaborative data visualizations and dashboards.
  • Use Redash's API endpoints to enable integrations with other web applications.

Format of the Course

  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.

Course Customization Options

  • To request a customized training for this course, please contact us to arrange.
Course Outline:

Introduction

  • Redash vs Metabase vs Superset
  • Overview of Redash features and advantages

Getting Started

  • Installing Redash
  • Supported data sources
  • Connecting to different data sources
  • Configuring users and groups

Querying Data

  • Creating, editing, and publishing queries
  • Running queries from QRDS
  • Adding query parameters
  • Scheduling queries
  • Using favorites and tagging
  • Downloading query results
  • Using query filters and snippets

Creating Visualizations and Dashboards

  • Adding, editing, and embedding visualizations
  • Setting up chart visualizations
  • Other visualization types
  • Combining visualizations in a dashboard
  • Managing dashboard permissions
  • Sharing and embedding dashboards

Setting Up Alerts

  • Creating an alert
  • Adding an alert destination
  • Customizing notification messages
  • Configuring multiple column alerts

Working with Integrations and APIs

  • Accessing APIs with Python
  • Connecting Redash to Zapier
  • Importing query results into Google Spreadsheets
  • Configuring an SSH tunnel using API

Best Practices and Troubleshooting

Summary and Next Steps

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