Data Visualisation Tools With DuckDB & MotherDuck - Hex/Preset

In this video, @mehdio walks you through two (actually three) data visualization tools you can use with @duckdb and MotherDuck: @_hex_tech , @Preset-io & Superset. ☁️🦆 Start using DuckDB in the Cloud for FREE with MotherDuck : https://hubs.la/Q02QnFR40 📓 Resources How to load data in MotherDuck : https://motherduck.com/docs/key-tasks... Hex tutorial to connect with Motherduck : https://motherduck.com/docs/integrati... Preset/Superset tutorial to connect with MotherDuck : https://motherduck.com/docs/integrati... Get access to MotherDuck : https://motherduck.com/ ➡️ Follow Us LinkedIn:   / 8192.  . Twitter :   / motherduck   Blog: https://motherduck.com/blog/ 0:00 Intro 1:11 Hex & MotherDuck 3:22 Preset/Superset & MotherDuck 5:19 Conclusion #duckdb #datavisualization -------------------------------------- Struggling to create dashboards from your local DuckDB data pipelines? This video demonstrates how to solve this common challenge using MotherDuck, a serverless analytics platform based on DuckDB. By centralizing your data in MotherDuck, you can easily connect to powerful data visualization and BI tools. We'll walk through a practical guide on connecting two popular options, Hex and Apache Superset (via Preset), to build insightful dashboards directly from your cloud data warehouse. First, we explore Hex, a collaborative data science and analytics notebook for teams using Python and SQL. Learn the step-by-step process to connect Hex to MotherDuck, starting with how to securely store your MotherDuck service token using Hex secrets. We'll show you how to verify your DuckDB version, establish a connection using the simple `md:` prefix, and run SQL queries against your datasets, like the NYC Taxi data. See how quickly you can transform a query result into a shareable bar chart, streamlining the path from data exploration to published insight. Next, we dive into Apache Superset and its managed cloud service, Preset, a leading open-source data exploration and visualization platform. This option is perfect for users who prefer a UI-driven dashboarding experience. This tutorial covers how to add MotherDuck as a data source by configuring the SQLAlchemy URI with your service token. We'll guide you through the typical workflow: writing a query in the SQL Lab, saving it as a reusable dataset, creating a chart, and finally adding it to a fully interactive dashboard. This method is excellent for building robust BI solutions with less code. Whether you prefer the notebook-style workflow of Hex for collaborative data science or the powerful, UI-driven dashboard builder in Superset and Preset, this guide provides the essential steps for your data visualization needs. Learn how to leverage these BI tools for DuckDB and MotherDuck to create amazing data visualizations and share your findings effectively. For detailed written tutorials on each integration, be sure to check the links in the description. Watch with full transcript & resources: https://motherduck.com/videos/data-vi...