Title: WP Business Intelligence Lite Author: joeyoungblood Published: ಮೇ 1, 2013 Last modified: ಜನವರಿ 1, 2023 --- Search plugins ![](https://ps.w.org/wp-business-intelligence-lite/assets/banner-772x250.png?rev =1854290) This plugin **hasn’t been tested with the latest 3 major releases of WordPress**. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress. ![](https://ps.w.org/wp-business-intelligence-lite/assets/icon.svg?rev=1852652) # WP Business Intelligence Lite ‍[joeyoungblood](https://profiles.wordpress.org/joeyoungblood/) ಮೂಲಕ [ಡೌನ್ಲೋಡ್](https://downloads.wordpress.org/plugin/wp-business-intelligence-lite.3.2.0.zip) * [Details](https://kn.wordpress.org/plugins/wp-business-intelligence-lite/#description) * [‍ವಿಮರ್ಶೆಗಳು‍](https://kn.wordpress.org/plugins/wp-business-intelligence-lite/#reviews) * [Installation](https://kn.wordpress.org/plugins/wp-business-intelligence-lite/#installation) * [Development](https://kn.wordpress.org/plugins/wp-business-intelligence-lite/#developers) [‍ಬೆಂಬಲಿಸಿ](https://wordpress.org/support/plugin/wp-business-intelligence-lite/) ## ವಿವರಣೆ 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, donut, line, or grouped bar) 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](http://www.wpbusinessintelligence.com/support) [WP Business Intelligence Demos](http://www.wpbusinessintelligence.com/demos) In order to use your own live MySQL, MS SQL, or PostgreSQL database with WP Business Intelligence, purchase the Pro version of WP Business Intelligence from the [WP Business Intelligence web site](http://www.wpbusinessintelligence.com) We are actively developing this plugin and would love to hear from you with feature requests. [Contact Us.](http://www.wpbusinessintelligence.com/contact/) Some icons provided by [Font Awesome](https://fontawesome.com/license) #### 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](https://eventbrite.github.io/britecharts/tutorial-kitchen-sink.html) 5. Tables build on [Datatables](https://datatables.net/) ## Screenshots * [[ * [Create and test a bar chart (click to enlarge)](http://www.wpbusinessintelligence.com/wp-content/uploads/2021/01/wpbusinessintelligence-screenshot-1.png) * [[ * [Create and test a donut chart (click to enlarge)](http://www.wpbusinessintelligence.com/wp-content/uploads/2021/01/wpbusinessintelligence-screenshot-2.png) * [[ * [Create and test a data table (click to enlarge)](http://www.wpbusinessintelligence.com/wp-content/uploads/2021/01/wpbusinessintelligence-screenshot-3.png) * [[ * [Embed charts in a post (click to enlarge)](http://www.wpbusinessintelligence.com/wp-content/uploads/2021/01/wpbusinessintelligence-screenshot-4.png) * [[ * [Connect and query your database (click to enlarge)](http://www.wpbusinessintelligence.com/wp-content/uploads/2021/01/wpbusinessintelligence-screenshot-5.png) ## 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 ## ‍ವಿಮರ್ಶೆಗಳು‍ ![](https://secure.gravatar.com/avatar/2682527c6dd8aa6c5f77efea831ca35a61b79540512136f2724bf83a372b94b9? s=60&d=retro&r=g) ### 󠀁[not working](https://wordpress.org/support/topic/not-working-4199/)󠁿 [shiva2019](https://profiles.wordpress.org/shiva2019/) ಫೆಬ್ರವರಿ 9, 2024 I installed this plugin and it’s not work. I see error in any admin page of this plugin: [Unknown column ‘library’ in ‘wpt_wpbi_grouped_bar_charts’] ALTER TABLE wpt_wpbi_grouped_bar_charts ADD COLUMN in_dash TINYINT(1) DEFAULT 0 NOT NULL AFTER library For testing I install on new database after install Wordpress and nothing changed. I see the same errors..and because I can’t create any chart..nothing happens after create.. ![](https://secure.gravatar.com/avatar/23f4073656c1bf85a4b9fb7549925689c6beeac4b07844a2329a42a538532594? s=60&d=retro&r=g) ### 󠀁[Wonderful solution for charts and tables](https://wordpress.org/support/topic/wonderful-solution-for-charts-and-tables/)󠁿 [miquelpontes](https://profiles.wordpress.org/miquelpontesgmailcom/) ಮಾರ್ಚ್ 29, 2021 1 reply Being a long time user of the Lite version of this plugin, I find it very useful. I can generate beautiful responsive charts in my Wordpress wildlife website, from a custom table and parametrized for every post in our site. Best part of all this is the new development team, friendly, fast and efficient, solved a problem appeared in the last major revision pretty quickly. Happy user ! ![](https://secure.gravatar.com/avatar/5d5977670c35de4095b4d88516f66d292085edb0c9930ac751612c4dde41f5cc? s=60&d=retro&r=g) ### 󠀁[Problems Getting Fixed, Great Charts!](https://wordpress.org/support/topic/problems-getting-fixed-great-charts/)󠁿 [joeyoungblood](https://profiles.wordpress.org/joeyoungblood/) ಮಾರ್ಚ್ 29, 2021 As a long-time user of this plugin I had been dismayed with how it had eroded in recent years. A few months ago the developer and I reached an agreement for me to take over the plugin so my team and I could start making updates. Since December of last year we have fixed all of the known bugs in the display of the charts, fixed the tooltip display, introduced more free charts for WP users, fixed a handful of database query bugs, added a feature to give your charts and graphs a name, added animation to all charts and graphs, and added a feature to give charts and graphs a caption. This is only the beginning of our updates, but after 3 months of hardwork the issues with this plugin that were breaking reporting dashboards for us and our clients have now been fixed. We have an aggressive roadmap to bring more charts, features, and functionality to both the free and paid version of this plugin and I am excited to keep using it to build business intelligence dashboards and to display in-depth data on our clients websites. ![](https://secure.gravatar.com/avatar/5f7f62cee90ae21300e2fe5bf7b99a488c5daf918e874e93b5b423fc3551b489? s=60&d=retro&r=g) ### 󠀁[Disappointed long time user](https://wordpress.org/support/topic/disappointed-long-time-user/)󠁿 [](https://profiles.wordpress.org/j-dimension/) ಜುಲೈ 1, 2018 1 reply I have been using the pre- 3.x version for a very long time (free version, but reached out to the developer and donated). Sadly, I have to say that version 3 is several steps backward… just to name a few points: – no line charts anymore – no names for charts, just IDs (which makes them hard to identify) – very limited parameterization of charts and tables – SQL column to small – need to create views for most queries.– some charts do not appear at all, without any feedback / error message – layout issues across the board – the more entities you have, the more issues with layout– it really is unusable for larger datasets – bar charts with no tooltiptext – … I could continue for a while. With all this working in previous versions, I am really disappointed. It always feels bad when version-up reduces functionality. ![](https://secure.gravatar.com/avatar/80228b351f777a11dc62695eed576ac92571e01ca1dc1016f17e7bb9eee9d129? s=60&d=retro&r=g) ### 󠀁[Not working and crashes WordPress](https://wordpress.org/support/topic/not-working-and-crashes-wordpress/)󠁿 [shakarum](https://profiles.wordpress.org/shakarum/) ಮೇ 23, 2018 1 reply 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.” ![](https://secure.gravatar.com/avatar/3019192ecd948b92dae7a04d096c7c304e9eab1ef764329d482c4ca5d1bb3e18? s=60&d=retro&r=g) ### 󠀁[not bad](https://wordpress.org/support/topic/at-last-26/)󠁿 [RaybanMonster](https://profiles.wordpress.org/paulds11/) ಜುಲೈ 22, 2018 Thanks [ Read all 10 reviews ](https://wordpress.org/support/plugin/wp-business-intelligence-lite/reviews/) ## Contributors & Developers “WP Business Intelligence Lite” is open source software. The following people have contributed to this plugin. ಕೊಡುಗೆದಾರರು * [ joeyoungblood ](https://profiles.wordpress.org/joeyoungblood/) [Translate “WP Business Intelligence Lite” into your language.](https://translate.wordpress.org/projects/wp-plugins/wp-business-intelligence-lite) ### Interested in development? [Browse the code](https://plugins.trac.wordpress.org/browser/wp-business-intelligence-lite/), check out the [SVN repository](https://plugins.svn.wordpress.org/wp-business-intelligence-lite/), or subscribe to the [development log](https://plugins.trac.wordpress.org/log/wp-business-intelligence-lite/) by [RSS](https://plugins.trac.wordpress.org/log/wp-business-intelligence-lite/?limit=100&mode=stop_on_copy&format=rss). ## Changelog #### 3.2.0 * Admin menu icon added * Home page added * Compatible with PHP8.0 and WP6.1 * Chart.js charts added to scope * Database connection menu name changed * WordPress Data Connections added #### 3.1.9 * Session optimization for WordPress #### 3.1.8 * DB update condition added #### 3.1.7 * New migration directory #### 3.1.6 * Charts DB tables migration condition added #### 3.1.5 * Name, Caption, Tooltip added to charts #### 3.1.4 * New Charts added #### 3.1.3 * Chart version updated #### 3.1.2 * Increase length of queries #### 3.1.1 * PostgreSQL support in pro version * Test on latest WordPress (5.1.1) * Improve loading of scripts when jQuery is not yet loaded #### 3.1.0 * Microsoft SQL Server support in pro version * Minor changes that should make things more robust * Added testing for PHP 7.2, 7.0 * Added testing for MyISAM (InnoDB was already tested) * Added testing for MySQL 5.5, 5.7, 8.0 * Added testing for MariaDB 5.5, 10.3 #### 3.0.10 * Minor bug fix: initial order of datatable defaulted to ordering by first row * tested up to WordPress 4.9.8 #### 3.0.9 * Remove automatically calculated timestamps because of db version inconsistencies( and because they were not used) #### 3.0.8 * Add more info for debugging initial installation * Minor fixes to this file * Minor improvements to tests #### 3.0.7 * fix issue with php 5.6 compatibility #### 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.5 * php 5.6.0 support #### 3.0.4 * More verbose error logging if plugin cannot be activated * Disable plugin if there are issues connecting to database #### 3.0.3 * Prevent old versions of PHP and WordPress from using this plugin #### 3.0.2 * Bug fix for users who upgraded with legacy table #### 3.0.1 * Workaround bug where britecharts chooses the wrong colors for grouped bar charts #### 3.0.0 * Complete rewrite. Backward incompatible with previous version. * Use Britecharts instead of directly using d3 * Update to Datatables 1.10 #### 1.6.7 * rollback table.tpl for compatibility issues #### 1.6.6 * bug fix in table pagination #### 1.6.4 * color class renamed to wpbi_color * add_query_arg escaped to fix vulnerability #### 1.6.3 * SQL injection vulnerability fix enhanced #### 1.6.2 * SQL injection vulnerability fixed #### 1.6.1 * Validated on WP 4.1.1 * Error message added in case of no data #### 1.6 * Bug on iframe fixed * X and Y labels added * Validated on WP 4.0 #### 1.5 * Added possibility to download charts and tables data * Charts and table download as PDF or image * Additional controls on charts #### 1.4 * Charts and tables IDs are shown in the dashboard #### 1.3 * Removed file with potential vulnerability #### 1.2.1 * Missing include added to includes.php #### 1.2 * Some major bug fixes and support of click event on bar chart (example for developers to be extended to other charts) #### 1.1 * Security vulnerability fixed and control over bar charts color added. #### 1.0.7 * Added support for text labels to line charts #### 1.0.6 * Renamed button registration function to avoid conflicts with other themes #### 1.0.5 * TinyMCE button registration warning fixed. * Donut chart added * Version 1.1.13 of NVD3 integrated #### 1.0.4 * Bug fix with queries pagination #### 1.0.3 * Code was cleaned up to remove some warnings #### 1.0.2 * First integration of “DataTables” tables #### 1.0.1 * Fixes on JS inclusion and icon chart #### 1.0 * First beta release ## ಮೆಟಾ * Version **3.2.0** * ಕೊನೆಯದಾಗಿ ನವೀಕರಿಸಿದ್ದು **3 ವರ್ಷಗಳು ರ ಮುನ್ನ** * Active installations **60+** * WordPress version ** 4.4.0 or higher ** * Tested up to **6.1.10** * PHP version ** 5.6.0 or higher ** * Language * [English (US)](https://wordpress.org/plugins/wp-business-intelligence-lite/) * ಟ್ಯಾಗ್‌ಗಳು * [charts](https://kn.wordpress.org/plugins/tags/charts/)[D3](https://kn.wordpress.org/plugins/tags/d3/) [mysql](https://kn.wordpress.org/plugins/tags/mysql/)[sql](https://kn.wordpress.org/plugins/tags/sql/) [tables](https://kn.wordpress.org/plugins/tags/tables/) * [Advanced View](https://kn.wordpress.org/plugins/wp-business-intelligence-lite/advanced/) ## Ratings 3.9 out of 5 stars. * [ 7 5-star reviews ](https://wordpress.org/support/plugin/wp-business-intelligence-lite/reviews/?filter=5) * [ 0 4-star reviews ](https://wordpress.org/support/plugin/wp-business-intelligence-lite/reviews/?filter=4) * [ 0 3-star reviews ](https://wordpress.org/support/plugin/wp-business-intelligence-lite/reviews/?filter=3) * [ 1 2-star review ](https://wordpress.org/support/plugin/wp-business-intelligence-lite/reviews/?filter=2) * [ 2 1-star reviews ](https://wordpress.org/support/plugin/wp-business-intelligence-lite/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/wp-business-intelligence-lite/reviews/#new-post) [See all reviews](https://wordpress.org/support/plugin/wp-business-intelligence-lite/reviews/) ## ಕೊಡುಗೆದಾರರು * [ joeyoungblood ](https://profiles.wordpress.org/joeyoungblood/) ## ‍ಬೆಂಬಲಿಸಿ Got something to say? Need help? [View support forum](https://wordpress.org/support/plugin/wp-business-intelligence-lite/) ## ದೇಣಿಗೆ ನೀಡಿ Would you like to support the advancement of this plugin? [ Donate to this plugin ](http://www.wpbusinessintelligence.com/products-and-services/pricing)