Medium badge
Medium img 18152 Jeremy Gibson

Proof of Automation

Overtime Dashboard Automation for PWA

  • October 31, 2019 at 10:36 AM
  • Visible to public
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.