I have been given a task to automate the reports that multiple teams in our production generate. Currently, they mostly work on excel operations to generate their reports. Their source of data is an email sent on a daily basis. The bummer here is that each team has their own source report, and their own output report and their own way of generating their reports.
Now my initial approach was to tackle the big elephant piece by piece by handling 1 team at a time. But this approach took so much time, since I had to understand teams reports, how they process it, and how the output looks like. This became unacceptable to my boss.
Now my approach is to standardize the source report of all teams which I think will help on the automation's timeline but I would still use a lot of time in understanding each teams way of creating their reports.
What I am thinking now is to create a system that can provide them tabular data, and then they should do their manual task. But this would not fully automate the system.
I'm not sure if there are other options. But to summarize the question, what approach would you do to automate a very manual system where everyone has their own way of doing their thing
btw, I'm using django and python libraries to create the system