Leveraging QAD Q-Xtend to load static or transactional data from an Excel worksheet into the QAD Enterprise Application will affect the IT Effectiveness KPI.

Typical measurements related to this KPI include IT Spend / Revenue, Number of Projects / Enhancements and System Performance.

Loading data directly from an Excel worksheet is faster, easier, and results in far fewer errors, especially if the data in that worksheet can be loaded directly from a file or from your enterprise application. You avoid custom load routines and manual data entry, but ensure all security and data validation.

Additional metrics and the relative importance of each one will depend on your definition of the Effective Enterprise. You can monitor performance against your defined metrics using a combination of Business Intelligence Dashboards, Operational Metrics, Browses and Reports.