How to connect and make dashboard using SQLite database Build beautiful SQLite SQL reporting dashboards This article will address the following topics as well How to create SQLite dashboards ? How to build online reporting dashboards for your business? Easy Dashboard Reporting with SQLite SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional … Read more
How to make dashboard using PostgreSQL database Create beautiful Postgresql reporting dashboards This article will address the following topics as well How to create PostgreSQL dashboards ? How to build online reporting dashboards for your business? Easy Dashboard Reporting with PostgreSQL PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of … Read more
How to create dashboard for MySQL database Make beautiful MySQL SQL reporting dashboards This article will address the following topics as well How to create MySQL dashboards ? How to build online reporting dashboards for your business? Easy Dashboard Reporting with MySQL MySQL is the most popular Open Source SQL database management system. Due to its … Read more
How to create dashboard with SQL Server database Build beautiful SQLserver SQL reporting dashboards This article will address the following topics as well How to create SQL Server dashboards ? How to build online reporting dashboards for your business? Easy Dashboard Reporting with SQL Server Microsoft SQL Server is a relational database management system developed by … Read more
Here are the detailed steps to get connected with Firebird using JDBC and build dashboard with InfoCaptor. Assumptions Make sure Firebird is installed Make sure Firebird server is running Setup SYSDBA user and password (the default password is masterkey) 1. Download Firebird JDBC driver. For this tutorial we have used the 64bit drivers for windows … Read more
From SQL Query to Analysis InfoCaptor is extremely versatile dashboard application. It started initially just as “SQL Dashboard“. What do you mean by “SQL Dashboard”? This was the MVP (minimal viable product) for a Dashboard tool. The basic premise of the idea was that a developer can type any SQL query and produce the information. … Read more
It is possible to pass URL parameters to any SQL widget within the Dashboard. This is useful for drilling from one dashboard widget to a different dashboard. This is also useful when you are drilling from a portal or third party application into InfoCaptor Dashboard. NOTE: when you drill from external application, the dashboard needs … Read more
In the new release of InfoCaptor Enterprise, we added some very useful features. 1. Ability to connect to Postgres SQL 2. Ability to connect to Pervasive database 3. Test Database connections before adding them to the system. Infocaptor works will all types of JDBC and ODBC connections. So if you need to connect to DB2 … Read more
Examine data from different angles and get the “Aha moment!” It is like watching a grainy picture of your business come into focus
InfoCaptor connects to all datasources such as MySQL, PostgreSQL, Oracle, SQL server, SQLite3 and other JDBC /ODBC compliant databases.
This Pivot table analysis of Product Sales report was built using InfoCaptor Business Intelligence application and adapted as one of the most excellent plugin for e-commerce reporting
You should also check out Sankey Diagram analysis of WooCommerce Sales
You should definitely check out the Sales Trending/Analysis/Summary report available within the Advanced WooCommerce Reports Pro plugin