Today's Deep-Dive: Redash
Ep. 134

Today's Deep-Dive: Redash

Episode description

The Deep Dive explores Redash, a powerful tool designed to help businesses understand their data without needing extensive technical skills. It connects to various data sources, allowing users to transform raw data into easy-to-understand visuals such as charts and graphs. Redash is browser-based, making it accessible without complicated installations, and it emphasizes user-friendliness, enabling quick insights without extensive training. Users can create custom visualizations using SQL or benefit from dashboards created by data experts. Key features include automatic data refreshes, alerts for important changes, and broad compatibility with over 35 data sources, including popular platforms like Google Sheets and MySQL. Redash’s open-source nature allows for customization and continuous improvement by a strong community of developers. Overall, it democratizes data access, empowering everyone in an organization to participate in data-driven decision-making. By making complex data understandable, Redash helps businesses move from guessing to making informed decisions based on actual facts. The discussion highlights the potential for improved understanding and enhanced decision-making through easy access to key data.

Download transcript (.srt)
0:00

All right, so you know why you're here, right?

0:01

You wanna learn something and you wanna learn it fast.

0:03

That's kind of our whole thing here on the Deep Dive.

0:05

Get to the core of it all without all that extra fluff.

0:07

Absolutely, yeah, cut right to the chase, right.

0:10

And today we're diving into something that's,

0:13

well, it's becoming kinda essential for businesses

0:16

that really wanna understand what their data is telling them.

0:19

Makes sense.

0:20

But first, a huge thanks to Safe Server

0:22

for supporting this Deep Dive.

0:24

If you're looking for top-notch hosting solutions

0:26

or need some expert advice on digital transformation,

0:29

you gotta check them out at www.safeserver.dd.

0:34

Now, getting into it today, we're talking Redash.

0:39

Redash, okay.

0:40

Yeah, and you might've heard this term thrown around,

0:42

like data-driven, but honestly, the idea is pretty simple

0:46

and it's super powerful.

0:47

Okay, I'm intrigued.

0:49

I'll admit, though, for someone like me

0:50

who isn't exactly a coding whiz,

0:54

the thought of dealing with all that company data

0:56

can be kinda scary.

0:57

I get it.

0:58

This Redash thing is supposed to make it easy.

1:00

It's designed to take away that fear factor.

1:02

Think of it like a translator,

1:04

something that helps anyone understand

1:06

what their company data is actually saying.

1:08

So basically today, we're gonna break down

1:10

what Redash is all about and why it can be

1:13

a total game changer when it comes to understanding

1:15

what's going on in your business.

1:17

All right, I'm ready to have my data translated.

1:19

Let's start with the basics.

1:20

What is Redash exactly?

1:22

Okay, so in the simplest terms,

1:23

it's a tool that helps companies make smarter decisions

1:26

by actually looking at their data.

1:29

And like I said, data-driven might sound

1:31

like a fancy buzzword, but really,

1:32

it just means using actual facts and figures

1:34

to make choices instead of just winging it.

1:37

Makes sense.

1:38

So how does Redash take all this data

1:40

and turn it into something useful?

1:42

Well, its main job is to connect

1:44

to all those different places

1:45

where companies keep their information,

1:47

like customer databases, sales, spreadsheets,

1:52

website analytics, you name it, all kinds of sources.

1:54

And once it's connected, it lets you take all that raw data

1:58

and turn it into easy to understand visuals,

2:00

you know, charts and graphs.

2:02

Then you can put all these visuals together

2:04

on a single page, which is called a dashboard,

2:06

and it gives you like a snapshot

2:07

of all the most important information.

2:09

And the best part, you can share these dashboards

2:12

with your entire team super easily.

2:15

That sounds way less intimidating

2:16

than trying to make sense of a giant spreadsheet.

2:19

You mentioned earlier that Redash is for anyone,

2:23

regardless of how tech savvy they are.

2:25

How does it do that?

2:26

That's what's so cool about it.

2:27

So if you know SQL, which is basically a special language

2:31

for asking questions to databases,

2:33

you can use Redash to really dig deep,

2:36

explore, and create your own custom visualizations.

2:39

But even if you don't know SQL,

2:42

