Contributors mailing list archives
contributors@odoo-community.org
Browse archives
BI and reporting tools
byHi,
I am researching different ways to do BI (business intelligence) and reporting with Odoo.
I am wondering whether it's worth it to invest on an external BI tool connected to the Odoo database.
On the community version I have the impression that the standard
BI tools (standard pivot and graphs reports in Odoo) are sometimes
limited in terms of performance (it's slow for wide and long pivot
tables), data visualization (standard charts are not very useful)
and flexibility (hard to make computations).
I know of the bi_view_editor and bi_sql_editor modules. Both are very useful and greatly extends the standard reports. But the limits listed above remains. But it seems it's hard to use it as is, in my case I always have to export manually the tables to build the table or chart I want with excel.
I also know of the spreadsheet and dashboard modules, although I don't have a great experience with it. Maybe it provides the lacking flexibility mentioned above ?
The last option is to connect a BI tool (Tableau, PowerBI, Apache
superset, Metabase...) to the database. The main advantage is to
connect it to other sources of data. But I am wondering if it's
still worth it even connected only to the Odoo database.
Do you use an external BI tools ? If yes, which one seems to work
well with Odoo (and preferably open source) ?
If no, how do you deal with BI and reporting for your clients ?
Are you also confronted to performance issues, lack of flexibility
and poor library of charts ?
Thank you for your inputs !
--
Victor Champonnois - Coop IT Easy
