Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Approach on a project to automate manual reports on multiple teams

development methodology

  • Please log in to reply

#1
chessmonster

chessmonster

    New Member

  • Member
  • Pip
  • 1 posts

Hello,

 

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


  • 0

Advertisements


#2
SpywareDr

SpywareDr

    Member 3k

  • Member
  • PipPipPipPipPipPip
  • 3,064 posts

An online database where all of the teams input their data daily.


  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP