Redash Masterclass: Dashboards, SQL & On-Prem Deployment

Mastering Redash – From Installation to Interactive Dashboards

Redash is a powerful open-source business intelligence and data visualization platform widely used by data analysts, data engineers, and BI professionals to explore data, write queries, and build interactive dashboards. This course is a complete, hands-on guide to mastering Redash, starting from the basics and progressing all the way to real-world dashboards and capstone projects.

The course begins with a strong foundation in Redash fundamentals, where you will understand what Redash is, how it works, and its core components. You will then move into a fully practical section focused on installing Redash on local and on-premises environments using Docker. Step-by-step demonstrations show you how to install Docker Desktop on Windows 10/11 and run Redash locally, closely simulating enterprise on-prem setups.

Next, the course dives into Redash administration, covering essential system administration concepts and hands-on management of data source permissions—an important skill when working in real organizational environments with multiple users and teams.

A major highlight of this course is connecting and querying real on-prem data sources. You will work hands-on with popular technologies such as Cassandra, Hive, and MySQL, learn how to write SQL queries in Redash, use query parameters and query snippets, and load CSV data into MySQL for creating meaningful charts.

The visualization section is comprehensive and practical, covering a wide range of charts, including tables, line, bar, area, pie, scatter, boxplot, cohort, funnel, map, pivot table, Sankey, sunburst, and word cloud. You will also learn which chart to use and when, helping you create insightful and effective dashboards.

Finally, you will bring everything together in the capstone project, where you build a complete Video Game Sales dashboard from scratch. By the end of this course, you will have the confidence and skills to install, administer, query, visualize, and build production-ready dashboards using Redash, making you job-ready for real-world data analytics and BI roles.