Open Source Dashboard overview:

What is an Open Source Dashboard?

Our open source Dashboard is the best open source dashboard software in which source code is released under a license in which the users are granted the rights to use, change, and distribute the open source dashboard to anyone and for any purpose. This Open Source is developed in the most widely used Open Source platform such as PHP, Apache, MySQL, HTML5 and JavaScript.

Create dynamic Dashboards with this Open Source Dashboard tool

This SQL dashboard open source empowers the non-technical user with the ability to connect the database using PDO, the most commonly and widely using database connection to fetch data from open source platform such as MySQL, MS SQL, SQLite, ORACLE, PostgreSQL, Sybase and Cubrid, CSV and MS EXCEL files, and create interactive dynamic dashboards and business intelligence reports. This open source dashboard provides a variety of chats like line chart, scatter chart, bar chart, pie chart, donuts chart, bubble chart, stack chat, area chart, heatmap chart, sankey diagrams and choropleth map. The user can download these dynamic charts in PNG image format. This open source dashboard enables to customize dashboard layout with the most powerful drag-and-drop features to place each chart exactly where you want for optimal representation. This drag-and-drop layout is fully responsive and compatible with PC, mobile phone and tablets using the most powerful front-end open source dashboard framework such as D3.js and Bootstrap framework .

The dashboards produced by our open source dashboard tools are pure dynamic and based on D3.js which is the most widely used JavaScript library for producing dynamic and interactive data visualizations in web browsers. Our dashboard uses the widely implemented SVG, HTML5, and CSS standards which can be created either static or real-time data coming from a variety of data sources.

Getting Started

In our Open Source Dashboard example, we are going to build a simple dashboard and then will generate PHP source code for our web application. For this, we will be demonstrating with our freely available open-source drag and drop based open source web dashboards. To install and run the open source dashboard php, following are the requirements.

 

Requirements

This open source dashboard can be installed any platforms like Windows, Linux and Ubuntu or any other platforms support Apache, Nginx etc.

  • PHP Version 5.6 or later
  • Apache 2 or later
  • Windows 7 or later /Linux 3 or later
  • Firefox 52, Chrome 57, IE 8

 

Installation

There is a Free version of the Open Source Dashboard available for trail bases

 

Open Source Dashboard examples

Before really going into connecting the database and fetching the data with this web dashboard open source software, make sure that your Web Server (like Apache, Nginx, etc) is configured to display documents in the folder which will contain dashboard. Read-Write permission to the folders and sub-folders of dashboardbuilder i.e chmod -R 777 dashbboardbuilder-v3-FREE. Check your browser inspector/console to make sure that there isn't any error being reported, and all the Open Source Dashboard builder files are being loaded properly.

Create your first Open Source Dashboard

 

 

Welcome Screen

 

This is the main panel of the Open Source Dashboard. This is a HTML5 based fully responsive interface built in PHP, HTML, JavaScript and CSS. The interface has a minimal design with a drag-and-drop feature that allows you to add multiple chart panel to customize the dashboard on according to the way you want.

  • Following screen will appear. Select Database from data source tab. Select SQLite from the drop down list of Database, Enter your "../data/Northwind.db" in the DB name field and Save changes    as mentioned in the screen.

 

Select your Database

 

 

  • A green tick mark with Database  will appear when your database is successfully connected.

 

Dashboard Preference

 

  • Select the gear icon for your Dashboard preference.

 

Database Connected

 

  • The following screen will appear. List of the tables will appear.

 

Chart Preference

 

  • Enter your SQL statement in text box, SQL field as the following manner

SELECT strftime('%Y-%m',o.shippeddate) as xaxis, sum(d.quantity) as yaxis from `order details` d, orders o where o.orderid = d.orderid group by strftime('%Y-%m',o.orderdate) limit 50

  • Click the Run Query button

SQL Statement

 

  • Query Result will appear. Now Select your x-axis data from the drop down list of   and y-axis data from the drop down list of Y .
  • Click Save Changes

 

SQL Query Result

 

  • Charts will be appeared on the screen as shown below.

 

Chart Preference2

 

  • You may adjust the size and the position of the Chart Panel by draging it's corncer.

Chart Preference 3

  • Now Click the Generate   button

 

Chart Preference 4

 

  • PHP code for the chart will automatically generate, you may copy past this code to your PHP application.

 

Auto-generated Open Source Code



