Building Impeccable Redash Dashboards: 4 Easy Steps

on BI Tool, ETL, Tutorials • November 8th, 2021 • Write for Hevo

Redash Dashboards - Featured Image

Dashboards have become increasingly popular with time. A Dashboard is a place where your data is gathered from multiple sources and portrayed in a meaningful way, which means that you can use a Dashboard for a quick peek into your business. Organizations mostly use Dashboards for monitoring real-time metrics and performance indicators. These metrics and indicators will assist you to quickly gain valuable insights and enable you to make data-driven decisions.

There are a lot of Dashboarding tools available in the market right now. The feature that makes Readash great is that it allows querying of data in SQL, unlike the other BI tools. So, Readash has a lot of users despite a lot of competition in the market. In this article, you will learn about Readash and its key features. You will also come across a step-by-step guide that will help you in building your Redash Dashboards.

Table Of Contents

Understanding Redash

Redash Dashboard: Diagram
Image Source: Websoft9 Support

Redash is a Business Intelligence Browser-based software founded in 2015 by Arik Fraimovich, an Israeli native. Redash was referred to as Re:dash and was developed with the purpose of making access to billions of records easier and quicker, hence, he came up with the idea to build a Query Editor that gets the job done. Re:dash was initially a side project for Arik which he built with passion and it is now an Open-source software that anyone can use. Redash is hosted on AWS as a part of a private network.

Redash Dashboards are easy to build and simple to understand. You can choose from a large range of visualizations and include them in your Dashboard. All in all, Redash will empower your organization towards a data-driven attitude which is quite crucial in this cutthroat competitive world. With the help of Readash Dashboards, you will have all the information about your business whenever you need it. Redash is quite popular among SQL users as they love querying their data.

Understanding the Key Features of Redash

Understanding the key features will help you in working with Redash. Some of its key features are:

1. Supports Multiple Data Sources

Redash supports a large number of Data Sources including the SQL and NoSQL out of which a few are mentioned here:

  • AWS Redshift
  • CSV files
  • JSON
  • Python 
  • MySQL
  • MongoDB
  • Cassandra
  • MS SQL
  • Oracle,etc.

You can refer to the Data Sources section in their official documentation. Redash Dashboards also have an extensible Data Source API with native support for a long list of common databases and platforms.

2. Query Editor

This powerful and unique feature allows you to write SQL and NoSQL queries (with an auto-complete feature) for your data in Redash Dashboard. You can query your data in the Query Editor using the native language of the Data Source. The Query Editor lets you browse through various tables which are displayed on the left side of your screen. It also houses an auto-query feature where you can schedule a query to run without any manual intervention.

Redash Dashboard: Query Editor
Image Source: Redash

3. Dashboards

Redash Dashboards feature Cohort Analysis (measures the change in a variable across two different times), Chart visualizations(Line, Bar, Area, Pie and Scatter Charts), Funnel visualizations (analyses every component in a flowing model), Pivot tables, Box plots, Maps, Sunburst, Sankey, etc. Redash Dashboards have attractive UX graphics and also enable you to format numbers in them. You can edit your Redash Dashboards, tag them, add to favorites and share them with your colleagues.

4. Collaboration

Redash Dashboard: Sharing Redash Dashboard
Image Source: Redash

Redash Dashboards let you collaborate easily with your peers or clients with a single click on a secret URL. While collaborating, you can share visualizations and their associated queries, enabling peer review of reports and queries. Collaboration is powerful because it leads to sharing of ideas and building a strong engagement in any organization. This collaboration feature will allow all the employees in your organization to be aware of real-time information which will enhance their decision-making efficiency.

5. Updates and Alerts

Redash Dashboard: Creating Alerts
Image Source: Redash

Redash Dashboards allow you to automate your Dashboard data and alert you when your attention is needed. With the help of the Automated Refresh feature, you can schedule refreshes to update your charts and dashboards at regular intervals. You can create alerts and define them. Once you create an alert, it will notify you when it satisfies the alert condition you defined. 

Simplify your Data Analysis with Hevo’s No-code Data Pipelines

Hevo, a No-code Data Pipeline helps to transfer your data from multiple sources (among 100+ sources) to the Data Warehouse/Destination of your choice to visualize it in your desired BI tool like Redash. Hevo is fully-managed and completely automates the process of not only loading data from your desired source but also takes care of transforming it into an analysis-ready form without having to write a single line of code. Its fault-tolerant architecture ensures that the data is handled in a secure, consistent manner with zero data loss.

Get Started with Hevo for Free

It provides a consistent & reliable solution to manage data in real-time and you always have analysis-ready data in your desired destination. It allows you to focus on key business needs and perform insightful analysis using a BI tool of your choice.

