EDI and B2B Insights – What Forms of Analytics Do I Want?
In my last blog, Why Your EDI and B2B Processes Need Analytics, I provided examples of the kind of B2B analysis questions that you need to have answers for in order to improve competitiveness in your business. I have found three prerequisites that will create value from your B2B data via analytics:
- A foundation of good-quality B2B data for analysis. If you are already automating your B2B processes, you are likely to have some of this critical data already upon which your analysis can be based.
- The definition of what you want to measure and how the results can be visualized in a way that enables you to understand trends, markets, customers and suppliers.
- The analytics tools to deliver the B2B data visualizations you need and that can help you to engage decision-makers.
Below is a “ladder” of the types of analytics capabilities in sequence from the fundamental capabilities at the bottom to the advanced capabilities at the top. Most companies are beginning to incorporate the first few capabilities at the bottom rungs of the ladder, and will need to start to plan how to incorporate those at the top in order to successfully compete in their chosen markets.
- Standard Reports – these are pre-defined, configurable reports that provide key information about files and transactions you exchange with your trading partners. These typically include powerful capabilities to sort, filter, save, schedule and distribute. For example, you may wish to see a monthly report of all orders received from all your customers.
- Adhoc Querying & Reporting – this is the capability to search and generate custom reports on your B2B transactions by document type, trading partner, date, time, status, and more. You can define the fields to include on the report and tailor it to your specific needs.
- Dashboards and Alerts– These provide both the timely “track and trace” data needed to address exception conditions and the summary data needed to identify performance trends, drill down to view specific details and export the data through integration with Microsoft Office. For example, below is a transaction dashboard that provides a visual summary of transaction activity and exception situations. Furthermore, it provides volume trends by document type and trading partner. So now, at a glance you can see which transactions need your immediate attention (e.g. purchase orders that have not been acknowledged), which documents account for the highest volume (e.g. invoices are in the 2nd spot after carrier shipment statuses), and which trading partners account for the highest transaction volumes.
- Configurable Dashboards – This provides the ability to integrate and combine EDI and non-EDI data from various applications and gain insights into supply chain trends concerning reliability, responsiveness, flexibility, trading partner performance, e-invoicing performance, etc. In addition, these dashboards can be integrated with workflows based upon user-defined rules. For example, if the dashboard shows that order volume from a customer drops by 20% over a month, it can trigger a user-defined business process and/or send a notification to specific users in the organization.
- Predictive Modelling – This is an advanced capability that few businesses have today, but which is now possible with the latest analytics technology. Sophisticated statistical models that analyze B2B data available from various applications can help you forecast trends and needs in inventory management, logistics and all other areas requiring strategic planning.
- Scorecards – This is a visual display of Key Performance Indicators (KPIs), such as order acceptance, invoice accuracy, delivery punctuality, ASN timeliness, and fill-rate. The scorecard enables you to measure, evaluate and analyze supplier performance. This information can then be used by buyers and suppliers during negotiations when justifying business awards and pricing.
- Benchmark / Index – This capability benchmarks an organization’s performance against the industry and provides insight into those processes that trail or exceed your competition, thus enabling your organization to take appropriate action.
If this blog has interested you and you would like to learn more, click here to watch this new on-demand webinar, Using Analytics to Unlock the Value of your B2B Data.