In this article we will expand on the “Bells and Whistles” section of our Dashboards. There are multiple ways to alert the user when your data crosses a certain threshold. The most used technique is to change the color of the data depending on whether the data is on the target, above the target or … Read more
Previously we built this Human Resource dashboard using Excel as the data source. The same can be built by putting the data in Google Spreadsheet and then slightly changing the queries. Checkout the entire HR video series for the tutorial In the same note, we replicated the data into a MySQL database so that … Read more
Data comes from variety of sources. It could be your Excel files, Microsoft Access or real SQL databases like MySQL, Oracle, SQL Server, DB2 etc. These databases are used to store information from your ERP, MRP, CRM or Datawarehouses. The data is everywhere and the most challenge is how to consolidate all information in few … Read more
InfoCaptor Enterprise is now available for everybody to build and use dashboards in the cloud. There is no installation or setup required. Just create a login and start using. https://my.infocaptor.com Bottomless visualization options Connection adapters to SQL databases (direct connection, no API needed) Connection adapters to various web applications (twitter, facebook, google spreadsheets, rss, POST, … Read more
This article will explain how to add new Excel File connection Visit http://127.0.0.1:4001/infocaptor/dash/connection_template.php?mode=excel Assuming your excel file is located in the “c:samplestest_data.xls” the following entries are populated “Connection Handle” : This is an identifier for the excel file that will be used in the dashboard so name it appropriately so you can identify. … Read more
Geographical view of Sales by USA states
This USA State map view for sales summary report was built using MySQL Dashboard and Table Chart Builder and adapted as a dashboard reporting plugin for WooCommerce
This Treemap Data visualization for USA States was built using InfoCaptor SQL Dashboard builder and adapted as a comprehensive dashboard plugin for WooCommerce
This Export WooCommerce Order report was built using SQL Dashboard Creator and adapted as a full plugin for woo-commerce reports and dashboard
You should also check out Sales reporting by Country for woocommerce
You should definitely check out the Sales Trending/Analysis/Summary report available within the Ultimate WooCommerce Reporting plugin
Have you ever wondered why some e-commerce stores thrive while others remain stagnant or just fade away? Often, the difference lies not just in the products they sell or the marketing strategies they employ but in the insights they derive from their data. With many business intelligence tools available online, how do you choose the … Read more
Running a WooCommerce e-shop on WordPress comes with its set of challenges, especially when it comes to obtaining detailed insights into your sales and transactions. One specific area that often requires attention is the analysis of sales by payment method. This might seem like a niche requirement, but understanding the nuances of how your customers … Read more