/**
 * DashboardBuilder
 *
 * @author Diginix Technologies www.diginixtech.com
 * Support  - http://www.dashboardbuilder.net
 * @copyright (C) 2018 Dashboardbuilder.net
 * @version 2.1.5
 * @license: license.txt
 */

include("inc/dashboard_dist.php");  // copy this file to inc folder 


// for chart #1
$data = new dashboardbuilder(); 
$data->type =  "line";

$data->source =  "Database"; 
$data->rdbms =  "sqlite"; 
$data->servername =  "";
$data->username =  "";
$data->password =  "";
$data->dbname =  "data\Northwind.db";
$data->xaxisSQL[0]=  "SELECT strftime(^%Y-%m^,o.shippeddate) as xaxis, sum(d.quantity) as yaxis from `order details` d, orders o  where o.orderid = d.orderid group by strftime(^%Y-%m^,o.orderdate) limit 50";
$data->xaxisCol[0]=  "xaxis";
$data->yaxisSQL[0]=  "SELECT strftime(^%Y-%m^,o.shippeddate) as xaxis, sum(d.quantity) as yaxis from `order details` d, orders o  where o.orderid = d.orderid group by strftime(^%Y-%m^,o.orderdate) limit 50";
$data->yaxisCol[0]=  "yaxis";
$data->name = "linechart";
$data->title = "Line Chart";
$data->orientation = "";
$data->xaxistitle = "x-axis title";
$data->yaxistitle = "y-axis title";
$data->showgrid = "";
$data->showline = "";
$data->height = "167";
$data->width = "";
$data->col = "0";
$result[0] = $data->result();

?>

<!DOCTYPE html>
<html> 
<head> 
	<script src="assets/js/dashboard.min.js"></script> <!-- copy this file to assets/js folder --> 
	<link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css"> <!-- Bootstrap CSS file, change the path accordingly --> 

<style>
@media screen and (min-width: 960px) {
.id0 {position:absolute;margin-top:67px;}

}
.panel-heading {line-height:0.7em;}
#kpi {font-size:34px; font-weight:bold;text-align:center;}
#kpi_legand {font-size:11px; color:#999;text-align:center;}
</style>


</head>
<body> 

<div class="container-fluid main-container">
<div class="col-md-12 col-lg-12 col-xs-12">
<div class="row">
<div class="col-md-4 col-lg-4 col-md-offset-4 col-lg-offset-4 col-xs-12 id0">
<div class="panel panel-default">
<div class="panel-heading">Line Chart</div>
    <div class="panel-body">
        <?php echo $result[0];?>
    </div>
</div>
</div>
</div>
</div>
</div>
</body>

 

 

Open Source License

This auto-generated PHP source code generated by our Open Source Dashboard PHP is under MIT license, the most popular software license on GitHub, ahead of any GPL variant and other free and open-source software (FOSS) licenses.

This MIT license puts a very limited restriction on reuse and has, therefore, excellent license compatibility. This license permits reuse within proprietary the source code generated by our dashboard tool open source, provided that all copies of the source code include a copy of the MIT License terms and the copyright notice. This license is also compatible with many copyleft licenses, such as the GNU General Public License (GPL). The source code generated by our open source tool can be integrated into GPL software.

The source code generated by the Opensource Dashboards allow you to customize as per your desire needs and can be used an anywhere you want. You can find the complete information about the license here

 

Conclusion

Now we have a Open Source that can be used with any web application that was customized to fit the requirements of the web design. The project also offers free and paid plans. You can also download Free Dashboard Software Open Source version. The code for free open source dashboard can be found on GitHub under this license

Best of all, with our Standard and Enterprise licenses include 100% source code, for you to enhance the functionality or incorporate the Open Source Dashboard into your web application or any PHP software solutions/products, analytics/data science/data warehouse enterprise systems or Joomla, Wordpress or Drupal sites.

All editions of our dashboard tools open source series are still fully functional, for sale and supported and provides increasing levels of support to address the queries of users and developers.

Dashboard software open source can also be implemented using an online API where you don’t have to mix with a PHP script or PHP source code. The online API uses universal HTML code which can be used in any platform. The data will be added or retrieved from the database using the API. You may find more information about the Online Dashboard.


You may want to take a look at our complete documentation and video tours of the latest version along with a live tour of user interface and step by step instructions for performing key features.


FREE Open Source Dashboard Software