Power BI allows users to easily create complex and multi-level reports, giving them the level of insight they need to do their daily work. With this Spotlights article, we would like to visualize what we can do with data coming out of Dynamics Rental Management for Microsoft Dynamics 365 for Operations.

Having a clear view of the performance of your rental depot is key in helping steer your organization:

Depot KPI analysis with Dynamics Rental Management and Microsoft Power BI

In Dynamics Rental Management, all transactions are stored in one database, opening up the opportunity to see a full financial performance. With the information coming out of Rental Management, any financial overview can easily be made on any (or even multiple) level(s).

Clicking on a specific depot in an overview allows a user to zoom into the different transactions to truly understand the local business and make a decision based upon the latest information:

Rental revenue overview with Dynamics Rental Management and Microsoft Power BI

By measuring the financial and operational utilization rate of assets with Dynamics Rental Management, you can determine if the right assets are allocated in the right depots. You can also compare the actual performance of any individual asset or asset group against default values as determined by yourself in the setup.

The utilization rate gives valuable information about how your assets are performing across depots/countries. By comparing the results, your fleet manager can decide the optimal mix of assets per depot to maximize your rental revenue:

Asset utilization statistics with Dynamics Rental Management and Microsoft Power BI

Of course, rental revenue and utilization rate are important to analyze the revenue side of the process, but it is equally important to also have full control over the cost side of the rental process. An important cost driver within all rental industries is the service and maintenance costs of your rental fleet. Dynamics Rental Management is completely integrated with Dynamics Service Management to fully meet the service requirements within the rental industry. In Dynamics Rental Management, all the service and maintenance costs are allocated to the assets, which allows us to show the total cost per asset/asset groups.

Rental companies are often managing a huge rental fleet and want to do management by exception. By using Dynamics Rental Management and Microsoft Power BI it is possible to set up a threshold to easily identify individual assets outside this threshold:

Asset service cost overview with Dynamics Rental Management and Microsoft Power BI

Your employees (and thus your company) will heavily benefit from having real-time reports available at their fingertips. They will have access to all the relevant business information to make the right decisions on a daily basis. Information about budgets, revenue forecasts, asset information, resources, and asset availability give them the information they need at the right time and in the right user-friendly format.

By Dynamics Rental Management with Microsoft Power BI as your reporting tool, your employees can create business specific reports within minutes all by themselves.