WP Business Intelligence Lite

Description

WP Business Intelligence Lite allows you to powerfully display responsive data tables and charts on your website. This plugin is simple to use and allows you to connect with your wordpress database and display the data in real time. Once you have created at least one SQL query that retrieves data from your DB, you can define the type of chart (bar or pie) or table to be used to display them. A simple shortcode embeds the chart or table in any post or page. Each page refresh retrieves the data from the DB so that the information in the chart or table is always up-to-date.

Installation guide, FAQs and support can be found at WP Business Intelligence Support

WP Business Intelligence Demos

In order to get full advantages from WP Business Intelligence, you can get WP Business Intelligence Pro or Enterprise from the WP Business Intelligence web site

We are actively developing this plugin and would love to hear from you with feature requests. Contact Us.

Features

  1. Live connection to your WordPress DB via custom SQL queries
  2. Responsive charts/tables
  3. Works in Chrome, Firefox, IE9+
  4. Charts based on Britecharts
  5. Tables build on Datatables

Installation

  1. Upload the uncompressed folder wp-business-intelligence-lite to the /wp-content/plugins/ directory
  2. Activate the plugin through the ‘Plugins’ menu in WordPress.

or

  1. Upload the wp-business-intelligence-lite.zip file via the ‘Plugins->Add New’ page of your WordPress dashboard
  2. Activate the plugin through the ‘Plugins’ menu in WordPress.

FAQ

Installation Instructions
  1. Upload the uncompressed folder wp-business-intelligence-lite to the /wp-content/plugins/ directory
  2. Activate the plugin through the ‘Plugins’ menu in WordPress.

or

  1. Upload the wp-business-intelligence-lite.zip file via the ‘Plugins->Add New’ page of your WordPress dashboard
  2. Activate the plugin through the ‘Plugins’ menu in WordPress.

Reviews

Not working and crashes WordPress

After I installed the plugin and tried to activate it, WP crashed and I got the message –
“A catastrophic error has occurred such that WP Business Intelligence cannot run.”

At last!!!!

Thank god at last. We will be coming to splash money soon on the pro and some additional services. This is the only credible live database solution available. Good job, well done.

Read all 6 reviews

Contributors & Developers

“WP Business Intelligence Lite” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

1.0

  • First beta release

1.0.1

  • Fixes on JS inclusion and icon chart

1.0.2

  • First integration of “DataTables” tables

1.0.3

  • Code was cleaned up to remove some warnings

1.0.4

  • Bug fix with queries pagination

1.0.5

  • TinyMCE button registration warning fixed.
  • Donut chart added
  • Version 1.1.13 of NVD3 integrated

1.0.6

  • Renamed button registration function to avoid conflicts with other themes

1.0.7

  • Added support for text labels to line charts

1.1

  • Security vulnerability fixed and control over bar charts color added.

1.2

  • Some major bug fixes and support of click event on bar chart (example for developers to be extended to other charts)

1.2.1

  • Missing include added to includes.php

1.3

  • Removed file with potential vulnerability

1.4

  • Charts and tables IDs are shown in the dashboard

1.5

  • Added possibility to download charts and tables data
  • Charts and table download as PDF or image
  • Additional controls on charts

1.6

  • Bug on iframe fixed
  • X and Y labels added
  • Validated on WP 4.0

1.6.1

  • Validated on WP 4.1.1
  • Error message added in case of no data

1.6.2

  • SQL injection vulnerability fixed

1.6.3

  • SQL injection vulnerability fix enhanced

1.6.4

  • color class renamed to wpbi_color
  • add_query_arg escaped to fix vulnerability

1.6.6

  • bug fix in table pagination

1.6.7

  • rollback table.tpl for compatibility issues

3.0.0

  • Complete rewrite. Backward incompatible with previous version.
  • Use Britecharts instead of directly using d3
  • Update to Datatables 1.10

3.0.1

  • Workaround bug where britecharts chooses the wrong colors for grouped bar charts

3.0.2

  • Bug fix for users who upgraded with legacy table

3.0.3

  • Prevent old versions of PHP and WordPress from using this plugin

3.0.4

  • More verbose error logging if plugin cannot be activated
  • Disable plugin if there are issues connecting to database

3.0.5

  • php 5.6.0 support

3.0.6

  • do not use with php 5.6
  • test on WordPress 4.9.6
  • update dependencies to work better with old versions of php
  • improve similarity of tables created with default wp tables (collation and charset)
  • fix startup failing on MySQL 5.6 if using mb4 by default
  • fix bug if InnoDB does not exist

3.0.6

  • fix issue with php 5.6 compatibility