Check out Some of the Cool Features of Hevo:

  • Completely Automated: The Hevo platform can be set up in just a few minutes and requires minimal maintenance.
  • Real-Time Data Transfer: Hevo provides real-time data migration, so you can have analysis-ready data always.
  • 100% Complete & Accurate Data Transfer: Hevo’s robust infrastructure ensures reliable data transfer with zero data loss.
  • Scalable Infrastructure: Hevo has in-built integrations for 100+ sources that can help you scale your data infrastructure as required.
  • 24/7 Live Support: The Hevo team is available round the clock to extend exceptional support to you through chat, email, and support calls.
  • Schema Management: Hevo takes away the tedious task of schema management & automatically detects the schema of incoming data and maps it to the destination schema.
  • Live Monitoring: Hevo allows you to monitor the data flow so you can check where your data is at a particular point in time.
Sign up here for a 14-Day Free Trial!

Prerequisites

  • A Redash free trial account/ subscription.

Steps to Build Redash Dashboards

Let’s dive into the step-by-step guide to build a Redash Dashboard:

Step 1: Adding a Data Source

Firstly, you need to log into your Redash account. On the welcome page, click on the Settings icon present in the top-right corner of the screen to open the Data Sources Management page.

Redash Dashboard: Welcome page
Image Source: Redash

Now, you can choose your required Data Source that you want to work with:

Redash Dashboard: Adding Data Source
Image Source: Redash

You will also need to configure your Data Source by providing hostname, port, database name, user name, and password. After configuring click on the Create button to add the Data Source.

Redash Dashboard: Configuring Data Source
Image Source: Redash

Step 2: Writing Queries

With the help of queries you can bring in a sample of your data from the Data Source or you can leverage the entire dataset in the Data Source. Querying can also help you to make minor changes to your data before visualizing it. So to create a query, you need to click on the Create button present in the navigation bar at the top of your screen and choose Query to open your Query Editor.

Redash Dashboard: Creating Query
Image Source: Redash

Type a name for your query. On the left side of the screen, you can find a Schema browser where you can choose your Data Source and view all the tables present in it. You can then write your queries in the Query Editor. After you write your query, you can click on the execute button to view the results. You can keep executing your queries to achieve the required results and click on the Save button to save the query. Always remember that the output of your query execution is a table that will be further used in creating visualizations.

Redash Dashboard: Writing Queries in Query Editor
Image Source: Redash

Step 3: Creating Visualizations

In the previous step, you executed and saved a query. Now you need to click on “+ New Visualization button” to open the Visualization Editor.

Redash Dashboard: Configuring Visualizations
Image Source: Redash

In the Editor, configure the visualization and see the output of your configuration as soon you add a specification. For example, I want to create a bar plot. So I will go to chart type and choose bar plot. In the X column and Y column drop-down list, I will choose the tabular columns obtained from my previous query execution.

Redash Dashboard: COonfiguring Visualizations
Image Source: Redash

Now, you can also customize the colors and data labels for your Bar chart. Click on the Save button after you are satisfied with your output. You will then see the query editor window again. Now click on Publish to publish the visualization which will redirect you to the welcome page.

Redash Dashboard: Query Editor after adding visualization
Image Source: Redash

Step 4: Creating Dashboards

Redash Dashboards can contain multiple visualizations. With the help of Step 3, you can create multiple visualizations and add them to your Redash Dashboard. In your welcome screen click on Create and select Dashboard. A window pops up. Enter the Dashboard name in it and click on the Save button. Now, you will be redirected to the Dashboard Editor.

Now click on Add Widget at the bottom of the screen:

Redash Dashboard: Dashboard Editor
Image Source: Redash

Choose the visualization you need to add to your Redash Dashboard and click on the “Add to Dashboard” button.

Redash Dashboard: Configuring Widget
Image Source: Redash

Then click on the Done Editing button on the top right of the screen. These visualization nuggets added to the Dashboard. Now you can add more visualizations to your Redash Dashboard by following the same method.

Redash Dashboard: Widget added to Dashboard Editor
Image Source: Redash

 Once you are satisfied with your Redash Dashboard you can click on Publish button on the top right and share it with your colleagues.

Redash Dashboard: Publishing the Redash Dashboard
Image Source: Redash

Understanding the Limitation of Redash Dashboards 

Redash is predominantly a Browser-based software. It currently supports self-hosting in Linux Operating Systems. If you want to use Redash with other Operating Systems, you need to have a Virtual Machine container or a modern browser( Chrome and Mozilla Firefox are recommended). 

Conclusion

In this article, you learned about Redash, its features. You also learned to create Redash Dashboards. Since only a few Data Sources are supported by Redash, you can use Hevo to move all your data into a Data Warehouse supported by Redash.

Integrating and analyzing your data from a huge set of diverse sources can be challenging, this is where Hevo comes into the picture. Hevo is a No-code Data Pipeline and has awesome 100+ pre-built integrations that you can choose from.

Visit our Website to Explore Hevo

Hevo can help you integrate your data from numerous sources and load them into a destination to analyze real-time data with a BI tool like Redash and create your Dashboards. It will make your life easier and make data migration hassle-free. It is user-friendly, reliable, and secure. Check out the pricing details here. Wanna try Hevo? Sign Up for a 14-day free trial and see the difference!

No-code Data Pipeline for Redash