Use the complete Business Intelligence tool for free : We are offering fully functional license of InfoCaptor Enterprise for zero dollars. That makes us the cheapest dashboard application out there. InfoCaptor is available for all platforms Windows, Linux and Mac OS. We ship the package in a starter portable web server and also provide complete instructions to install on your choice of web server (apache, nginx). Here are the details on the download type and how to acquire the free dashboard license.
Once you install InfoCaptor, upon launch it will take you to the self checkout Free license server. We have made it everything frictionless as much we could so that you can quickly install and start using. The license generation is also self checkout and there is no sales person to talk to. In fact once you checkout, we give you the license codes right there in the same screen [ yes, no need for providing fake or throwaway email address]
What is included in the Business Intelligence application?
InfoCaptor has grown rapidly in the past few years. Earlier it was just a SQL Dashboard where you manually typed in SQL queries to build dashboards with all drill downs and chart types. Next we added Tableau like Visualizer where you can drag and drop columns to build analysis and easily publish to dashboards. Next we added an embedded Micro ETL and Data-warehouse with built-in connectors for Google Analytics and Sales force (more coming soon).
In a nut shell, here is a very high level view of InfoCaptor as Business Intelligence tool
The complete stack of InfoCaptor makes it extremely desirable Analytics and Dashboard application. Our regular pricing for enterprise is extremely affordable and cheap but now with our Free offering it is the cheapest dashboard tool.
Who can use the Free Dashboard Software
For now we have decided to offer free license to the following groups
This is not a community edition or some kind of restricted software. It is the same version of InfoCaptor Enterprise edition that we hosted for our online dashboard service and it is the same edition you get if you had paid for. The difference is that we are simple giving away free bi tools licenses to the above select groups (Startups, Non Profits and Students).
It is futile fighting Excel for basic reporting and pivot tables. For single user system it is a practical approach. In principle, we don't like the idea of data and presentation sitting in the same excel file so as you grow your reporting requirements to interacting and distributing to more than one person, we recommend to switch to a flexible and easy dashboard solution. You can still keep all your data in Excel but report and dashboard in a web based reporting solution. InfoCaptor provides pivot table mechanism that users of Excel will find it very handy and convenient. So effectively it is still Excel based dash boarding but you are keeping your data and presentation separate.
InfoCaptor supports JDBC connections to Cloudera Impala, Hive Database and Mapr Drill db. You could install InfoCaptor on one of the Hadoop edge node and integrate using the connectors.
Yes, you can connect using ODBC to Microsoft Access .mdb file or .accdb file. The only requirement is that it works only on Windows.
There is no limit. You can upload and convert as many CSV files as needed.
The question should be "How much capacity and time do you have to track?", Do you think QuickBooks and other systems you are using provide all the needed metrics for you to grow? Is there anything else you could be tracking to speed your growth engine? How much time is wasted logging in and out of systems to track different metrics?
For startups and small businesses, optimization and automation is the key. Optimization provides Agility so that you can produce more with less. Startups are always time-crunched so measuring and monitoring is always pushed back. We have seen that if your startup is less than 5 people then you probably don't need dashboard or analytics. The time investment would be hard to justify over other priorities. In that case you could use our online data visualization which is also free.
No. All data reside on your own servers. We do not have access to it.
You can build a dashboard and each analysis can be sourced by data from different database.
Yes, you need to know how to join the two tables using SQL and then copy the SQL into the Data source. The next step will present you combined columns from both tables and you continue as if it were one table.
Absolutely yes! There are many recipes for building dashboards within InfoCaptor. Unlike Tableau, InfoCaptor works directly with the database. One recipe would be to use SQL queries and build the analysis yourself. Another recipe would be to point at the table, use the data Visualizer, drag drop dimensions and metrics, pick your chart type and be done. If you like the analysis simply push the button to publish into online dashboards. So a person with no SQL knowledge can easily work with InfoCaptor to produce simple and beautiful dashboards. The data Visualizer generates the necessary SQL in the back end.
At a high level we say InfoCaptor provides 70% of the functionality that you would find in established BI tools like Tableau, Qlikview etc. If you can show us a Tableau dashboard, you can build similar or better dashboard within InfoCaptor. InfoCaptor started as a dashboard only application so it does provide dynamic parameters, drill downs and so many HTML5 widgets. It was built on top of a wireframing and mockup engine. On the data-visualization front, it incorporates d3js charting library and provides a consistent behavior across all visualizations. InfoCaptor lacks the Geo visualization within the Visualization Editor but it provides the Geo vector maps within the dashboard editor.
Remember, InfoCaptor is a comprehensive BI application that includes Dashboards + Visualization + Analytics + Data Warehouse so this would get quite lengthy.
Use SQL Dashboards: With the growing role of Data Science, Analysts and Data Scientists come equipped with the knowledge of SQL for data analysis. InfoCaptor provides bare metal framework just for that. Plug your SQL queries and present them into any widget. Link different widgets for drill down purpose.
Use Pivot Tables for operational reporting : InfoCaptor visualization is very advanced and works on the same principle of pivot tables. This provides consistent behavior across all visualization types. One of the fundamental viz type is pivot table. What makes pivot tables different from Tableau is it provides sub-totals and grand totals. In the dashboard editor there are other widgets such as html grid that can do any custom presentation you may require. Like calling stored procedures from MySQL, SQL server, Oracle etc.
Use Google Analytics connector: You can start collecting your website traffic data into your mysql db and then merge it with finance data from other systems to create better co-relation of data. You can check our own live Google Traffic dashboard
Use as Personal Dashboard: Export your Fitbit or smartwatch data into CSV and hook it up with InfoCaptor. You can upload CSV to MySQL or just perform a onetime analysis using the data Visualizer.
Use as Social Media Dashboard: We provide the Google Analytics connector and you could use InfoCaptor as a dashboard framework to bring in data from other social media into MySQL tables. We will be adding more social connectors in the future but in the mean time you could use other open source python or php based connectors to bring data from other platforms.
InfoCaptor dashboards are extremely customizable. Below you will find several combinations of background patterns, best color themes/templates, different data connections including SQL and non SQL sources.