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 and testing the Data Source

First, we need to define a Data Source. A Data Source is a place where our data resides; it can be an RDBMS (such as MySQL or Postgres), a comma-separated text file, a document store, and so on (these features will be covered in Chapter 4, Connecting to Data Sources).

For this chapter, we will be using Redash's internal PostgreSQL (the same example will work as is for any SQL queriable Data Source), to be able to execute parts of this specific example, you must have the dockerized PostgreSQL server set up.

In case you don't have any Data Source set up yet, but you still wish to explore Redash and continue through this chapter, skip the PostgreSQL definition, and move to Alternative Static Data Source Definition right after it.

To validate that your dockerized PostgreSQL is up and running execute the following command:

docker ps

...