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.)