RPA Use Case: Bots that do Data Mining and Reporting

This Bot downloads data from Data.Gov and loads it into an Excel spreadsheet. The bot also extracts the column headers and transposes them in a separate sheet as part of the deliverable. It then creates a pivot table from the data and applies various formats to meet the recipient’s report needs and emails the document to them.