you can still get a lot of value from the dashboards

2:45

and reports that other people create.

2:47

It's like having someone who's fluent in data

2:50

translate everything for everyone else in the company.

2:53

I like that analogy.

2:54

So the data experts can use their skills

2:56

to create insights that everyone can understand.

2:59

That's a great way to bridge that gap.

3:01

And it's pretty impressive that you said

3:03

millions of users at thousands of organizations

3:06

are using it every day.

3:07

It shows you how widely it's being used.

3:09

Absolutely.

3:10

It's a tool that's actively helping

3:11

all kinds of businesses make better decisions.

3:14

So why don't we break down some of the key features

3:16

of Redash and explain them simply.

3:19

Let's do it.

3:19

What's the first thing we need to know?

3:21

First off, Redash is browser-based.

3:23

So you access everything through a web browser,

3:25

just like checking your email or browsing a website.

3:28

OK.

3:29

No complicated software to install.

3:31

Gotcha.

3:32

And you can share links to your charts and dashboards

3:34

with colleagues, just like you'd share any other web link.

3:37

So it's super accessible.

3:38

You just need to be online.

3:39

That definitely takes away a big barrier to entry.

3:42

What else makes it so user-friendly?

3:45

Well, another key aspect is its ease of use.

3:48

The whole point is to let you start getting value

3:51

from your data as quickly as possible

3:53

without needing tons of training.

3:55

I appreciate that.

3:56

It goes back to what you were saying about wanting

3:58

to learn things efficiently.

3:59

You spend less time learning the tool

4:02

and more time actually understanding your business.

4:04

Exactly.

4:05

There's nothing worse than a tool

4:06

that feels like you need a PhD just to use it.

4:09

Right.

4:10

So then you have the Query Editor.

4:11

And for those who are comfortable with it,

4:13

this is where you can write those questions or queries

4:16

in languages like SQL or NoSQL to get super specific

4:20

information from your data.

4:21

OK.

4:22

But Redash makes this easier too with things

4:23

like a schema browser, which is basically

4:25

like a table of contents for your data

4:27

showing you what information is available and autocomplete,

4:31

which helps you write those queries faster

4:33

and with fewer mistakes.

4:35

So for the more technical folks, it

4:36

gives them powerful ways to get exactly the data they need.

4:39

Exactly.

4:40

And once you have that data, Redash

4:42

makes it super easy to turn it into visuals

4:45

with its visualization and dashboards features.

4:48

You can create different types of charts and graphs,

4:50

often just by dragging and dropping.

4:52

Then you can arrange these visuals

4:54

onto a single dashboard page to get a clear overall picture.

4:58

And people even say that these visualizations

4:59

can be quite appealing.

5:01

It makes the data much easier to digest at a glance.

5:04

Beautiful data.

5:05

I like that.

5:06

And having everything organized on a dashboard

5:08

sounds like a huge time saver.

5:10

It is.

5:11

And then there's the sharing feature,

5:13

which makes collaboration super easy.

5:15

You can share your visualizations

5:17

and even the underlying data queries with your teammates.

5:19

Oh, nice.

5:20

So everyone can review, discuss, and build

5:23

upon each other's work.

5:24

It creates a much more collaborative approach

5:26

to understanding data.

5:28

Teamwork makes the dream work right.

5:31

Yeah.

5:31

Even when it comes to data.

5:34

What other helpful features does Redash offer?

5:37

Well, there's also schedule refreshes,

5:39

which means you can set your charts and dashboards

5:41

to automatically update at specific times

5:44

with the latest information.

5:45

That was handy.

5:46

So you're always looking at the most current data

5:48

without having to lift a finger.

5:50

That's going to be super important for businesses that

5:52

move quickly where things are constantly changing.

5:54

Absolutely.

5:56

And to help you stay on top of those important changes,

5:58

Redash has alerts.

6:00

You can set up rules that will trigger notifications

6:03

when certain things happen in your data.

6:05

Like, for example, you could get an alert if sales drop

6:07

below a certain level so you can react quickly.

6:10

That's a great way to stay ahead of the curve

6:11

and catch potential problems early on.

6:13

Now for the more advanced users who

6:15

want to take things even further, there's the REST API.

