Jump to content
  • Analytics Accelerator for BusinessConnect (B2B Dashboard)


    The users of BusinessConnect are not limited to IT / Operations users. In many companies, there are also business users who are interested to monitor their transactions. They have a different angle than your typical IT Operations users. For example, in terms of transactions involving inbound purchase orders, they are more interested in the number of order lines and the dollar amount on any given day, than the IT users who are more interested in the volume of transactions. It's about dollars and sense, not bytes and seconds.

    Although BusinessConnect has all the transaction data stored in its audit database for non-repudiation and other purposes, the system doesn't usually get involved in peeking or seeking the depth of the content of the transactions. In order to generate a business dashboard based on B2B data, ideally, you would hook into the transactional systems in the private process, such as an Order Management System, a Warehouse Management System in the case of supply chain, or a billing system in the case of Health Insurance.

    In this accelerator, we try to stick to the B2B domain and stay away from the private process, and be a little creative. Our creativity comes in the use of a TIBCO BusinessWorks project (your BC license allows you to use BW in this fashion since it is directly connected to BC data and processes) to do a few things:

    1. Extract data elements you want to report on from the B2B or EDI documents of interest, let's say Purchase Order lines, Purchase Order transaction amount
    2. Insert / post the data elements into some tables. In this accelerator we use SQL tables.
    3. Connect the Spotfire dashboard for Business Analytics to the SQL tables.

    And you are ready to play with your B2B Business data. In the accelerator, we are showing a few typical business reports, such as:

    • $ transaction amount by product

      order_amount_by_trading_partner.thumb.png.809321a2501cadcba531bd4898cbb426.png

    • Forecasted order amount, using Spotfire's embedded predictive / forecasting algorithms.

      forecasted_order_amount.thumb.png.0eeed73f8e160ba0ca7cb5a7cb5312f1.png

    • Order Range's Standard Deviation

      order_standard_deviation.thumb.png.7d0c6943a93db85780a9a06229189cda.png

    After understanding how this works, you can modify the BusinessWorks project create one of your own such that it can extract the data elements that you want from the documents you are interested in, and insert these data elements into a repository of your choice that can be connected to your Spotfire instance. Now you can directly tap into the B2B data content without going into each department's or site's transactional system, in order to gain or present an overall view of your business operations.

    Attached / Downloadable Artifacts:

    1. Spotfire dxp for Business Dashboard
    2. BusinessWorks project for extracting data elements and inserting into temporary tables

    Please post in the comments section if you have any questions. Thank you!

    Attachments

    Download Attachments From Resources

    bc_businessuserdata.dxp_0.zip

    bc-spotfire.zip


    User Feedback

    Recommended Comments

    There are no comments to display.


×
×
  • Create New...