Lost on approach on a "easy" report automation option

Hi, I need to create a bot to support production of reports… it has about 400 variations with each one having a set of KPI… it will be dealing with around 50 data sources (some core system data, some excel spreadsheets etc). I can access the data, but what would be the optimal construct? the objective is for the bot to produce the data commutation and then individual reports. Would would be the best approach? thanks for any ideas to explore!

Hi @aussta

My suggestion is to allow better I/O operations:

A. Create template for each of the 400 variations

  1. Prepare a template that you can copy from a folder and work on the copied template
  2. Extract the relevant data to fill the fields of the copied template
  3. Predefined the default values in case the data extraction return NULL

B. Data preparation:

  1. Have a few first-tier robots to pull each of the 50 data sources
  2. Have the second-tier robot to filter, cleanse, sort, update, etc. the data into fields, tables, images, etc.
  3. Have the third-tier robot to duplicate the data source from second-tier robot (direction is one-way)
  4. Have the last-tier robot to extract from duplicate data source (I/O direction is one-way only)

C. Robots

  1. The first-tier robot will extract lots of raw data into a local machine
  2. The second-tier robot should convert the raw data locally (no network latency) into meaning data locally
  3. The third-tier robot to prepare a separate data store for read-only by the template-generating robot
  4. The last-tier or template-robot to generate the report from read-only data store
1 Like