On this page
Key takeaways
- "Free" means different things: open-source to self-host, a free desktop app, a free cloud tier or public-only publishing.
- For people who don't write SQL, the biggest factor is how a chart gets built: drag and drop, or asking a question.
- Every free option has a catch, such as public data, hosting work, row limits or a single user.
- Pick the one whose catch you can live with, then test it on one real dataset.
What to look for
Tableau is a powerful tool, but for many teams the licence and the learning curve are more than they need. If nobody on your team writes SQL, judge alternatives on four things:
- How you build a chart: drag and drop fields, or ask a question in plain English.
- What data it takes: files only, or live databases too.
- Where it runs: in the cloud, on your desktop or on your own server.
- The catch in the free option: every free plan has one.
Free plans change often. Check each product's site for current limits.
1. DashboardGPT (free Explore plan)
How you build a chart: ask a question in plain English. Answers appear as charts, metrics and written insights on an infinite canvas.
- Data: CSV and Excel uploads up to 50 MB on the free plan; warehouse connections on Team.
- Runs: in the cloud; private or self-hosted deployment on Enterprise.
- The catch: one workspace and canvas on the free plan; you bring your own AI provider key when you work with your own data.
- Best for: people who know what they want to ask but not how to build it.
2. Tableau Public
How you build a chart: the same drag-and-drop Tableau interface.
- Data: mostly files and public data sources.
- Runs: desktop app with publishing to the Tableau Public site.
- The catch: what you publish is public. Not suitable for company data.
- Best for: learning Tableau, portfolios and public data stories.
3. Microsoft Power BI Desktop
How you build a chart: drag and drop, with a formula language (DAX) for calculations.
- Data: many file types and databases.
- Runs: Windows desktop app.
- The catch: sharing with colleagues generally needs paid Power BI licences; Windows only.
- Best for: individuals in Microsoft-based companies.
4. Looker Studio
How you build a chart: drag and drop in the browser.
- Data: strongest with Google sources such as Google Sheets, Google Analytics and BigQuery, plus connectors.
- Runs: in the browser.
- The catch: complex calculations get awkward, and performance depends on the connector.
- Best for: marketing teams reporting on Google data.
5. Metabase (open source)
How you build a chart: a question builder with filters and summaries, plus SQL for advanced users.
- Data: most SQL databases.
- Runs: self-hosted for the free open-source edition.
- The catch: someone has to host, secure and upgrade it.
- Best for: teams with an engineer willing to run it.
6. Apache Superset (open source)
How you build a chart: chart builder on datasets, plus SQL Lab for SQL.
- Data: most SQL databases.
- Runs: self-hosted.
- The catch: hosting work, and non-technical users usually need help building datasets and charts. Natural-language questions need a layer on top; DashboardGPT is one, built on Superset.
- Best for: data teams who want a free, flexible engine.
Comparison
| Tool | Build charts by | Free option | Main catch |
|---|---|---|---|
| DashboardGPT | Asking questions | Free Explore plan | One canvas; bring your own AI key |
| Tableau Public | Drag and drop | Free desktop app | Published work is public |
| Power BI Desktop | Drag and drop, DAX | Free desktop app | Sharing needs paid licences |
| Looker Studio | Drag and drop | Free cloud tool | Best with Google data |
| Metabase | Question builder, SQL | Open source | Self-hosting |
| Apache Superset | Chart builder, SQL | Open source | Self-hosting, steeper learning |
Which should you pick?
- You don't want to build charts at all, only ask questions: DashboardGPT.
- You want to learn Tableau skills for free: Tableau Public.
- Your company runs on Microsoft: Power BI Desktop.
- Your data lives in Google tools: Looker Studio.
- You have an engineer and a database: Metabase or Superset.
Frequently asked questions
Yes. Metabase and Apache Superset are open source and free to self-host. Tableau Public, Power BI Desktop and Looker Studio have free options with limits, and DashboardGPT has a free Explore plan.
A tool you use by asking questions, such as DashboardGPT, removes chart building altogether.
It is not suitable for confidential data, because work published to Tableau Public is visible to anyone.
They offer chart builders, but setting up datasets and advanced analysis usually involves SQL.
Yes, with DashboardGPT's Explore plan (up to 50 MB), and with several of the other tools listed here.