Seeking lightweight open source BI software

  • 9
  • 378
PeerSpot user

8 Answers

Jul 26, 2021

My suggestion is for those who don´t require much coding such as Tableau, Power BI, Cliqsense or Domo. Most of those tools are hosted in the cloud with the exception of Tableau which you may also use on-premises.

Power BI and Tableau are the 2 top-rated according to Gartner Group. Power BI is a good choice if your datasource is in Azure. 

Otherwise, Tableau is more flexible and more powerful regarding visualization features, actions and graphic design. Not to mention the amazing amount of native connectors they provide as you can see here:  Tableau Connectors

I have shallow knowledge of Power BI but I am a specialist in Tableau platform. Feel free to contact me for any help you need.

Search for a product comparison in BI (Business Intelligence) Tools
Jul 26, 2021

It depends on the use case and we provide customers with Cognos Analytics, Power BI and ThoughtSpot. 

If you don't want to employ analysts I suggest ThoughtSpot as it is more of a search-based solution. At Assimil8 we can provide ThoughtSpot as a managed service starting at 25 users so making it cost-effective  

Real User
Top 20
Jul 26, 2021

There are multiple great tools available in the market (SAP BI, Oracle OBIEE, Tableau, IBM Cognos, Power BI, Qlik or Pentaho BI, etc.) to perform reporting with drill up/down, across different functions, displaying charts. 

You can also go with cloud-based tools. It all depends on your data architecture and the team's proficiency to choose that best suits your requirements. 

Real User
Top 20
Dec 11, 2020

It depends on the Data architecture and the complexity of your requirement.

Some great tools in the market are Qlik Sense, Power BI, OBIEE, Tableau, etc. I have recently started using Cognos Enterprise and some of the features that come with this version and the ease to create Dashboards/Explorations/Story Boards are really great. 

One thing to watch out for is the Cost for Cognos Enterprise and if cost is not an issue. I feel Cognos Enterprise is worth trying.

Real User
Dec 10, 2020

There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I would recommend as follows: 

1) If you have legacies of SAP, Oracle  - look for SAP BI (including Excelcius) and OBIEE respectively. Both of them have their own flavour of Dashboard, Information Semantics, Macro Intelligence Universes - with all the features of data drill, user created function developments etc...in built. Pros - Robust, Cons - You need a good practice team to configure your requirements.

2) If you are on MS platform, you can try Power BI. The desktop version is good, rich in features and much at ease with native SQL Server ecosystem 

3) If you have licenses for Tableau, Qlik or Pentaho BI, all of them are equally competitive for the requirements that you have mentioned. Your decision would depend on the licensing investment that you would consider.

4) Self Sustained BI tool - MicroStrategy comes with great features and I have used MicroStrategy for some time.

There are multiple options in Cloud as well...in AWS , I have used Quicksight and been able to drive few reporting requirements that you have mentioned.

Real User
Dec 10, 2020

I've worked on Power BI and OBIEE. I mostly prefer OBIEE, as it has an overall solution to most of the problems addressed or seen in developing reports.

Find out what your peers are saying about Microsoft, Tableau, Amazon and others in BI (Business Intelligence) Tools. Updated: November 2023.
746,635 professionals have used our research since 2012.
Dec 11, 2020

The best and open source (No cost involved) solution for all BI requirements is Jaspersoft Open Studio.

Refer to rajeshsirsikar.com for more information.

Dec 10, 2020

I advise you to try OneStream. This is a very good platform focused on reporting, consolidation and budgeting & forecasting.

BI (Business Intelligence) Tools
Business intelligence (BI) successfully combines business history and software to interpret data to analyze a business’s footprint and create action plans for success in the future. Business intelligence will look at the effects of various business decisions and summarize those effects in easy-to-understand reports, graphs, charts, and summaries.
Download BI (Business Intelligence) Tools ReportRead more

Related Q&As

BI (Business Intelligence) Tools experts

Mir Gulzar Ahmed - PeerSpot reviewer
Joyee Sen - PeerSpot reviewer
ChristopherOrilogbon - PeerSpot reviewer
Syed Fahad Anwar - PeerSpot reviewer
PedroNavarro - PeerSpot reviewer
Kishor Lamdande - PeerSpot reviewer
Kevin McAllister - PeerSpot reviewer
AhmedHaridy - PeerSpot reviewer