Viz Mobile Dashboard Builder is a dashboard reporting platform designed to sit on top of a data warehouse or access information from multiple data sources. Viz is a web-based, mobile-ready, application designed using PHP, MySQL, Bootstrap, D3, NVD3, DataTables, and PHPAuth.

The included templates provide common visualization types including bar, pie, line and scatter. Additional object templates such as html, image, mp4, and iframe are also available. Tabs can be created and visualizations added easily. The tab and visualization layout options are simple but provide powerful flexibility and easy customization. Data source database types include MySQL and MS-SQL*.

*For MS-SQL connection functionality, Viz Mobile Dashboard Builder must be installed within a Microsoft Windows environment with PHP and MySQL support.

Mobile Ready!

Live Demo available at: https://owlhousellc.com/livedemo

Using MySQL, create the viz database and associated credentials. Next, run install_viz.sql found in the install directory. Copy the extracted download contents to your web server root folder. Make sure to include your connection information and credentials in the config.php file.

The default admin credentials are as follows:

 username: admin
 password: admin

The default editor credentials are as follows(no user admin access):

 username: edit
 password: edit

The default view-only credentials are as follows(no edit or user admin access):

 username: demo
 password: demo

For examples/sample data, create a database named sampledb and run the sampledb.sql. Next, run the sample_tabs.sql and sample_visualizations.sql on the viz database. The visualizations will need to be updated with the correct connection/authentication information by clicking on the cog icon, going in to Manage Visualizations, and editing each.

Once the installation is complete, the install directory should be deleted.

Name: The name must be a unique html object name (no spaces or special characters)

Title: Name displayed on the screen

Position: Indicates the order in which the tabs are displayed

Notes: This section is for notes

Name: The name must be a unique html object name (no spaces or special characters)

Title: Name displayed on the screen

Tab: Tab in which you would like visualization to appear

Position: Position on tab which the visualization will appear

Size: Bootstrap width (col-md-4, col-md-6, or col-md-12)

Class: Custom class for visualization

Type: Visualization type (line, bar, scatter, etc.)

DBType: Database Type (MySQL or MS-SQL)

DBHost: Database server name or IP (MS-SQL may require instance name)

DBName: Database name

DBUser: Database username

DBPass: Database password

Query: SQL query (or other "query" information for the visualization type)

Height Override: Customize visualization height (Default 250px)

Date Format Override: D3 date format settings (Default %Y-%m-%d)

Notes: This section is for notes

(Additional Note: In general, the first column in the query result will be the x-axis. The query may need to be adjusted according to the desired outcome.)