1 00:00:00,000 --> 00:00:01,280 All right, so you know why you're here, right? 2 00:00:01,280 --> 00:00:03,360 You wanna learn something and you wanna learn it fast. 3 00:00:03,360 --> 00:00:05,520 That's kind of our whole thing here on the Deep Dive. 4 00:00:05,520 --> 00:00:07,920 Get to the core of it all without all that extra fluff. 5 00:00:07,920 --> 00:00:10,960 Absolutely, yeah, cut right to the chase, right. 6 00:00:10,960 --> 00:00:13,800 And today we're diving into something that's, 7 00:00:13,800 --> 00:00:16,060 well, it's becoming kinda essential for businesses 8 00:00:16,060 --> 00:00:19,400 that really wanna understand what their data is telling them. 9 00:00:19,400 --> 00:00:20,640 Makes sense. 10 00:00:20,640 --> 00:00:22,500 But first, a huge thanks to Safe Server 11 00:00:22,500 --> 00:00:24,240 for supporting this Deep Dive. 12 00:00:24,240 --> 00:00:26,520 If you're looking for top-notch hosting solutions 13 00:00:26,520 --> 00:00:29,800 or need some expert advice on digital transformation, 14 00:00:29,800 --> 00:00:34,800 you gotta check them out at www.safeserver.dd. 15 00:00:34,800 --> 00:00:39,900 Now, getting into it today, we're talking Redash. 16 00:00:39,900 --> 00:00:40,740 Redash, okay. 17 00:00:40,740 --> 00:00:42,980 Yeah, and you might've heard this term thrown around, 18 00:00:42,980 --> 00:00:46,480 like data-driven, but honestly, the idea is pretty simple 19 00:00:46,480 --> 00:00:47,960 and it's super powerful. 20 00:00:47,960 --> 00:00:49,280 Okay, I'm intrigued. 21 00:00:49,280 --> 00:00:50,720 I'll admit, though, for someone like me 22 00:00:50,720 --> 00:00:54,120 who isn't exactly a coding whiz, 23 00:00:54,120 --> 00:00:56,200 the thought of dealing with all that company data 24 00:00:56,200 --> 00:00:57,180 can be kinda scary. 25 00:00:57,180 --> 00:00:58,020 I get it. 26 00:00:58,020 --> 00:01:00,200 This Redash thing is supposed to make it easy. 27 00:01:00,200 --> 00:01:02,960 It's designed to take away that fear factor. 28 00:01:02,960 --> 00:01:04,400 Think of it like a translator, 29 00:01:04,400 --> 00:01:06,100 something that helps anyone understand 30 00:01:06,100 --> 00:01:08,760 what their company data is actually saying. 31 00:01:08,760 --> 00:01:10,520 So basically today, we're gonna break down 32 00:01:10,520 --> 00:01:13,600 what Redash is all about and why it can be 33 00:01:13,600 --> 00:01:15,920 a total game changer when it comes to understanding 34 00:01:15,920 --> 00:01:17,520 what's going on in your business. 35 00:01:17,520 --> 00:01:19,280 All right, I'm ready to have my data translated. 36 00:01:19,280 --> 00:01:20,400 Let's start with the basics. 37 00:01:20,400 --> 00:01:22,160 What is Redash exactly? 38 00:01:22,160 --> 00:01:23,880 Okay, so in the simplest terms, 39 00:01:23,880 --> 00:01:26,820 it's a tool that helps companies make smarter decisions 40 00:01:26,820 --> 00:01:29,200 by actually looking at their data. 41 00:01:29,200 --> 00:01:31,220 And like I said, data-driven might sound 42 00:01:31,220 --> 00:01:32,600 like a fancy buzzword, but really, 43 00:01:32,600 --> 00:01:34,680 it just means using actual facts and figures 44 00:01:34,680 --> 00:01:37,520 to make choices instead of just winging it. 45 00:01:37,520 --> 00:01:38,360 Makes sense. 46 00:01:38,360 --> 00:01:40,800 So how does Redash take all this data 47 00:01:40,800 --> 00:01:42,480 and turn it into something useful? 48 00:01:42,480 --> 00:01:44,020 Well, its main job is to connect 49 00:01:44,020 --> 00:01:45,360 to all those different places 50 00:01:45,360 --> 00:01:47,360 where companies keep their information, 51 00:01:47,360 --> 00:01:52,080 like customer databases, sales, spreadsheets, 52 00:01:52,080 --> 00:01:54,920 website analytics, you name it, all kinds of sources. 53 00:01:54,920 --> 00:01:58,160 And once it's connected, it lets you take all that raw data 54 00:01:58,160 --> 00:02:00,520 and turn it into easy to understand visuals, 55 00:02:00,520 --> 00:02:02,360 you know, charts and graphs. 56 00:02:02,360 --> 00:02:04,400 Then you can put all these visuals together 57 00:02:04,400 --> 00:02:06,440 on a single page, which is called a dashboard, 58 00:02:06,440 --> 00:02:07,880 and it gives you like a snapshot 59 00:02:07,880 --> 00:02:09,680 of all the most important information. 60 00:02:09,680 --> 00:02:12,920 And the best part, you can share these dashboards 61 00:02:12,920 --> 00:02:15,020 with your entire team super easily. 62 00:02:15,020 --> 00:02:16,840 That sounds way less intimidating 63 00:02:16,840 --> 00:02:19,640 than trying to make sense of a giant spreadsheet. 64 00:02:19,640 --> 00:02:23,240 You mentioned earlier that Redash is for anyone, 65 00:02:23,240 --> 00:02:25,840 regardless of how tech savvy they are. 66 00:02:25,840 --> 00:02:26,680 How does it do that? 67 00:02:26,680 --> 00:02:27,720 That's what's so cool about it. 68 00:02:27,720 --> 00:02:31,200 So if you know SQL, which is basically a special language 69 00:02:31,200 --> 00:02:33,760 for asking questions to databases, 70 00:02:33,760 --> 00:02:36,400 you can use Redash to really dig deep, 71 00:02:36,400 --> 00:02:39,920 explore, and create your own custom visualizations. 72 00:02:39,920 --> 00:02:42,160 But even if you don't know SQL, 73 00:02:42,160 --> 00:02:45,080 you can still get a lot of value from the dashboards 74 00:02:45,080 --> 00:02:47,320 and reports that other people create. 75 00:02:47,320 --> 00:02:50,000 It's like having someone who's fluent in data 76 00:02:50,000 --> 00:02:53,160 translate everything for everyone else in the company. 77 00:02:53,160 --> 00:02:54,200 I like that analogy. 78 00:02:54,200 --> 00:02:56,720 So the data experts can use their skills 79 00:02:56,720 --> 00:02:59,760 to create insights that everyone can understand. 80 00:02:59,760 --> 00:03:01,960 That's a great way to bridge that gap. 81 00:03:01,960 --> 00:03:03,480 And it's pretty impressive that you said 82 00:03:03,480 --> 00:03:06,200 millions of users at thousands of organizations 83 00:03:06,200 --> 00:03:07,400 are using it every day. 84 00:03:07,400 --> 00:03:09,320 It shows you how widely it's being used. 85 00:03:09,320 --> 00:03:10,080 Absolutely. 86 00:03:10,080 --> 00:03:11,760 It's a tool that's actively helping 87 00:03:11,760 --> 00:03:14,560 all kinds of businesses make better decisions. 88 00:03:14,560 --> 00:03:16,840 So why don't we break down some of the key features 89 00:03:16,840 --> 00:03:19,040 of Redash and explain them simply. 90 00:03:19,040 --> 00:03:19,880 Let's do it. 91 00:03:19,880 --> 00:03:21,000 What's the first thing we need to know? 92 00:03:21,000 --> 00:03:23,400 First off, Redash is browser-based. 93 00:03:23,400 --> 00:03:25,960 So you access everything through a web browser, 94 00:03:25,960 --> 00:03:28,840 just like checking your email or browsing a website. 95 00:03:28,840 --> 00:03:29,360 OK. 96 00:03:29,360 --> 00:03:31,680 No complicated software to install. 97 00:03:31,680 --> 00:03:32,160 Gotcha. 98 00:03:32,160 --> 00:03:34,720 And you can share links to your charts and dashboards 99 00:03:34,720 --> 00:03:37,320 with colleagues, just like you'd share any other web link. 100 00:03:37,320 --> 00:03:38,400 So it's super accessible. 101 00:03:38,400 --> 00:03:39,800 You just need to be online. 102 00:03:39,800 --> 00:03:42,880 That definitely takes away a big barrier to entry. 103 00:03:42,880 --> 00:03:45,120 What else makes it so user-friendly? 104 00:03:45,120 --> 00:03:48,600 Well, another key aspect is its ease of use. 105 00:03:48,600 --> 00:03:51,120 The whole point is to let you start getting value 106 00:03:51,120 --> 00:03:53,320 from your data as quickly as possible 107 00:03:53,320 --> 00:03:55,320 without needing tons of training. 108 00:03:55,320 --> 00:03:56,200 I appreciate that. 109 00:03:56,200 --> 00:03:58,280 It goes back to what you were saying about wanting 110 00:03:58,280 --> 00:03:59,680 to learn things efficiently. 111 00:03:59,680 --> 00:04:02,040 You spend less time learning the tool 112 00:04:02,040 --> 00:04:04,680 and more time actually understanding your business. 113 00:04:04,680 --> 00:04:05,440 Exactly. 114 00:04:05,440 --> 00:04:06,860 There's nothing worse than a tool 115 00:04:06,860 --> 00:04:09,480 that feels like you need a PhD just to use it. 116 00:04:09,480 --> 00:04:10,080 Right. 117 00:04:10,080 --> 00:04:11,960 So then you have the Query Editor. 118 00:04:11,960 --> 00:04:13,720 And for those who are comfortable with it, 119 00:04:13,720 --> 00:04:16,600 this is where you can write those questions or queries 120 00:04:16,600 --> 00:04:20,000 in languages like SQL or NoSQL to get super specific 121 00:04:20,000 --> 00:04:21,400 information from your data. 122 00:04:21,400 --> 00:04:22,000 OK. 123 00:04:22,000 --> 00:04:23,920 But Redash makes this easier too with things 124 00:04:23,920 --> 00:04:25,760 like a schema browser, which is basically 125 00:04:25,760 --> 00:04:27,920 like a table of contents for your data 126 00:04:27,920 --> 00:04:31,200 showing you what information is available and autocomplete, 127 00:04:31,200 --> 00:04:33,480 which helps you write those queries faster 128 00:04:33,480 --> 00:04:35,040 and with fewer mistakes. 129 00:04:35,040 --> 00:04:36,680 So for the more technical folks, it 130 00:04:36,680 --> 00:04:39,520 gives them powerful ways to get exactly the data they need. 131 00:04:39,520 --> 00:04:40,600 Exactly. 132 00:04:40,600 --> 00:04:42,720 And once you have that data, Redash 133 00:04:42,720 --> 00:04:45,300 makes it super easy to turn it into visuals 134 00:04:45,300 --> 00:04:48,280 with its visualization and dashboards features. 135 00:04:48,280 --> 00:04:50,520 You can create different types of charts and graphs, 136 00:04:50,520 --> 00:04:52,600 often just by dragging and dropping. 137 00:04:52,600 --> 00:04:54,280 Then you can arrange these visuals 138 00:04:54,280 --> 00:04:58,000 onto a single dashboard page to get a clear overall picture. 139 00:04:58,000 --> 00:04:59,920 And people even say that these visualizations 140 00:04:59,920 --> 00:05:01,600 can be quite appealing. 141 00:05:01,600 --> 00:05:04,160 It makes the data much easier to digest at a glance. 142 00:05:04,160 --> 00:05:05,480 Beautiful data. 143 00:05:05,480 --> 00:05:06,440 I like that. 144 00:05:06,440 --> 00:05:08,840 And having everything organized on a dashboard 145 00:05:08,840 --> 00:05:10,800 sounds like a huge time saver. 146 00:05:10,800 --> 00:05:11,560 It is. 147 00:05:11,560 --> 00:05:13,200 And then there's the sharing feature, 148 00:05:13,200 --> 00:05:15,400 which makes collaboration super easy. 149 00:05:15,400 --> 00:05:17,320 You can share your visualizations 150 00:05:17,320 --> 00:05:19,960 and even the underlying data queries with your teammates. 151 00:05:19,960 --> 00:05:20,480 Oh, nice. 152 00:05:20,480 --> 00:05:23,200 So everyone can review, discuss, and build 153 00:05:23,200 --> 00:05:24,560 upon each other's work. 154 00:05:24,560 --> 00:05:26,960 It creates a much more collaborative approach 155 00:05:26,960 --> 00:05:28,960 to understanding data. 156 00:05:28,960 --> 00:05:31,200 Teamwork makes the dream work right. 157 00:05:31,200 --> 00:05:31,680 Yeah. 158 00:05:31,680 --> 00:05:34,080 Even when it comes to data. 159 00:05:34,080 --> 00:05:37,360 What other helpful features does Redash offer? 160 00:05:37,360 --> 00:05:39,080 Well, there's also schedule refreshes, 161 00:05:39,080 --> 00:05:41,640 which means you can set your charts and dashboards 162 00:05:41,640 --> 00:05:44,120 to automatically update at specific times 163 00:05:44,120 --> 00:05:45,440 with the latest information. 164 00:05:45,440 --> 00:05:46,280 That was handy. 165 00:05:46,280 --> 00:05:48,400 So you're always looking at the most current data 166 00:05:48,400 --> 00:05:50,080 without having to lift a finger. 167 00:05:50,080 --> 00:05:52,400 That's going to be super important for businesses that 168 00:05:52,400 --> 00:05:54,560 move quickly where things are constantly changing. 169 00:05:54,560 --> 00:05:56,000 Absolutely. 170 00:05:56,000 --> 00:05:58,680 And to help you stay on top of those important changes, 171 00:05:58,680 --> 00:06:00,520 Redash has alerts. 172 00:06:00,520 --> 00:06:03,160 You can set up rules that will trigger notifications 173 00:06:03,160 --> 00:06:05,440 when certain things happen in your data. 174 00:06:05,440 --> 00:06:07,840 Like, for example, you could get an alert if sales drop 175 00:06:07,840 --> 00:06:10,000 below a certain level so you can react quickly. 176 00:06:10,000 --> 00:06:11,840 That's a great way to stay ahead of the curve 177 00:06:11,840 --> 00:06:13,960 and catch potential problems early on. 178 00:06:13,960 --> 00:06:15,560 Now for the more advanced users who 179 00:06:15,560 --> 00:06:19,000 want to take things even further, there's the REST API. 180 00:06:19,000 --> 00:06:22,320 Think of this as a way for Redash to talk to other software 181 00:06:22,320 --> 00:06:23,320 automatically. 182 00:06:23,320 --> 00:06:24,120 Interesting. 183 00:06:24,120 --> 00:06:26,360 It lets you integrate Redash with other tools 184 00:06:26,360 --> 00:06:28,840 your company uses so you can streamline workflows 185 00:06:28,840 --> 00:06:30,520 and automate tasks. 186 00:06:30,520 --> 00:06:32,000 For example, you could automatically 187 00:06:32,000 --> 00:06:34,640 pull data from Redash into a marketing report. 188 00:06:34,640 --> 00:06:36,880 So we can connect with all those other important business 189 00:06:36,880 --> 00:06:38,440 systems seamlessly. 190 00:06:38,440 --> 00:06:39,960 That's a big plus for efficiency. 191 00:06:39,960 --> 00:06:41,040 Definitely. 192 00:06:41,040 --> 00:06:43,480 And finally, one of Redash's biggest strengths 193 00:06:43,480 --> 00:06:45,960 is its broad data source support. 194 00:06:45,960 --> 00:06:49,040 It can connect to a huge range of databases and platforms. 195 00:06:49,040 --> 00:06:53,000 We're talking over 35 SQL and NoSQL data sources. 196 00:06:53,000 --> 00:06:55,760 And it's built to be flexible enough to handle even more. 197 00:06:55,760 --> 00:06:58,800 You'll recognize names like Google Sheets, MySQL, 198 00:06:58,800 --> 00:07:01,840 and PostgreSQL as just a few examples of what 199 00:07:01,840 --> 00:07:03,240 Redash can pull data from. 200 00:07:03,240 --> 00:07:04,880 Wow, that's a lot of options. 201 00:07:04,880 --> 00:07:07,640 So basically, no matter where a company keeps its data, 202 00:07:07,640 --> 00:07:09,280 Redash can probably access it. 203 00:07:09,280 --> 00:07:10,300 You've got it. 204 00:07:10,300 --> 00:07:12,260 Now let's bring all this back to our listeners, 205 00:07:12,260 --> 00:07:15,560 who you know are all about gaining knowledge quickly. 206 00:07:15,560 --> 00:07:18,920 How can someone like them benefit from all these features? 207 00:07:18,920 --> 00:07:21,480 Well, the ease of use is a big one for sure. 208 00:07:21,480 --> 00:07:23,500 It means you can spend less time figuring out 209 00:07:23,500 --> 00:07:26,880 complicated software and more time focusing on the insights 210 00:07:26,880 --> 00:07:28,100 that really matter. 211 00:07:28,100 --> 00:07:29,880 And those visual dashboards, they 212 00:07:29,880 --> 00:07:32,040 take all that complex data and make 213 00:07:32,040 --> 00:07:34,520 it clear and easy to understand so you can quickly 214 00:07:34,520 --> 00:07:37,480 grasp the main points without feeling overwhelmed 215 00:07:37,480 --> 00:07:38,320 by numbers. 216 00:07:38,320 --> 00:07:39,440 Exactly. 217 00:07:39,440 --> 00:07:41,920 And even if you're not the one writing complex code, 218 00:07:41,920 --> 00:07:44,640 the fact that data experts can create and share 219 00:07:44,640 --> 00:07:47,120 those user-friendly dashboards means everyone 220 00:07:47,120 --> 00:07:49,240 can access valuable information. 221 00:07:49,240 --> 00:07:50,680 It really levels the playing field 222 00:07:50,680 --> 00:07:53,160 and lets more people participate in data-driven discussions 223 00:07:53,160 --> 00:07:54,020 and decisions. 224 00:07:54,020 --> 00:07:55,560 You don't need to be a data scientist 225 00:07:55,560 --> 00:07:57,360 to understand what your data is telling you. 226 00:07:57,360 --> 00:07:59,080 I think that's a really important point. 227 00:07:59,080 --> 00:08:01,880 It makes data accessible to everyone in the organization. 228 00:08:01,880 --> 00:08:04,260 One more thing to mention is that Redash is a popular open 229 00:08:04,260 --> 00:08:05,360 source project. 230 00:08:05,360 --> 00:08:08,040 And what's cool about that is it means it's super flexible 231 00:08:08,040 --> 00:08:10,600 and can be customized to fit specific needs. 232 00:08:10,600 --> 00:08:12,520 Plus, there's a huge community of developers 233 00:08:12,520 --> 00:08:14,920 who are always working on it and making it better. 234 00:08:14,920 --> 00:08:16,760 That can be a big advantage because it 235 00:08:16,760 --> 00:08:18,720 means it's adaptable, and you're not 236 00:08:18,720 --> 00:08:22,280 stuck relying on a single company's proprietary system. 237 00:08:22,280 --> 00:08:24,720 So not only is it powerful, but it's also adaptable 238 00:08:24,720 --> 00:08:26,840 and has a strong community behind it. 239 00:08:26,840 --> 00:08:27,520 Exactly. 240 00:08:27,520 --> 00:08:29,800 So to sum it all up, Redash is all 241 00:08:29,800 --> 00:08:32,080 about making data understandable and accessible 242 00:08:32,080 --> 00:08:34,560 to everyone in an organization. 243 00:08:34,560 --> 00:08:38,360 It bridges the gap between raw data and clear insights 244 00:08:38,360 --> 00:08:41,320 with its user-friendly design powerful features 245 00:08:41,320 --> 00:08:44,640 and its ability to connect to so many different data sources. 246 00:08:44,640 --> 00:08:46,640 It helps businesses make informed decisions 247 00:08:46,640 --> 00:08:48,920 based on actual data without everyone 248 00:08:48,920 --> 00:08:50,800 needing to be a technical expert. 249 00:08:50,800 --> 00:08:52,800 So if you ever felt like your company's data was 250 00:08:52,800 --> 00:08:55,440 this big mystery, Redash seems like the perfect tool 251 00:08:55,440 --> 00:08:57,160 to shed some light on it and help you take 252 00:08:57,160 --> 00:08:59,240 smarter, more informed actions. 253 00:08:59,240 --> 00:09:02,560 It's about moving beyond just guessing and using actual facts 254 00:09:02,560 --> 00:09:03,760 to make decisions. 255 00:09:03,760 --> 00:09:04,800 Exactly. 256 00:09:04,800 --> 00:09:07,800 It takes data which can feel complex and intimidating 257 00:09:07,800 --> 00:09:09,720 and turns it into a valuable asset 258 00:09:09,720 --> 00:09:12,520 that everyone can use to achieve better results. 259 00:09:12,520 --> 00:09:14,060 Well, that was a fantastic overview. 260 00:09:14,060 --> 00:09:16,000 It really cleared up what Redash is 261 00:09:16,000 --> 00:09:19,160 and why it's such a valuable tool for businesses today. 262 00:09:19,160 --> 00:09:20,800 It makes you think, doesn't it? 263 00:09:20,800 --> 00:09:23,360 How much could your understanding and decision 264 00:09:23,360 --> 00:09:28,560 making improve if you always had easy access to key data that 265 00:09:28,560 --> 00:09:31,320 was presented in a way that was easy to understand? 266 00:09:31,320 --> 00:09:33,960 What new questions could you ask and answer if data 267 00:09:33,960 --> 00:09:35,520 was that readily available? 268 00:09:35,520 --> 00:09:37,020 It's pretty exciting to think about. 269 00:09:37,020 --> 00:09:39,040 It definitely gives you something to think about. 270 00:09:39,040 --> 00:09:40,800 And before we wrap up this deep dive, 271 00:09:40,800 --> 00:09:43,240 we want to give another big thanks to our supporter Safe 272 00:09:43,240 --> 00:09:45,660 Server for making this episode possible. 273 00:09:45,660 --> 00:09:47,040 They're the experts when it comes 274 00:09:47,040 --> 00:09:49,880 to hosting solutions and digital transformation consulting, 275 00:09:49,880 --> 00:09:54,400 so be sure to check them out at www.teedsafeserver.dd 276 00:09:54,400 --> 00:09:56,280 to see how they can help your business thrive. 277 00:09:56,280 --> 00:09:58,320 Thanks for joining us.