Ioppolo and Associates

Ioppolo and Associates

Combining External Data with Odoo

combining external data with odoo
Many businesses may operate external applications or systems in addition to Odoo. This may include, special processing or manufacturing machinery which has its own sensors and associated software that captures key production centric data that often, when combined with financial data, may provide key insights into overall business performance. Sometimes key data associated with business performance may be coming from external sources, or, a business may have a requirement to store historical information that resides in other systems in an environment that will facilitate easy comparisons and seamless reporting with current business activity.Specific examples of this “mashing up” of data for the purpose of management reporting may include:
  • The adding of additional budget/reforecast information not present in Odoo which may be by customer, product, territory and branch.
  • The need to group together certain analytic accounts across multiple entities to produce a report that represents a manager's sphere of responsibility.
  • The need to bring in data captured from your processing plant, such as; wastage, processing volumes etc., that you may like to evaluate against costs.
Odoo is seldom used as the platform for producing business management reports.

For many businesses, “mashing up” activity is undertaken in Excel where end users have the ability to format and add additional information to the data sourced out of Odoo to frame up a comprehensive formatted view of business performance, which is commensurate with the way the business is viewed and managed. However, using a myriad of hard to manage spreadsheets, to deliver this outcome, becomes time consuming to update and can provide business decision makers with error prone information. With complex spreadsheets also comes “Keyman” risk, where business management may be beholden to the developers of these spreadsheets for the information needed to run their business.

I&A has developed a solution called Essatto, which through its built-in connector, integrates with Odoo and delivers comprehensive budgeting and forecasting, aggregates ALL of the businesses data (including Odoo) into a central Data Analytics platform, and provides streamlined reporting to save a business time and value-add by helping to uncover cost savings and revenue opportunities.

Essatto Architecture - Odoo Perth WA
Essatto Architecture

ESSATTO KEY FEATURES

  • “One Click” management reporting through the integration of your existing excel management reporting pack
  • Multi-scenario budgeting and forecasting
  • Multi-dimensional "actual vs. budget vs. reforecast" performance and variance analysis, including; by entity, customer, product, district, store, responsibility centre and sales representative
  • The ability to integrate Odoo data with data coming from other sources
  • A simplified consolidation module that facilitates consolidation of actual as well as budget/reforecast data, accounting for minority interests and foreign currency impacts
  • Extensive reporting and dashboarding including “live-link” excel read and writeback, web dashboards and reports
  • Also being delivered in the next release of Essatto, is a comprehensive forecast cash flow capability that takes into account expected future flows derived from Odoo, as well as future flows that are not reflected in Odoo such as cashflow impacts of projected sales
Best Essatto (Data Analytics & Warehousing) implementation and management in Perth WA

ASK US A QUESTION

Name(Required)
Scroll to top