Workforce Intelligence - Data Exports

From PegaWiki
This is the approved revision of this page, as well as being the most recent.
Jump to navigation Jump to search

Workforce Intelligence - Data Exports

Description The data export options available from the Analysis tab
Version as of 8.5
Application Pega Workforce Intelligence
Capability/Industry Area Workforce Intelligence



Workforce Intelligence exports for custom reports and analysis[edit]

Clients can create custom reports and perform custom analyses by accessing or downloading the different data exports that are available from the Analysis tab of the Pega Workforce Intelligence portal. The exports are available as comma-separated value (.CSV) files, or Excel files. Some exports might be included in ZIP files that contain individual CSV files.

Types of data exports[edit]

  1. Screen Analysis Export
  2. Opportunity Finder Summary Export
  3. Wait Time Export
  4. Exports Tab
    • Custom Exports: You can request exports to capture specific metrics. See Requesting exports of Workforce Intelligence data for more information.
    • Default Exports: A ZIP file of default exports in CSV format includes any combination of the following exports, based on your request:
      • User-hierarchy export
      • Processed export
      • Workflow export
      • Step export  
      • Detailed daily raw-data export
    • Weekly/Monthly Production Focus Export: You can request a weekly aggregate data export or a monthly aggregate data export.

Exporting data from reports[edit]

Some report screens include an Export button to export the data on the screen:

Screen Analysis Export[edit]

  1. Click Analysis > Screen Analysis. The screen analysis page displays.
  2. Click the Export button to export the information shown on this page as a comma-separated value (.CSV) or Microsoft Excel-compatible file.
    Export Button.jpg

Opportunity Finder Summary Export[edit]

  1. Click Analysis > Opportunity Finder. The Opportunity Finder page displays.
  2. Click the Export button to export the information shown on this page as a comma-separated value (.CSV) or Microsoft Excel-compatible file.
    Export Button.jpg

Wait Time Export[edit]

  1. Click Analysis > Wait Time. The Wait Time page displays.
  2. Click the Export button to export the information shown on this page as a comma-separated value (.CSV) or Microsoft Excel-compatible file.
    Export Button.jpg

Exporting data from the Exports tab[edit]

You can also request to enable specific exports such as default or custom exports.

  1. Click Analysis > Exports. The Exports page displays.
  2. Click the export file that you want to view or download. Depending on the export you choose, the file is either a CSV file or a ZIP file that contains one or more CSV files.

Sample Export Data[edit]

Screen Analysis Sample Export[edit]

Screen Analysis.jpg

Opportunity Finder Summary Sample Export[edit]

Ops Finder Screenshot.jpg

Wait Time Sample Export[edit]

Wait Time - screenshot 2.jpg

Export Tab Sample Export[edit]

  • Weekly/Monthly Production Focus Sample Export - Clients can export their production focus data by employee from the Export tab. This data is either generated weekly or monthly.
Weekly Data Export.jpg
  • Detailed Event Export - This export is not enabled by default, but can be enabled if there is a need. This is extremely raw data, and not every customer is prepared to consume it. Due to the detailed nature of daily raw data exports, it is recommended that you refer to the detailed High-level Events dictionary.
  • User Hierarchy, Processed, Workflow, and Step exports - These exports are not enabled by default, but can be enabled if there is a need. For more information on the data included in these exports, refer to Workforce Intelligence Export Definitions.

Additional Information[edit]

  1. Weekly/Monthly Production Focus Export
    • The weekly export is generated every Monday and contains the data for the previous week. For Example, on October 19th, 2020, the weekly export for the Week of October 11th, 2020 (from October 11th to 17th) will be generated.
    • The monthly export is generated on the first day of the new month and contains the monthly data for the previous month. For example, on October 1st, 2020, the monthly export for the month of September 2020 will be generated.
  2. Detailed Event Export
    • Once enabled, a detailed data export will be generated every day.

Note: Clients can access either a weekly production focus export or monthly production focus export, but not both simultaneously. The detailed data export will be available alongside the weekly/monthly production focus export.