Book Image

Redash v5 Quick Start Guide

By : Alexander Leibzon, Yael Leibzon
Book Image

Redash v5 Quick Start Guide

By: Alexander Leibzon, Yael Leibzon

Overview of this book

Data exploration and visualization is vital to Business Intelligence, the backbone of almost every enterprise or organization. Redash is a querying and visualization tool developed to simplify how marketing and business development departments are exposed to data. If you want to learn to create interactive dashboards with Redash, explore different visualizations, and share the insights with your peers, then this is the ideal book for you. The book starts with essential Business Intelligence concepts that are at the heart of data visualizations. You will learn how to find your way round Redash and its rich array of data visualization options for building interactive dashboards. You will learn how to create data storytelling and share these with peers. You will see how to connect to different data sources to process complex data, and then visualize this data to reveal valuable insights. By the end of this book, you will be confident with the Redash dashboarding tool to provide insight and communicate data storytelling.
Table of Contents (10 chapters)

Creating your first query

Click on Create and select query from the drop-down menu. This will bring you to the query editor window, where the first thing you will have to select is the Data Source of the query (the Data Source selector is on the top-left-hand side of the window, right below QueryName, which in the case of creating a new query will be New Query). In this example, we will use one of the Data Sources we've just created (Redash Meatadata or quickstart_1):

After selecting the desired Data Source (in our case, Redash Metadata), we should see the schema (the available tables and their structure) on the left-hand side below the Data Source selector:

Not all the Data Sources have schemas available.
If you used a URL Data Source, you won't see the schema.

We can then start typing our query into the query editor window (the main section right in the middle of...