External Vendor Reporting

 One report group consisting of 4 distinct workday reports was created for one of the vendors and a power query solution was created for the second vendor using one workday report. Executing the report groups allowed for multiple reports to be outputted at once with the exact formatting required. For the second vendor report, the output from the workday report is transformed to the final format using Excel Power Query before for submission to the vendor. 

The client's time for preparing quarterly reports for delivery to the vendors was cut drastically. Instead of taking hours to collect and format the needed data, it now took her minutes to prepare. This allowed the client to focus their attention on actual work instead of time consuming, low value administrative activity.