What you’ll build
An interactive, data-connected dashboard — with charts, KPI cards, filters, and drill-downs — deployed as a shareable web app with built-in authentication.Before you start
Create a Workshop account
Sign up at app.workshop.ai. Workshop Cloud is the recommended platform for dashboards.
Connect your data
Dashboards need data. Workshop supports a wide range of data connectors — connect at least one before you start building.
- Databases
- Data warehouses
- Spreadsheets and files
Connect directly to your production or analytics database:
- PostgreSQL, MySQL, Microsoft SQL Server, MongoDB
- Supabase, Neon (managed Postgres)
- TiDB, TigerGraph
Step-by-step flow
Connect your data source
Open the Hub → Connectors and set up a connection to your database, warehouse, or spreadsheet. Workshop stores credentials securely and makes the data available to your projects.
Describe the dashboard you want
Tell Workshop what metrics and visualizations you need. Reference the connected data source.Example prompts:
- “Build a sales analytics dashboard from my Postgres database showing revenue trends over time, top customers, regional performance on a heatmap, and key KPI cards with quarter-over-quarter comparisons.”
- “Create a financial reporting dashboard with P&L statement, cash flow analysis, budget vs. actuals, and drill-down by department.”
- “Build a product analytics dashboard with user cohort retention heatmap, feature adoption funnel, and daily/weekly active users with date range filtering.”
Iterate on the visualizations
Refine specific charts, add filters, or change the layout:
- “Change the revenue chart to a stacked area chart broken down by product line.”
- “Add a date range picker that filters all charts on the page.”
- “Replace the table with a bar chart for the regional breakdown.”
- “Add a row of KPI cards at the top: total revenue, new customers, average deal size, and churn rate.”
Tips and best practices
Describe the metrics, not the SQL
Describe the metrics, not the SQL
You don’t need to know SQL. Say “Show me monthly recurring revenue by customer segment” and Workshop will write the queries for you. If you do know SQL, you can paste queries directly for more precise control.
Use dbt for governed metrics
Use dbt for governed metrics
If your organization uses dbt, Workshop can read your dbt models, metrics, and documentation natively. This means your dashboards are built on governed, version-controlled metric definitions — not ad-hoc queries that drift over time.
Start with KPIs, then add detail
Start with KPIs, then add detail
Begin with the 3-5 key numbers your audience cares about. Once those are right, add supporting charts and drill-downs. This keeps the dashboard focused.
Add interactive filters
Add interactive filters
Ask for date range pickers, dropdown filters, and search bars: “Add filters for date range, region, and product category that affect all charts.” Interactive dashboards are far more useful than static reports.
Test with real data volumes
Test with real data volumes
If your production database has millions of rows, tell Workshop: “This table has 10M+ rows — make sure the queries are performant and use appropriate aggregations.” Workshop will optimize accordingly.
Next steps
- Connectors overview — Full list of supported data sources and setup guides
- Database connectors — Detailed setup for PostgreSQL, MySQL, MongoDB, and more
- Data warehouse connectors — BigQuery and Snowflake configuration
- Publishing — Deploy and share your dashboard
- Sharing and teams — Control access to your dashboards
Start Building Free
Connect your data and build a dashboard you can trust.