Mepco is a great HR tool but it still requires in depth analytics, and that's where Power BI / BI Book comes in.   

Instructions on how to connect Mepco to BI Book

The Mepco connector requires some prerequisites. Some scheduled reports need to be created in a certain format in Mepco and transferred to either our or your SFTP server to connect our standardized framework on Mepco. To complete the setup for Mepco please contact our support at as the instructions may vary depending on your setup. 

BI Book's support, please refer to this.