2

I'm looking for an open source (and free) alternative for Business Intelligence Software. The reason I'm looking for an open source alternative is because I'm working on an application involving the use of such an software (to retrieve and analyze data) and want to use an open source software with such features as an reference or perhaps as a base that I can modify.

To be more specific I want to retrieve data stored in a database or similar, and then work with the data to present it in a understandable manner. Before it is presented I might be modifying the data or using it in calculations.

Also if there is any application or the likes with these features created in PHP that would be greatly valued as it is the language I'm the most experienced with.

My OS is Windows 10.

  • Which application are you working with now? – Taterhead Jul 11 '18 at 7:37
  • 1
    @Taterhead The only similar application I'm using right now is called Prisolve. It allow us to import the data from our economy system (which is called Tripletex) and display it with graphs, create reports, and other similar features. I'm looking for an open source alternative that have some of these features (and those deatiled in the post above) because I'm developing our own system. For databases I'm looking at Amazon Web Service's multiple alternatives. – Ole Jul 11 '18 at 8:00
  • Thanks - ok so you need business intelligence application? or SDK? or API? and when you say a "as a base that I can modify" what parts do you need to modify or customize? The reports side? or the data retrieval side? – Taterhead Jul 11 '18 at 8:40
  • @Taterhead BI application. With modifying it I would mean both changing how things are presented (visually, or adding new formulas if not all the neccecary ones are presented) and how data is retrieved (from the database or the API). What I have to change depends on how it already is in the software. That is why I prefered something open source because it means we can potentionally change anything. – Ole Jul 11 '18 at 9:17
3

I recommend Power Bi Desktop. It is a free application to download and free to use. It has a very robust community users helping others and has a trove of open source visuals to use to build reports. It fulfills all of your requirements (except the PHP one):

retrieve data stored in a database or similar

Power Bi Desktop can pull from a wide variety of data sources: databases (SQL, Oracle, etc), files (excel, text, csv, etc) and online feeds (rest, rss, html, odata, etc) and can also pull from SharePoint or Web Pages. Check the long list at the bottom of link above

work with the data

Power Bi desktop lets you define how the data will be handled when you pull it in. How to handle nulls? split values into new rows or columns based on delimiters, embed new logic or processing is all possible.

present it in a understandable manner

There are many visuals available out of the box to present your data to the users: dials, gauges, bar charts, cards, pie charts, tables, grids, lines, maps, etc.

Also as an added bonus, if your users are viewing the report with a computer or online, they can slice the data (interact with the report) and the visuals change according to the interaction. This is a nice feature that most of the older BI tools do not have. On the other hand, you can do a screen grab of a report to save a static view of the report as an image to use in a web page, presentation or printout.

If your visual is not yet developed, you can create your own and share it with the community. Or fork one of the existing visual code bases and add the feature you need to an existing visual.

All of this is free and Microsoft has been putting out monthly releases with new features for the past year. Microsoft is currently committed to make this a solid product used by people around the world.

I have been using it for the past 6 months and I can attest it is very intuitive and useful and once you get over the initial learning curve. You will be able to create impressive reports that are interactive and get data refreshed from your data sources regularly.

Here is a ton of free learning resources online:

  1. Download and try the sample reports online and inside the help menu.
  2. Join Robust user community and to post questions and get help
  3. Check out Guy in a Cube you tube series. Two power users giving tips for people to get started
  4. Create your own visual.

I'm a developer and have been working with Microsoft tools and platforms for the last 10 years and have not been happy with much of it. However, Power Bi is one of the new products they are getting right! Free to use, monthly upgrades, vibrant user community and helpful support. Along with VS Code, these offerings are encouraging to see coming from Microsoft and makes me optimistic about their future.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.