Power BI (or Excel for 1st draft) dashboard for small business. Pulling data from multiple Excel tables, manipulating and displaying in a clearly understood dashboard format that can be interrogated.

I need a Power BI (or Excel for 1st draft) dashboard created to display various operational metrics for my small business. The dashboard should be both interactive and static, and it should pull data from multiple Excel tables. Specifically, I need it to pull data from tables exported from our JMS. Assuming Stage 1 works well, Stage 2 will pull the data directly from the JMS. The goal is to have the data presented in a clearly understood dashboard format that can be easily interrogated to improve the management of the business through accurate metrics. Thank you.