The CPA firm was able to deliver to DLP a powerful solution, increasing their value to the client. The executives at DLP benefited from new strategic insights.

In this case, the value Power BI provided is two-fold. Determine which region is ripe for expansion and which may be hurting the company financially.Determine variances in Cost of Sales and other metrics.Drill down to each level of a property’s income statement and make comparisons over time.Now, DLP managers and their accounting team can easily: Blue Margin used Power BI to invigorate once static income statements, giving managers insights and the ability to explore the data in order to make critical financial decisions.Īll parties involved are now able to see high level information through a single pane of glass. At a Power BI talk given by Blue Margin, the CPA firm had learned about Power BI’s functionality, and wanted to offer it to DLP as a service. Realizing their frustration, DLP’s CPA firm wanted to provide a solution. They needed to know if it was wise to expand. In addition, DLP required better information to make critical investment and expansion decisions, such as which country is best for expansion opportunities, and which country has the greatest profitability by organization. Which European property had the most favorable ratio of revenues to expenses?.How does gross profit versus gross profit margin figures compare for properties in the United States versus Canada, over time?.How do the income statements compare to one another, year over year?.They found it difficult to answer even simple questions, such as: To gain meaningful insights, DLP executives would have to analyze multiple income statements. DLP had over 2.5 million rows of detailed, tabular data, and managers lacked the ability to easily drill down to assess each property’s financial performance. Managing financial details for each property was burdensome and left DLP executives feeling devoid of “the big picture”. ProblemĭLP Property Management (DLP) has rental properties in the United States, Canada, Europe, and Australia. Hearing about Power BI’s powerful functionality, and Blue Margin’s knack for creating dashboards that actually drive decisions, a leading CPA firm asked Blue Margin to come up with a BI solution for one of their largest clients, DLP Property Management.

Dlp real estate management