Automate the daily export of excel files to a shared file location and from there, automatically pull the data into Office 365 via Power Automate. Once the data is in our system, a Power BI report was created on top of it to visualize key company metrics.
Managers have the ability to enter the report and view their KPIs in easily digestable graphs and visualizations. They can view their teams performance, and track it against their performance in previous years. In addition, they can view client billing health and information as well as get a glimpse into what factors effect their project profitability.