Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Redash v5 Quick Start Guide
Redash v5 Quick Start Guide

Redash v5 Quick Start Guide: Create and share interactive dashboards using Redash

eBook
zł59.99 zł106.99
Paperback
zł133.99
Subscription
Free Trial

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing
Table of content icon View table of contents Preview book icon Preview Book

Redash v5 Quick Start Guide

Introducing Redash

Nowadays, every business creates vast amounts of data. Whether it’s plain logs, usage statistics, or user data, businesses tend to store it.

But without proper analysis and usage, this data just occupies space (S3s, self-hosted Hadoop clusters, regular RDBMS, and so on) and resources (someone must maintain the servers; otherwise, the data is lost).

The ultimate goal is to try to make the data work for the benefit of the company.

Data analysis rapidly expands beyound the domain of enclosed research departments and penetrates almost every department along the company's verticals.

The trend is that data insights move from business-supporting to business-generating roles.

In this chapter, we will cover the following topics:

  • Data challenges experienced by companies on a daily basis
  • Ideal tools to target challenges
  • Meeting Redash
  • Redash architecture

Data challenges experienced by companies on a daily basis

Let's have a look at an abstract example of a social gaming company and it's use of data:

  • CEO/SVPs use generic knowledge of company revenues, pre-defined KPIs (new daily users/daily active users/churn rate)
  • The marketing/business development departments use conversion funnels/campaign traction/pre-defined KPIs/growth rate/revenues (usually also sliced by department/game type/geolocation).
  • The finance department uses various revenue breakdowns (by department/by external clients, and so on)
  • The sales department uses revenues by campaigns breakdown (for better campaign evaluation)
  • The product department uses statistics/growth rate/feature popularity/new daily users (to find out whether a specific feature attracts more users/revenue (with at least the same slicing as marketing)
  • Customer support/QA/developers deal with bug rates/user reviews/usage statistics
  • Data analytics/data scientists require data on usage statistics
  • IT/DBAs/operations/infrastructure need information regarding load statistics/uptime/response SLAs/disk usage/CPU/memory (and other various system stats)
  • External (contractors/clients/partners) require daily/weekly/monthly reports of various business metrics

As you can see, all the different departments rely on data and have their own specific data needs.

We can also note that if we treat each need as a building block, we can reuse them across departments.

But data is not only about numbers. People like to get a real feel, and that's where visualization can come in handy, especially when there is a need to discover trends or spot anomalies. Most of the time, it's much easier to track everything through charts and graphs, even if they represent an abstract trend.

Needless to say, each visualization forms a building block too.

All the preceding points can be joined by a dashboard (or, in most cases, dashboards), where every department has at least one of their own.

Moreover, good visualizations, which are tied together to make an understandable and meaningful user journey through the data (like dashboards), are almost mandatory for data-driven decision making (instead of decision making based on a gut feeling).

This data usage pattern is not unique to social gaming companies. In fact, you can easily define a starter pack of KPIs/metrics that are crucial to track the growth of any company.

An example dashboard

(image source: redash.io)

Suppose we want to provide our product department with a Redash usage dashboard (based on real Redash usage data), that consists of several metrics:

The preceding diagram is a Usage chart. Usage can be any form of interaction with Redash. This chart shows us the total amount of interactions with Redash per day over a 30-day period:

In the preceding chart, we can see that the different events have been broken down into types, which allows us to gain a better understanding of the main use cases of Redash:

Along with a further breakout of events by Country (gives us a distribution of events in different countries), using IP2Location transformation. In addition to this, there are the new signups and the total user count metrics.

Every single one of these metrics can tell us something valuable, but when combined with a single dashboard (as you can see in the following diagram), a metric can tell us a whole different kind of story (which we will cover in upcoming chapters):

Redash dashboard, themed queries, and visualizations combined

Ideal tools for targeting challenges

Based on the previous example, let’s summarize a set of features for an ideal tool that help the company as a whole make the most of its data:

  • Easy to use: Not everyone in every department is a rocket scientist, so we need the tool to be as simple as possible.
  • Easy to collaborate on: Since we have already defined the building blocks, it would be great if it can be used and, more importantly, re-used and extended.

It would be great if person A from marketing were to start to create a query and person B from sales were able to see it while it's being created, and then comment/modify and create a separate version of it.

The same goes for query visualizations and dashboards.

  • Shareable: Preferably online, as there is no need to force anyone to install extra tools on their laptop. It must be flexible in terms of what to share, since we might want to expose it to someone outside the company (contractors/clients/partners).
  • Should support a variety of Data Sources: Every department has its own Data Sources (the marketing department might have Oracle/MySQL/PostgreSQL, while the IT department might have InfluxDB/ElasticSearch, and so on), and it would be great to have a tool that connects to them all or, even better, a tool that can mix different Data Sources in the same dashboard.
  • Query scheduling/auto-refresh: We want the dashboards to be up to date every time we look at them.
  • Easily extendable: The data world changes rapidly; new Data Sources are being created, businesses demand new visualizations, new integrations pop up, and so on. We want to ensure that all of these factors are easily incorporated into our tool.
  • Alerts: It would be very handy to be able to define critical thresholds for KPIs or metrics and receive an email/slack alert/custom notification if this occurs.
  • API for external integrations: To fully unleash the power of company data, you can't skip the API part; every developer who has an idea of how to tailor the analytical tool to their own need must be provided with an easy way to do it. The same goes for integrations with external clients/partners who want to access the data programmatically—and what can be easier than the REST API?
  • Fast: In a rapidly changing world and businesses that grow quickly, speed is king. When we say speed, we mean both tool response time and tool-get-the-task-done time. What is the tool worth if it takes half an hour just to create and visualize a single KPI?

Meeting Redash

Back in 2013, a company named EverythingMe was facing all the preceding challenges and yearned for a tool that would have an ideal set of features and fit in with our well-established data-driven culture.

After trying several legacy BI suites, a decision was made to create an easier, more collaborative, and faster tool having JSFiddle as inspiration.

These conditions stimulated the creation of Redash to target those requirements.

Redash was created during a hackathon by Arik Fraimovich, who then became the founder and lead developer of Redash.

While initially built to allow rapidly querying and visualizing data from Amazon Redshift (hence the name Re:Dash = Redshift + Dashboard), Redash quickly grew to become the company’s main data analysis, visualization, and dashboarding tool, serving all of the departments in the company.

More Data Sources and visualization types were added, people started to contribute to the source code, and eventually Redash was released as an open source tool, and later developed into a separate independent company, with Redash as its main product. Its main goal was to help other companies to become more data-driven with little to no effort, just as we did back in the days at EverythingMe.

What exactly is Redash?

In this paragraph, we will go over the key features of Redash to understand its possibilities and how it can fit into various departments within the company:

  • Redash is an open source tool that is used to create, visualize, and share queries and dashboards.
  • It works in the browser, so there's no need to install anything on a user’s computer: just click the link and log in.
  • It's easy to set up and can provide any team member with the immediate power to analyze data.
  • Redash is very easy and intuitive to use.

Even if a team member is not familiar with SQL syntax, they can utilize query parameters that they can easily modify to get the desired results, alternatively they can easily Fork (Duplicate—exactly as you would in GitHub), an existing query/visualization, and modify it according to their needs.

Both the query parameters and Forking work best as a quick intro into the Redash world.

  • Redash allows you to share and embed queries/visualizations/dashboards, which is as easy as sending a URL.
  • Redash supports many Data Sources. Whether it's RDBMS, BigData NoSQL, or REST API, you’ve got them all (a full list and further details are available in Chapter 4, Connecting to Data Sources). You can even define a query result as a separate datasource and use it later in other queries.
  • There are a handful of various visualizations, so everyone in the company will find one that suits their mission best.
  • Visualizations can be exported as PNGs, PDFs, and so on.
  • Data can be exported as CSV/JSON and Excel.
  • Redash includes query scheduling and an auto refresh mechanism.
  • Redash provides you with an alerting mechanism, where you can define alerts (for example, if the new daily user numbers are below a certain threshold), and then get notifications about it via email/chat/a custom defined webhook.
  • Redash provides live auto complete in the query editor and keyboard shortcuts.
  • Automatic schema discovery for all Data Sources.
  • Results are cached for minimal running times and rapid response. Results from the same query are reused; there is no resource wasting and needless query execution!
  • There's SSO, access control, and many other great features for enterprise-friendly workflows, in regard to user management.
  • Regarding the API, Redash provides a REST API that allows you to access all of its features programmatically, as well as pass dynamic parameters to queries. This can be used to extend functionality and tailor it to your own department's specific needs.

One example of this concerns data export for external clients, such as sending an automatic daily revenue report. Another great example of API usage is slack chatbot integration, which allows you to easily bring data into team conversations. A proper example of self-service is where any team member can fetch data insights from within a chat window, no coding is required, and there is no need to open tickets to the BI team: just type your request inside the chat and get the results!

  • In addition to the API, Redash is open source, which means that you can extend any part you want (this will be covered in Chapter 8, Customizing Redash).

What if you need a different visualization type? You got it! You need a new datasource? This is a piece of cake. You need a new alert or a new API call? Everything is at your fingertips.

  • With over 200 contributors and over 10,000 stars on GitHub, Redash has got a strong and vibrant community, and the project constantly evolves.

In summary, Redash improves—and makes more transparent to peers —a company's decision-making process, based on an easy and speedy creation of deep-dive dashboards over a company's Data Sources.

This speed comes from several aspects:

  • There's no entry level barrier, as literally every team member can log in to Redash and start getting insights.
  • There are suitable solutions across all the verticals and departments within the company, which eliminates the need to wait for other departments to get the data ready. This is tailored to your needs.
  • Self-service is king, as you can fork the queries and modify them as required. You are in full control of your data and visualizations.
  • You can query all the possible Data Sources from a single place, and join multiple Data Sources into a single dashboard.
  • You can create crucial business alerts to keep you posted as they happen.
  • Results are cached for faster retrieving and avoid the generation of useless loads on your Data Sources.
  • Instant sharing! Just send the link and you're set.

Redash has two options that you can use: hosted (with monthly subscription plans) or self-hosted Open Source version (free, and you get to maintain it yourself).

The hosted version is suitable for companies who don't want the hassle of hosting and managing the Redash service (and the surrounding components such as Redis/PostgreSQL/Celery) by themselves (usually, this requires at least one or two dedicated employees, and not everyone has them available immediately).

The self-hosted version suits you best when you have the necessary resources (both machine and human) and:

  • You want to extend Redash to your own specific needs
  • You want to contribute to the open source community
  • You want full control over your own data

The hosted and self-hosted versions are identical, and you can always switch back and forth.

It is recommended, however, to try the self-hosted Redash in development mode at the very least, as this way you can gain a better understanding of the internals of the tool that is about to change your company's data culture!

This book will cover only the self-hosted version of Redash (v5), all the covered themes are identical to the hosted version of Redash. Most of the themes are fully backwards compatible to versions older than v5, please refer to Redash official website to check the difference.

Redash architecture

Redash is a single-page web app, with JS frontend and backend.

Originally having the frontend written in AngularJS, since V5, it's in transition to React:

Redash itself is written in Python.

The UI (frontend) is AngularJS, which is responsible for all the visualizations, dashboards, and the query editor. The regular user interacts with this the most.

The server (backend) is a Flask App, which uses the Celery Distributed Task Queue as its task worker engine (Celery workers are responsible for query execution).

The server handles the actual query execution requests on various Data Sources, such as dashboard refresh requests, both from the frontend and from API calls (for example, slack bots, advanced user's webhooks, and so on).

The PostgreSQL database is used to store all the necessary application metadata and configurations (users/groups/datasource definitions/queries/dashboards).

Redis in the memory datastore serves as both the Celery Message Broker (Celery requires a message broker service to send and receive messages).

Summary

In this chapter, we've covered the challenges that every data-driven business should expect to come across, and how Redash comes in handy to target those challenges and help shorten the time between questions and answers by allowing the user to query all of their Data Sources from a single place, without moving the data anywhere.

Redash allows you to combine queries and visualizations from different Data Sources in a single dashboard to provide the business department with the most comprehensive overview possible.

In the sections that followed, we went over the main features of Redash, as well as its architecture in brief. In the next chapter, we will cover the installation options and a step-by-step guide to Redash.

If you're planning to use Redash as a hosted service, or if the installation of the software will be undertaken by another department, you can skip the next chapter.

Left arrow icon Right arrow icon
Download code icon Download Code

Key benefits

  • Learn the best use of visualizations to build powerful interactive dashboards
  • Create and share visualizations and data in your organization
  • Work with different complexities of data from different data sources

Description

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.

Who is this book for?

This book is intended for Data Analysts, BI professionals and Data Developers, but can be useful to anyone who has a basic knowledge of SQL and a creative mind. Familiarity with basic BI concepts will be helpful, but no knowledge of Redash is required.

What you will learn

  • Install Redash and troubleshoot installation errors
  • Manage user roles and permissions
  • Fetch data from various data sources
  • Visualize and present data with Redash
  • Create active alerts based on your data
  • Understand Redash administration and customization
  • Export, share and recount stories with Redash visualizations
  • Interact programmatically with Redash through the Redash API

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Sep 29, 2018
Length: 224 pages
Edition : 1st
Language : English
ISBN-13 : 9781788996167
Category :
Tools :

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing

Product Details

Publication date : Sep 29, 2018
Length: 224 pages
Edition : 1st
Language : English
ISBN-13 : 9781788996167
Category :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just zł20 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just zł20 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total 465.97
Redash v5 Quick Start Guide
zł133.99
Django 2 Web Development Cookbook
zł197.99
Apache Superset Quick Start Guide
zł133.99
Total 465.97 Stars icon

Table of Contents

9 Chapters
Introducing Redash Chevron down icon Chevron up icon
Installing Redash Chevron down icon Chevron up icon
Creating and Visualizing your First Query Chevron down icon Chevron up icon
Connecting to Data Sources Chevron down icon Chevron up icon
Writing and Executing Queries Chevron down icon Chevron up icon
Creating Visualizations Chevron down icon Chevron up icon
Dashboards and Practical Tips Chevron down icon Chevron up icon
Customizing Redash Chevron down icon Chevron up icon
Other Books You May Enjoy Chevron down icon Chevron up icon

Customer reviews

Rating distribution
Full star icon Full star icon Full star icon Full star icon Full star icon 5
(2 Ratings)
5 star 100%
4 star 0%
3 star 0%
2 star 0%
1 star 0%
Amazon Customer Jun 23, 2019
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This book is pretty comprehensive, from basic topics to more advanced ones.Taking you step by step through installing, configuring and running a server, up to creating useful dashboard using various data sources, this book is all you need to get working with Re:dash.Given examples are very well described.Highly recommended!
Amazon Verified review Amazon
amitg Jan 15, 2019
Full star icon Full star icon Full star icon Full star icon Full star icon 5
lots of well described examples. Recommended!
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is included in a Packt subscription? Chevron down icon Chevron up icon

A subscription provides you with full access to view all Packt and licnesed content online, this includes exclusive access to Early Access titles. Depending on the tier chosen you can also earn credits and discounts to use for owning content

How can I cancel my subscription? Chevron down icon Chevron up icon

To cancel your subscription with us simply go to the account page - found in the top right of the page or at https://subscription.packtpub.com/my-account/subscription - From here you will see the ‘cancel subscription’ button in the grey box with your subscription information in.

What are credits? Chevron down icon Chevron up icon

Credits can be earned from reading 40 section of any title within the payment cycle - a month starting from the day of subscription payment. You also earn a Credit every month if you subscribe to our annual or 18 month plans. Credits can be used to buy books DRM free, the same way that you would pay for a book. Your credits can be found in the subscription homepage - subscription.packtpub.com - clicking on ‘the my’ library dropdown and selecting ‘credits’.

What happens if an Early Access Course is cancelled? Chevron down icon Chevron up icon

Projects are rarely cancelled, but sometimes it's unavoidable. If an Early Access course is cancelled or excessively delayed, you can exchange your purchase for another course. For further details, please contact us here.

Where can I send feedback about an Early Access title? Chevron down icon Chevron up icon

If you have any feedback about the product you're reading, or Early Access in general, then please fill out a contact form here and we'll make sure the feedback gets to the right team. 

Can I download the code files for Early Access titles? Chevron down icon Chevron up icon

We try to ensure that all books in Early Access have code available to use, download, and fork on GitHub. This helps us be more agile in the development of the book, and helps keep the often changing code base of new versions and new technologies as up to date as possible. Unfortunately, however, there will be rare cases when it is not possible for us to have downloadable code samples available until publication.

When we publish the book, the code files will also be available to download from the Packt website.

How accurate is the publication date? Chevron down icon Chevron up icon

The publication date is as accurate as we can be at any point in the project. Unfortunately, delays can happen. Often those delays are out of our control, such as changes to the technology code base or delays in the tech release. We do our best to give you an accurate estimate of the publication date at any given time, and as more chapters are delivered, the more accurate the delivery date will become.

How will I know when new chapters are ready? Chevron down icon Chevron up icon

We'll let you know every time there has been an update to a course that you've bought in Early Access. You'll get an email to let you know there has been a new chapter, or a change to a previous chapter. The new chapters are automatically added to your account, so you can also check back there any time you're ready and download or read them online.

I am a Packt subscriber, do I get Early Access? Chevron down icon Chevron up icon

Yes, all Early Access content is fully available through your subscription. You will need to have a paid for or active trial subscription in order to access all titles.

How is Early Access delivered? Chevron down icon Chevron up icon

Early Access is currently only available as a PDF or through our online reader. As we make changes or add new chapters, the files in your Packt account will be updated so you can download them again or view them online immediately.

How do I buy Early Access content? Chevron down icon Chevron up icon

Early Access is a way of us getting our content to you quicker, but the method of buying the Early Access course is still the same. Just find the course you want to buy, go through the check-out steps, and you’ll get a confirmation email from us with information and a link to the relevant Early Access courses.

What is Early Access? Chevron down icon Chevron up icon

Keeping up to date with the latest technology is difficult; new versions, new frameworks, new techniques. This feature gives you a head-start to our content, as it's being created. With Early Access you'll receive each chapter as it's written, and get regular updates throughout the product's development, as well as the final course as soon as it's ready.We created Early Access as a means of giving you the information you need, as soon as it's available. As we go through the process of developing a course, 99% of it can be ready but we can't publish until that last 1% falls in to place. Early Access helps to unlock the potential of our content early, to help you start your learning when you need it most. You not only get access to every chapter as it's delivered, edited, and updated, but you'll also get the finalized, DRM-free product to download in any format you want when it's published. As a member of Packt, you'll also be eligible for our exclusive offers, including a free course every day, and discounts on new and popular titles.