Medium badge

Automation Machine

Louisville-Metro-Badges/Automation-Machine

Work to automate some process in the data life cycle- from data collection to data visualization.

 

Jeremy Gibson

Expert

Awarded badge on October 31, 2019

Medium img 18152

Endorsements & Feedback

Feedback

Kudos!

Way to go Jeremy. This looks awesome! Keep up the good work. 
Small img 18152 jeremygibson About 1 month ago

Badge Portfolio

Proof of Automation

Evidence visible to public
Write up a summary about how you were able to change the process, and how the current automation process works. More Info

Overtime Dashboard Automation for PWA

We generate a monthly report for departmental leadership on paid overtime. This was previously a manual process and could take a few hours to complete, as we had to pair employee names with division and subdivision. Using Power BI, I improved three things.
  • Created a psuedo database using Get Data type 'Folder' where I can drop new payable time files into.
  • Created a psuedo database using Get Data type 'Folder' where I drop new PCRs (excel files with employee departments, etc.)
  • Connected the two with a relationship through Power Bi to be able to present both overtime and departments.

This let me automate the report and turn a few hour process into a 5 minute update.