Aug 24, 2019 7 best free business intelligence software. ActivTrak from Birch Grove Software is a flexible BI tool for team behavior analytics. The full system can handle teams from five to 1,000 and is designed for business owners, IT and HR managers, and team leaders who want to track their team’s productivity. Featuring a rich text collaborative editor, inline tagging, images and files, insights, sentiment analysis, a great user experience, and world-class support, Dovetail is cloud research software you'll want to use, all for an affordable price.
These free business intelligence software solutions provide data insights and visualization to take your business to the next level.
https://anvirraju.tistory.com/13. One of the best things about business intelligence (BI) software is that its benefits aren’t restricted by the size of the business using it. Whether you’ve got 10 employees or 10,000, you can still find value from what business intelligence software offers (such as dashboards and ad hoc queries).
One problem, though? Most business intelligence tools are expensive. If you’ve avoided investing in a BI tool because of cost, worry no longer.
Free and open source business intelligence software exists and is a great way for your business to start reaping the benefits of data and analytics at no cost.
Let’s take a look at eight top-rated business intelligence software options in Capterra’s directory. Each of the tools below (presented alphabetically) have an above-average overall user rating (4.5 stars or higher) compared to other products in the same category. They also have 10+ user reviews, and three or more top BI tool features (more on our methodology here).
Where are all the open source business intelligence tools? Unfortunately, at the time of this update, none passed our methodology. If you need an open source option, check out a few BI tools (representative of the players in that space) included at the end of this piece.
Jump to:
ActivTrak
ChartMogul
Cluvio
Databox
Kyubit Business Intelligence
QlikView
Tableau
7 best free business intelligence software
1. ActivTrak
ActivTrak from Birch Grove Software is a flexible BI tool for team behavior analytics. The full system can handle teams from five to 1,000 and is designed for business owners, IT and HR managers, and team leaders who want to track their team’s productivity.
This option can be deployed via the cloud, SaaS, and the web, and offers mobile applications for both iOS and Android. Support for ActivTrak is available online and via phone during business hours.
| Pros | Cons |
|---|---|
| Users rate ActivTrak above average for ease-of-use, and it also receives high marks for customer support. | Users wish that ActivTrak had more functionality, and that the data limit was a little higher on the free version. |
Cost to upgrade: $7.20 per user, per month for access to the entire suite of offered features. Custom plans/pricing available upon request.
Highly rated by: Users who work in IT and services or as systems administrators.
ActivTrak’s business intelligence dashboard (Source)
2. ChartMogul
ChartMogul boasts well-known clients such as Typeform and Docker, which speaks to its ability to handle larger user bases. This software is best for businesses who are trying to build or grow a subscription service, as it can measure churn rate and customer lifetime value.
ChartMogul can be deployed via the cloud, SaaS, and the web. Support is available 24/7 through a live representative and online tutorials. Representatives also offer live online training to help businesses get started.
| Pros | Cons |
|---|---|
| According to reviewers, ChartMogul is extremely easy to use. | ChartMogul scores lower than average among reviewers for functionality. Users cited difficulty importing bulk registrations and lackluster training options. |
Cost to upgrade: $100 per month for full functionality.
Highly rated by: Individuals who work in the computer software industry or as product managers, growth engineers, or customer success agents.
ChartMogul’s business intelligence dashboard (Source)
3. Cluvio
Cluvio is for businesses that have a staff member with a bit of data analytics experience. This software allows businesses to run SQL queries against their databases, can process data in R, and turns out some impressive-looking dashboards and data visualizations.
Cluvio can be deployed via the cloud, SaaS, and the web, and support is offered online or phone during business hours. If businesses need help getting started, the vendor offers webinars and live online training, as well as training materials.
| Pros | Cons |
|---|---|
| Cluvio’s customer support ratings are significantly higher than other solutions in the same category. Reviewers say that the software is extremely easy to use. | Some reviewers wish the software had more functionality. |
Cost to upgrade: $99 per month for a license with unlimited users.
Highly rated by: Data analysts and people who work in the telecommunications, financial services, and e-learning industries.
Cluvio’s business intelligence dashboard (Source)
4. Databox
Databox is the powerhouse of free BI software, scoring high with reviewers in ease-of-use, functionality, and customer support.
Databox allows businesses to track and report on their KPIs through a visually pleasing dashboard, can deliver information across multiple devices, and integrates with popular systems such as Adobe Analytics and Salesforce.
Databox can be deployed via the cloud, SaaS, and the web, and offers mobile applications for iOS and Android.
| Pros | Cons |
|---|---|
| Databox users describe the software as visually pleasing and note that it offers a large number of integrations with other software systems that they use. | Users say they would like to see even more integrations with other software. |
Cost to upgrade: $49 per month for a business plan, and $249 per month for a custom plan.
Highly rated by: Individuals who work in the marketing, advertising, and information technology industries, as well as managers and C-class executives.
In the: Offer only available on presentation of a valid, government-issued photo ID (local law may require saving this information). Restrictions and limitations may apply. Payments are based on the received device matching the description you provided when your estimate was made. More details are available from Apple’s Mac and Apple’s iPhone, iPad, and Apple Watch for trade-in and recycling of eligible devices. What software comes with mac laptop. Apple reserves the right to refuse or limit the quantity of any device for any reason.
Databox’s business intelligence dashboard (Source)
5. Kyubit Business Intelligence
Kyubit Business Intelligence by Kyubit Solutions is a flexible BI tool that allows businesses to create dashboards and reports from their OLAP, SQL, and CSV data. Although this tool is easy to use, the setup makes it best-suited for those who already have some data analytics knowledge or business intelligence training.
Kyubit can be deployed via the cloud, SaaS, the web, or as an installed software solution. Support is available online or during business hours. For the non-tech-savvy user, Kyubit offers training documents to guide you through the software.
| Pros | Cons |
|---|---|
| Users say that Kyubit’s customer support is exemplary and that the software is very easy to use. | Users rate Kyubit lower than average on functionality. |
Cost to upgrade: $695 per user, per year.
Highly rated by: Database administrators, IT consultants, and reviewers who work in the pharmaceutical and computer software industries.
Kyubit Business Intelligence’s dashboard (Source)
6. QlikView
QlikView by Qlik is a BI tool offering ETL (extract, transform, load), data storage, and multi-dimensional analysis. as well as a end-user dashboard. This software’s real value is its ability to connect data sources and create data visualizations and dashboards using that data.
In Xcode, click “File,” select “Open,” and browse to the project or workspace file.If you ran the above commands after opening a new Terminal window, you’ll find the gba4ios folder in your home folder, and the project and workspace files inside it.Connect Your iPhone, iPad, or iPod TouchConnect your iPhone, iPad, or iPod Touch to your Mac with its included USB cable. Click the project’s name on the left, enter a unique name in “Bundle Identifier,” ensure your name is selected as the “Team Name,” and click “Fix Issue.”Build and Install the App on Your iPhone or iPadYou’re now done. You can then click the “Product” menu in Xcode, point to “Destination,” and select the physical device as its build destination.Generate a Code Signing SignatureYou’ll now need to generate a unique code signing signature for the app before you can build and install it. Bbpos ota app mac os. Click the “Play” button at the top-left corner of the Xcode window. Xcode will build the app, install it on your connected device, and launch it.If you see an error, Xcode has had a problem building the app.
QlikView can be deployed via the cloud, SaaS, and the web. The vendor offers phone support during business hours, online support, and provides training through webinars and support documents.
| Pros | Cons |
|---|---|
| Reviewers say that QlikView has great functionality compared to other business intelligence tools. | Users report that QlikView has lower than average customer support and can be a little difficult to use. |
Cost to upgrade: $15 per user, per month.
Highly rated by: BI developers, BI managers, and people who work in the civic and social organization industry.
QlikView’s business intelligence dashboard (Source)
7. Tableau
Tableau business intelligence software is for people who love Excel’s pivot tables. Or, at least, love the concept of pivot tables. Tableau boasts a streamlined user interface that allows drag-and-drop data manipulation, and data visualizations.
This software can be deployed via the cloud, SaaS, and the web, or installed on your desktop. It also offers mobile applications for iOS or Android.
Training is available in-person, online with a representative, through webinars, and with documentation. Support is available online and via phone during business hours.
While the free version doesn’t secure user data, upgrading allows users to gain access to some top-of-the-line data governance and security features.
| Pros | Cons |
|---|---|
| Tableau scores higher than average among Capterra’s reviewers for functionality. | Reviewers say Tableau’s customer support is a little lackluster, and that the product can be difficult to use. |
Cost to upgrade: $70 per user, per year.
Highly rated by: Students, business analysts, and people who work in the education industry.
Tableau’s business intelligence dashboard (Source)
Where’s the open source business intelligence software?
Unfortunately, no open source (OS) business intelligence software passed our rigorous methodology at the time of this update (primarily due to a lack of sufficient reviews). Here’s a list of open source software solutions that represent players in that space. While they don’t have very many reviews yet, they look promising:
- Pentaho Business Analytics: This OS business intelligence software from Hitachi Vantara has all four of the features we looked for in our free BI software, and has a relatively high rating from users on Capterra.
- ReportServer: This OS BI platform doesn’t have many reviews yet, but has all four features required for our free BI software list above, and an impressive list of deployment options. This system is not free; its one-time download fee will cost you $2,000.
Do you need your business intelligence software to do something other than what the tools above offer?
Feature descriptions
Below are descriptions of the software functionality referenced in the product write-ups above:
| Ad hoc reports | Generate reports that meet your ever-changing information requirements, as needed. |
|---|---|
| Dashboard | An assembly of graphs and charts for tracking statistics and metrics. |
| Key performance indicators | Critical metrics by which company/employee performance is tracked and evaluated. |
| Visual analytics | Interact with data visualization elements (such as charts and graphs) to drill down into your data. |
Methodology
This article was updated on July 11, 2019. Products considered for this article had to:
- Offer a free, stand-alone version of the software (not a trial version of the software where you must purchase a product after a limited amount of time).
Software that met the market definition also needed a minimum of 10 user-submitted reviews published between May 31, 2018 – July 2, 2019, and have an above-average overall user rating compared to other products in the category.
- “Top” free tools had a minimum overall rating of 4.5/5 stars from reviewers on Capterra at the time of publication.
Note: The content in this piece that provides opinions and points of view expressed by users does not represent the views of Capterra.
The applications selected in this article are examples to show a feature in context and are not intended as endorsements or recommendations. They have been obtained from sources believed to be reliable at the time of publication.
Looking for Business Intelligence software? Check out Capterra's list of the best Business Intelligence software solutions.
Analysis of Competing Hypotheses Software -- http://www2.parc.com/istl/projects/ach/ach.html
Analysis of Competing Hypotheses (ACH) is a simple model for how to think about a complex problem when the available information is incomplete or ambiguous, as typically happens in intelligence analysis. The software downloadable here takes an analyst through a process for making a well-reasoned, analytical judgment. It is particularly useful for issues that require careful weighing of alternative explanations of what has happened, is happening, or is likely to happen in the future. It helps the analyst overcome, or at least minimize, some of the cognitive limitations that make prescient intelligence analysis so difficult. ACH is grounded in basic insights from cognitive psychology, decision analysis, and the scientific method. It helps analysts protect themselves from avoidable error, and improves their chances of making a correct judgment.
This software was developed by Palo Alto Research Center (PARC) in collaboration with Richards J. Heuer, Jr. It was developed for use by the U.S. Intelligence Community with funding from the Intelligence Community's Advanced Research and Development Activity (ARDA) and the Office of Naval Research (ONR).
In distributing ACH, PARC is making the presently downloadable version of the program available to the general public at no cost when used for non-commercial or educational purposes subject to the terms and conditions of its end user license.
CARVER2 - Target Analysis Software -- http://www.ni2cie.org/CARVER2.asp
CARVER2, a free software tool that provides a non-technical method of comparing and ranking critical infrastructure and key resources. It is the only assessment tool that ranks critical infrastructure across sectors.
The CARVER2 vulnerability assessment tool is designed to quickly and easily identify and compare potential natural disaster and/or terrorist targets at the local, state and national levels in order to assist government officials in the allocation of protective resources. The CARVER2 target analysis tool is available free of charge to federal, state, and local government officials and agencies, as well as non-profit and educational institutions. See below to request the installation package.
Computer Online Forensic Evidence Extractor -- https://cofee.nw3c.org/
Microsoft COFEE is being made available to individuals employed by law enforcement agencies within the United States and Canada. COFEE means the Computer Online Forensic Evidence Extractor tool that fits on a USB drive and automates the execution of commands for data extraction and related documentation. Distribution is limited to law enforcement agencies. Access to the COFEE product requires verification of employment with a law enforcement agency and agreement to the terms and conditions of the Microsoft/NW3C Sublicense Agreement. The verification process is automated if you have an email account with RISS.NET or LEO.GOV, or have an account with NW3C.
Computer Security Evaluation Tool -- http://www.us-cert.gov/control_systems/satool.html
The Department of Homeland Security (DHS) has released its latest cyber system assessment tool to the Critical Infrastructure/Key Resources (CI/KR) community. The Computer Security Evaluation Tool (CSET) is a desktop software tool that guides users through a step-by-step process to evaluate their cyber systems and network security practices against recognized industry standards.
According to DHS, the benefits of CSET include:
- Contributing to an organization's risk management and decision-making process;
- Raising awareness and facilitating discussion on cyber security within the organization;
- Highlighting vulnerabilities in the organization's systems and providing recommendations on ways to address those vulnerabilities;
- Identifying areas of strength and best practices being followed in the organization;
- Providing a method to systematically compare and monitor improvement in the cyber systems; and
- Providing a common industry-wide tool for assessing cyber systems.
CrimeStat III -- http://www.icpsr.umich.edu/CrimeStat/
CrimeStat III is a spatial statistics program for the analysis of crime incident locations, developed by Ned Levine & Associates under the direction of Ned Levine, PhD, that was funded by grants from the National Institute of Justice. The program is Windows-based and interfaces with most desktop GIS programs. The purpose is to provide supplemental statistical tools to aid law enforcement agencies and criminal justice researchers in their crime mapping efforts. CrimeStat is being used by many police departments around the country as well as by criminal justice and other researchers. The latest version is 3.3. The program inputs incident locations (e.g., robbery locations) in 'dbf', 'shp', ASCII or ODBC-compliant formats using either spherical or projected coordinates. It calculates various spatial statistics and writes graphical objects to ArcGIS®, MapInfo®, Surfer for Windows®, and other GIS packages.
Comprehensive R Archive Network -- http://cran.r-project.org/
Comprehensive R Archive Network a freely available language and environment for statistical computing and graphics which provides a wide variety of statistical and graphical techniques: linear and nonlinear modelling, statistical tests, time series analysis, classification, clustering, etc.
Decrypto is a fast and automated cryptogram solver by Edwin Olson. It can decode word games often found in newspapers, including puzzles like cryptoquips and patristocrats. You can also download a stand-alone version. [We have also found this program useful for quickly breaking simple substitution ciphers used by some criminal gangs.]
Encryption Wizard (EW) DoD Software Protection Initiative -- http://spi.dod.mil/ewizard.htm
EW is an SPC implementation of the Advanced Encryption Standard (AES) (Rijndael) augmented with a file manager Graphical User Interface (GUI) for ease of use. The 128-bit encryption/decryption algorithm used by Encryption Wizard is considered cryptographically strong and is routinely used in National Security Agency (NSA) and National Institute of Standards and Technology (NIST) certified products. Encryption Wizard is designed to protect data at rest and in transit (such as email attachments). EW is an easy to use tool for protecting sensitive (but not classified) documents, and for protecting files before transmission via email. It allows a user to encrypt files using a 128-bit implementation of the Advanced Encryption Standard (AES) with simple drag-and-drop efficiency. Encryption Wizard can significantly increase an organization‘s security posture at little to no cost to protect sensitive data in transit (E-mail, FTP, or shared web folders) or at rest on a removable storage device. The primary version for government users utilizes a FIPS 140-2 validated encryption engine licensed from RSA
Mac Swot Analysis
•An improved analytical approach that will make consequence, vulnerability, and likelihood of occurrence assessments of threats more transparent; and
•A natural disaster assessment process supported by historical information to enable likelihood determinations.
NOTE: Although designed for water system vulnerabilities, VSAT is highly applicable to other types of risk analysis.
Google Earth -- http://www.google.com/earth/index.html
Google Earth lets you view satellite imagery, maps, terrain, 3D buildings, galaxies in outer space, and the depths of the ocean.
Near Repeat Calculator -- http://www.temple.edu/cj/misc/nr/
This software originates with the relatively recent discovery of the near repeat phenomenon in burglary patterns, a discovery that has highlighted the communicability of crime events that affect the risk level at nearby locations. The near repeat phenomenon states that if a location is the target of a crime (such as burglary), the homes within a relatively short distance have an increased chance of being burgled for a limited number of weeks (Townsley et al, 2003; Bowers and Johnson, 2004; Johnson and Bowers, 2004a, 2004b). This communicability of risk to nearby locations for a short amount of time raises the possibility that other crime types may also suffer from a near repeat spatio-temporal pattern of behavior.
The analytical method employed builds on a space-time clustering methods first pioneered by Knox (1964) to study the epidemiology of childhood leukemia. The Knox test seeks to determine whether there are more event-pairs observed that occur with a closer proximity in space and time than would be expected on the basis of a random distribution. To do this, each shooting for a particular dataset is compared with every other and the spatial and temporal distance between them recorded. The result is a matrix of space-time distances.
To establish a null hypothesis measure against which to test the shooting patterns, we employ a Monte Carlo simulation process. By computing multiple simulations of the expected values, it is possible to generate an expected distribution under a null hypothesis – using the actual study data. This provides a unique way to examine what would occur if there were no near repeat patterns.
Problem Analysis Module -- http://www.popcenter.org/learning/pam/
Problem Analysis Module (PAM) gives you a framework for analyzing any persistent crime and public safety problem. PAM will ask you to input information concerning every aspect of the problem and then suggest the kinds of responses you could try. PAM was developed to assist police problem solving through the asking of specific questions. The questions come from research into a set of powerful theories within the field of Environmental Criminology – particularly Routine Activity Theory, Situational Crime Prevention, and Crime Pattern Theory.
BAIR’s free public crime map, RAIDS Online, connects law enforcement with the community to reduce crime and improve public safety. RAIDS Online is absolutely free to law enforcement and the public! RAIDS On-line’s public crime map works with any RMS to allow law enforcement to share crime data with the public through an easy-to-use online crime map and analytics dashboard. The data is displayed with 8 fields of limited offense information to protect victim privacy. This is a valuable tool for law enforcement to communicate crime activity to their citizens and the media.
Intelligence Analysis Software For Mac Free
SketchFace -- http://sketchface.com/
Created by Ali Daneshmandi, SketchFace is a free web application for creating photo-realistic facial composite pictures.
The program compares two or more courses of action based on two or more evaluation criteria. The user arranges the evaluation criteria in descending order of importance and tells the program how much more important each criterion is than the next lower criterion. These importance ratings are used to calculate weights for each criterion. SquidMat takes user-supplied values for each course-of-action/criterion combination and converts them to Z scores. Using the criterion weights, the program calculates weighted sums for each course of action. The course of action with the highest weighted sum is considered to be the best. SquidMat is designed as a replacement decision matrix program for the CAS3 program DECMAT.
Freddie Mac Analysis