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)

Sizing – choosing the right machine to do the job

Sizing is based on the number of concurrent users and the number of concurrent queries that you have. For <10 concurrent users and <100 active queries, a tiny machine that has a dual core, 2 GB memory should be enough.

On the other hand, if you have 50-100 concurrent users and 1,000 active queries, you will need at least 16-32 GB RAM and a quad-core CPU.

In addition to the Redash app, you will also need Postgres, Redis, and Celery.
  • Redis - Memory intensive
  • Postgres - CPU and memory
  • Celery - CPU and memory (the more workers you have, the more CPU you need. If workers won't keep up and build up a queue, it starts to consume memory)

If you're hosted in the cloud, you can always start with a smaller machine and expand if needed. The same goes for deploying Redash inside a VM in your own data center.

As a good...