Integration [457] - IT Business Analytics import asset management data from AM (IT BA <- AM)

  • Document ID:KM01695981
  • Creation Date:11-Jun-2018
  • Modified Date:11-Jun-2018
    • Micro Focus Products:
      asset manager
      it business analytics

Summary

Integration Catalog

Reference

IT Business Analytics import asset management data from AM (IT BA <- AM) - Catalog Id: 457
  • Integrations /
  • [457] IT Business Analytics import asset management data from AM (IT BA <- AM)

Description

This out-of-the box data integration imports HPE Asset Manager (AM) data into IT Business Analytics (Formerly Executive Scorecard).  The data is then combined with other data sources, transformed, analyzed, and loaded as metrics on a series of Executive Scorecard tabs.

The AM data includes assets, contracts, and suppliers data and is used to build key performance indicators (KPIs) for an executive level view of the organization.

 

The data warehouse is the repository for key business data that supports queries, reports, and populates business analytics. The content of the data warehouse originates with external applications such as HPE Asset Manager and HPE Project and Portfolio Management. The data warehouse enables data integration and promotes data consolidation by using consistent data models regardless of the disparate data models among different data sources. The data warehouse software relies on common data models that support each phase of the Extract, Transform, and Load (ETL) process.
 
 
The ETL process is an end-to-end transfer of external source data through several staging layers and into the target layer of the data warehouse. The data warehouse uses the ETL process to extract, consolidate, and transform the source data into a meaningful target model that populates relevant business analytics.

The table below lists the KPIs that display the data extracted from the data source and provides a description of the KPIs and the business motivation for each KPI.

% of Assets in MaintenanceKPI

  • Business Questions: Make sure we have enough assets to work efficiently.
  • Business Objective: Achieve Process Excellence
  • Description: The number of a assets in maintenance relative to the total number of assets.
  • Context: AssetManagement
  • Data Source: AM

% of Assets Returned to Supplier KPI

  • Business Questions: Make sure we have enough assets to work efficiently. Should we change suppliers?
  • Business Objective: Achieve Process Excellence
  • Description: The number of assets returned to the suppliers relative to the total number of assets.
  • Context: AssetManagement
  • Data Source: AM

% of Change in Assets CostKPI

  • Business Questions: Make sure our assets costs are under control. Make sure our asset management is improving.
  • Business Objective:Reduce Costs
  • Description: The asset cost in the last period relative to the asset cost in the previous period.
  • Context: AssetManagement
  • Data Source: AM

% of Software Licenses in Use KPI

  • Business Questions: Make sure our software license purchasing is efficient.
  • Business Objective: Reduce Cost
  • Description: The number of used software licenses relative to the total number of purchased software licenses.
  • Context: AssetManagement
  • Data Source: AM

 Average Age of Hardware Assets KPI

  • Business Questions: Make sure our policy of hardware asset renewal is on track.
  • Business Objective: Achieve Process Excellence
  • Description: The average age of hardware assets.
  • Context: AssetManagement
  • Data Source: AM

 Average Time to Procure Hardware KPI

  • Business Questions: Make sure our procuration policy is efficient.
  • Business Objective:Improve Responsiveness
  • Description: The average time needed to procure an item defined as the time lag between a request for procurement and the contract signing or the purchase.
  • Context: AssetManagement
  • Data Source: AM

  

General

Leading Product:
IT Business Analytics


Secondary Product:
Asset Manager

4/16/2018

Documentation

Support Matrix

Asset Manager
IT Business Analytics
SupportedSupported (see comments)Not Supported

Generated: 6/11/2018 4:41:23 AM