6:19

Think of this as a way for Redash to talk to other software

6:22

automatically.

6:23

Interesting.

6:24

It lets you integrate Redash with other tools

6:26

your company uses so you can streamline workflows

6:28

and automate tasks.

6:30

For example, you could automatically

6:32

pull data from Redash into a marketing report.

6:34

So we can connect with all those other important business

6:36

systems seamlessly.

6:38

That's a big plus for efficiency.

6:39

Definitely.

6:41

And finally, one of Redash's biggest strengths

6:43

is its broad data source support.

6:45

It can connect to a huge range of databases and platforms.

6:49

We're talking over 35 SQL and NoSQL data sources.

6:53

And it's built to be flexible enough to handle even more.

6:55

You'll recognize names like Google Sheets, MySQL,

6:58

and PostgreSQL as just a few examples of what

7:01

Redash can pull data from.

7:03

Wow, that's a lot of options.

7:04

So basically, no matter where a company keeps its data,

7:07

Redash can probably access it.

7:09

You've got it.

7:10

Now let's bring all this back to our listeners,

7:12

who you know are all about gaining knowledge quickly.

7:15

How can someone like them benefit from all these features?

7:18

Well, the ease of use is a big one for sure.

7:21

It means you can spend less time figuring out

7:23

complicated software and more time focusing on the insights

7:26

that really matter.

7:28

And those visual dashboards, they

7:29

take all that complex data and make

7:32

it clear and easy to understand so you can quickly

7:34

grasp the main points without feeling overwhelmed

7:37

by numbers.

7:38

Exactly.

7:39

And even if you're not the one writing complex code,

7:41

the fact that data experts can create and share

7:44

those user-friendly dashboards means everyone

7:47

can access valuable information.

7:49

It really levels the playing field

7:50

and lets more people participate in data-driven discussions

7:53

and decisions.

7:54

You don't need to be a data scientist

7:55

to understand what your data is telling you.

7:57

I think that's a really important point.

7:59

It makes data accessible to everyone in the organization.

8:01

One more thing to mention is that Redash is a popular open

8:04

source project.

8:05

And what's cool about that is it means it's super flexible

8:08

and can be customized to fit specific needs.

8:10

Plus, there's a huge community of developers

8:12

who are always working on it and making it better.

8:14

That can be a big advantage because it

8:16

means it's adaptable, and you're not

8:18

stuck relying on a single company's proprietary system.

8:22

So not only is it powerful, but it's also adaptable

8:24

and has a strong community behind it.

8:26

Exactly.

8:27

So to sum it all up, Redash is all

8:29

about making data understandable and accessible

8:32

to everyone in an organization.

8:34

It bridges the gap between raw data and clear insights

8:38

with its user-friendly design powerful features

8:41

and its ability to connect to so many different data sources.

8:44

It helps businesses make informed decisions

8:46

based on actual data without everyone

8:48

needing to be a technical expert.

8:50

So if you ever felt like your company's data was

8:52

this big mystery, Redash seems like the perfect tool

8:55

to shed some light on it and help you take

8:57

smarter, more informed actions.

8:59

It's about moving beyond just guessing and using actual facts

9:02

to make decisions.

9:03

Exactly.

9:04

It takes data which can feel complex and intimidating

9:07

and turns it into a valuable asset

9:09

that everyone can use to achieve better results.

9:12

Well, that was a fantastic overview.

9:14

It really cleared up what Redash is

9:16

and why it's such a valuable tool for businesses today.

9:19

It makes you think, doesn't it?

9:20

How much could your understanding and decision

9:23

making improve if you always had easy access to key data that

9:28

was presented in a way that was easy to understand?

9:31

What new questions could you ask and answer if data

9:33

was that readily available?

9:35

It's pretty exciting to think about.

9:37

It definitely gives you something to think about.

9:39

And before we wrap up this deep dive,

9:40

we want to give another big thanks to our supporter Safe

9:43

Server for making this episode possible.

9:45

They're the experts when it comes

9:47

to hosting solutions and digital transformation consulting,

9:49

so be sure to check them out at www.teedsafeserver.dd

9:54

Thanks for joining us.

9:54

Thanks for joining us.