Tableau
Tableau is a data visualization and business intelligence platform, owned by Salesforce, known for interactive drag-and-drop dashboards built on its VizQL engine.
Overview
Tableau is one of the longest-established business intelligence tools, built around drag-and-drop visual analysis rather than writing code. Users connect to a data source, drag fields onto a canvas, and Tableau's VizQL engine translates that into queries and renders the result as an interactive chart. Salesforce acquired Tableau in 2019, and it's sold today as Tableau Desktop (authoring), Tableau Server/Cloud (publishing and sharing), and Tableau Public (free, for publicly shared visualizations).
How it works
Tableau connects either live (querying the source database on every interaction) or via an extract (a compressed, columnar snapshot of the data stored in Tableau's own Hyper engine for faster, offline-capable analysis). Calculated fields, parameters, and level-of-detail (LOD) expressions let authors build custom metrics without leaving the visual interface, and dashboards can combine multiple worksheets with shared filters and actions for drill-down.
Copy code
// A Tableau LOD calculated field example
{ FIXED [Customer ID] : SUM([Order Total]) }
Tableau and DuckDB
Tableau supports DuckDB as a data source through a couple of routes: a generic JDBC connection using DuckDB's JDBC driver, or a purpose-built Tableau Connector (Taco) for DuckDB, which is tested against Tableau's dialect generator and handles DuckDB's SQL dialect more reliably than the generic JDBC/Postgres path. Both approaches work with MotherDuck as well, letting Tableau dashboards query DuckDB files or MotherDuck-hosted data directly. As with any JDBC-based connector, the driver files need to be installed in Tableau's driver directory, and Tableau Desktop or Server needs a restart after adding or updating them.
Related terms
Business Intelligence (BI) refers to the technologies, applications, and practices used to collect, integrate, analyze, and present business information.
dashboard →A dashboard is a visual display of key metrics, data points, and analytics that provides a quick overview of an organization's performance or a specific…
data visualization →Data visualization is the graphical representation of information and data, using visual elements like charts, graphs, and maps to communicate complex…
Power BI →Power BI is Microsoft's business intelligence suite for connecting to data, modeling it, and building interactive reports and dashboards.
chart →A chart is a visual representation of data that allows for quick interpretation and analysis.
SQL →SQL (Structured Query Language) is the standard language for working with relational databases.
FAQS
Salesforce acquired Tableau in 2019. It continues to be developed and sold as a standalone product line within Salesforce's portfolio.
Yes, via a JDBC connection using DuckDB's JDBC driver, or a dedicated Tableau connector (Taco) built for DuckDB, which also works with MotherDuck.
A live connection queries the source database on every interaction, always reflecting current data. An extract is a stored snapshot in Tableau's Hyper engine, usually faster and usable offline, but only as fresh as its last refresh.
