Archives
Contributors
Re: BI and reporting tools
Regards,
Bill
Sent: 16 April 2025 10:32
To: Contributors <contributors@odoo-community.org>
Subject: BI and reporting tools
Hi,
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
_______________________________________________
Mailing-List:
https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe:
https://odoo-community.org/groups?unsubscribe
by Bill Made - 10:45 - 17 Apr 2025
Reference
-
BI and reporting tools
Hi,
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
by Victor - 10:32 - 16 Apr 2025