Drive your business with relevant reports, using the advanced features of a BI tool (e.g. Looker Studio or Power BI), directly integrated into your Odoo ERP.
BI integrated with Odoo
Smart Analytics is a solution that lets you deploy a real BI architecture from your Odoo environment, via the installation and configuration of 2 intelligent modules.
From data extraction to manipulation and visualization, Smart Analytics lets you automate these workflows by integrating the latest Business Intelligence technologies!
Our catalog of Plug & Play dashboards
We have developed a set of cross-department and cross-sector dashboards that can be rapidly deployed with your Odoo environment.
Explore our 5 dashboards below.
Take your Odoo reporting to the next level with Smart Analytics:
Interactive, dynamic dashboards tailored to your needs and created using real BI software
A fully scalable solution, whatever your data volume and number of users
Data visualized in near real time via easily configurable exports
Automated, centralized reporting that's easy to share
Customized access to guarantee strict confidentiality
Watch a demo video !
Don't wait for the next webinar, let us know below what email we should send the video to:
Join a free Smart Analytics webinar :
1. What data warehouse does the solution use ?
By default, we use the data warehouse solution of Google (BigQuery), but on demand we can build some other connectors to fit your needs.
2. Can other sources of data be used in combination with Odoo ?
Yes, data coming from outside Odoo (third party softwares / external files /…) can be mapped with Odoo data in the data warehouse or at the BI tool level depending on your needs.
3. Does Idealis access, read or store my data ?
No, Idealis is only responsible to securely transfer your selected data to the data warehouse.
4. How do I get the data out of my Odoo ?
We developed a custom Odoo module which is in charge of the extraction, transformation and loading (ETL) of the data into the data warehouse via your Odoo API key.
5. Can the solution export ‘custom’ or “calculated fields” from Odoo?
Yes, it doesn’t matter if the desired field was added via Odoo studio or a custom development, we can extract all fields that are stored in your Odoo database but we can also extract calculated data that isn’t stored in the database and that Odoo usually calculated before displaying on screen.
6. Is it possible to do advanced data transformation / prediction /classification thanks to Machine Learning or AI algorithms ?
Yes, there is a section in the extract tool where we can freely add python code to perform any type of data transformation or adding any machine learning model.
7. Do I have control on the data refresh frequency ?
Yes, the frequency can be configured (ex: every 5 minutes / every hour / 4 times a day / every week/month). However, you have to keep in mind the computation costs.
8. How do I visualize the final dashboards?
The dashboards are directly integrated into Odoo for a seamless user experience.
9. What needs to be installed in my Odoo, is it an Odoo Module ?
Yes, our solution is deployable via an Odoo module that you install in your own environment.
10. Can I control who has access to what dashboard and to what data ?
Yes, you can use the standard access rights of Odoo to be able to view / access a specific dashboard. Moreover, on the BI software level, you can control which data is displayed regarding the viewers for the same dashboard.
11. What BI tools are compatible with the solution ?
Most of the BI tools are compatible with the solution. As long as it has an embed capability. The standard dashboards are built using Google Lookerstudio. However, we have certified consultant in PowerBi and Looker Studio that are willing to help you build your custom reports.
12. Can I modify the dashboards myself?
Yes, but at this point to pull new data points from Odoo to the data warehouse, we need to update the queries on our end. Everything else, building or tweaking the dashboards, adding them to Odoo, updating the access rights, can be done by you.
Our customer projects
We installed the Smart Analytics solution to manage the commercial and strategic aspects of the company.
We installed the solution in order to monitor and analyze the profitability of the various employees' projects.
We installed Smart Analytics to analyze and boost the company's sales, as well as better track inventory and forecast future out-of-stock situations.
We installed the solution to automate machine production reporting, as well as tracking productivity indicators.
We installed Smart Analytics to support management in the commercial and strategic monitoring of the company.
We installed the solution in order to monitor the productivity of operators in their parcel preparations, as well as to track commercial and financial indicators.
Discover our Smart Analytics solution
We offer free 2-hour online training courses.