Skip to content
Try cloud

A data visualization tool turns rows of numbers into charts people can read at a glance. Dashboard Builder connects to MySQL, PostgreSQL, SQL Server, Oracle, Google Sheets, Excel, CSV or PDF, lets you pick from 20+ chart types without writing code, and puts the result on a live dashboard you can share with a link or embed in your own PHP application. Run it on your own server, in the cloud or on Windows.

★★★★★ Average user rating 5/5 based on 12 reviews

What a data visualization tool does

Data visualization is the practice of showing data as charts, maps and tables so that patterns, outliers and trends stand out. A data visualization tool does three jobs for you:

  1. Connects to data where it already lives: a database, a spreadsheet, a JSON feed or a PDF report.
  2. Shapes it with a query or a filter, so each chart answers one question.
  3. Draws and shares it as interactive charts on a dashboard that refreshes when the data changes.

Database visualization, no-code data visualization and data visualization software are all names for the same job. This page covers all three.

How to visualize your data in 5 steps

1

Connect a source. Pick MySQL, PostgreSQL, SQL Server, Oracle, SQLite or ODBC and enter the connection details, or upload Excel, CSV or PDF. A green check confirms the connection.

2

Write or generate the query. Use the SQL builder to choose tables and columns, or type the SQL yourself. For a quick start, the AI Dashboard Generator reads a file and builds the charts for you.

3

Choose the chart. Map columns to the X and Y axes and pick a chart type: line, bar, area, pie, donut, gauge, heatmap, Sankey, map and more.

4

Arrange the dashboard. Drag and resize panels, add KPI cards and filters, and set how often each chart refreshes.

5

Share or embed. Send a link, or generate PHP/HTML5 code and paste it into WordPress, Joomla, Laravel or any PHP page.

Which chart to use

Question you want to answerBest chartExample
How did a value change over time?Line or area chartMonthly revenue for the last 24 months
Which category is biggest?Bar or column chartSales by region
What share does each part have?Pie or donut (5 slices or fewer)Traffic by channel
Are we on target?Gauge or KPI cardOrders today vs goal
Where do two things relate?Scatter or bubble chartAd spend vs sign-ups
When is activity highest?HeatmapSupport tickets by hour and weekday
How does volume flow between stages?Sankey diagramVisitors to trial to customer
Where is it happening?Choropleth mapCustomers by country

See live examples in the dashboard gallery and the examples page.

Data you can visualize

Dashboard Builder reads from 25+ sources, so you can put a database table next to a spreadsheet on the same dashboard:

Databases: MySQL, PostgreSQL, SQL Server, Oracle, SQLite and any ODBC source.
Files: Excel, CSV and PDF. Dashboard Builder reads and fetches tables from PDF reports too.
Cloud and feeds: Google Sheets (live link) and JSON from a REST API.

Each connection has its own guide in the data sources hub.

No-code vs coding a chart library

You can build charts by hand with a JavaScript chart library, but you then own the data access, the queries, the layout and every change request. A no-code tool handles that work:

Chart library (hand-coded)Dashboard Builder (no code)
Connect to a databaseWrite and secure your own APIBuilt in, 25+ sources
Change a chartEdit code, test, deployEdit in the browser
New chart typeLearn the library’s APIPick from 20+ types
Embed in a PHP appYes, with your own codeGenerated PHP/HTML5 code
Who can make changesDevelopersAnalysts and developers

Data visualization best practices

One question per chart. If a chart needs a paragraph to explain, split it in two.
Start the axis at zero for bars. Truncated bars exaggerate small differences.
Use colour with intent. Grey for context, one accent colour for the thing that matters.
Put KPIs on top. Headline numbers first, detail charts below, filters at the side.
Show the comparison. Actual vs target, this month vs last month, or one region vs the average.
Keep it live. Connect to the source instead of pasting exports, and set a refresh interval.

Requirements and installation (self-hosted)

  • Windows, Linux or macOS with Apache or Nginx and PHP 7.4 or later.
  • allow_url_fopen enabled and the SimpleXML extension installed.
  • The PDO driver for your database (for example PDO_MySQL, PDO_PGSQL or PDO_SQLSRV).
  • Write permission for the web server on the data/ and store/ folders (755 for folders, 644 for files).

Install with Composer:

composer create-project --no-dev dashboardbuilder/dashboardbuilder.net .

or download the ZIP from the free trial page, unzip it into your web folder and open it in the browser. Full steps are in the documentation.

How to choose a data visualization tool

  • Where must the data stay? If it can’t leave your servers, choose a self-hosted tool. Dashboard Builder runs on Windows, Linux or macOS with Apache or Nginx and PHP 7.4+.
  • Who builds the charts? No-code editing lets analysts work without waiting for developers.
  • How will people see them? A shared link, an embed inside your own app, or both.
  • What does it cost per year? Per-user subscriptions add up. Self-hosted licences are a one-time payment: Essential $119, Professional $399, Enterprise $1,499.

Comparing tools? Read Dashboard Builder vs Power BI, the Tableau alternative and the Metabase alternative pages. For the bigger picture of reports, KPIs and decision-making, see BI dashboards.

Frequently asked questions

It depends on where your data lives. For a quick chart from Excel, CSV or PDF, the free AI Dashboard Generator builds KPI cards and charts in seconds with no sign-up. For databases, the Dashboard Builder self-hosted free trial never expires; it adds a watermark and has fewer features than the paid licences.
Yes. Dashboard Builder can read tables from a PDF and turn them into charts, just like Excel and CSV files.
No. The SQL builder lets you choose tables and columns, and the AI Dashboard Generator needs only a file. If you know SQL, you can write your own queries.
More than 20, including line, bar, area, pie, donut, gauge, scatter, bubble, heatmap, Sankey, table and choropleth map.
Yes. Dashboard Builder generates PHP/HTML5 code for WordPress, Joomla, Laravel or any PHP page, and charts can also be shared with a link. Charts are responsive.
Not with the self-hosted edition: it runs on your own server and connects to your databases directly. The cloud edition is there if you’d rather not install anything.

Try it free

Build your first dashboard in minutes

Upload Excel, CSV or PDF to the free AI Dashboard Generator, or download the self-hosted free trial and connect your database.

Build with AI, free Download the free trial Start a 5-day cloud trial

Dashboard Builder works wherever you do.

Get Dashboard Builder freeFor your server, the cloud and Windows