We are interested in using Power Bi to reduce the workload of our HR department for producing a monthly retention report.
The data is pulled from a single XLSX file that is hosted on our corporate SharePoint (office 365) site.
The Long term goal is to have the employees who need this data log view the info online either via [login to view URL] or as a plugin to our corporate SharePoint
However, for the scope of this project, the report will be distributed by converting the Power BI to PDF using Power BI Desktop.
Attached is an example of Sample data and an example of the current report.
we will also be asking for an additional 2-3 pages for reports that are not currently in the report
(example: line graph of headcount by month or year over time, the reason for leaving by Race/age/Gender etc)
Also, any suggestions will be considered and added on as extra hours
Also please allow time 15-20 to ensure we are able to hook the file up to the live xlsx file
I will be readily available to fill in on finer details (example inactive employees vs active employees (military leave and such). the list includes contractors (c000xxx) and subcontractos (s000xxx) which need to be filtered out etc etc)
Thank you for your concideration