Blue Margin - Accounting & Real Estate

Blue Margin used Power BI to help a CPA firm create a compelling financial story for one of their largest clients, DLP Property Management. The CPA firm looked good, their client looked even better.

联系合作伙伴 观看视频

Property Management

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.

Problem

DLP Property Management (DLP) has rental properties in the United States, Canada, Europe, and Australia. Managing financial details for each property was burdensome and left DLP executives feeling devoid of “the big picture”. 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.

To gain meaningful insights, DLP executives would have to analyze multiple income statements. They found it difficult to answer even simple questions, such as:

• How do the income statements compare to one another, year over year?

• How does gross profit versus gross profit margin figures compare for properties in the United States versus Canada, over time?

• Which European property had the most favorable ratio of revenues to expenses?

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. They needed to know if it was wise to expand.

Solution

Realizing their frustration, DLP’s CPA firm wanted to provide a solution. 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. 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.

All parties involved are now able to see high level information through a single pane of glass. Now, DLP managers and their accounting team can easily:

• Drill down to each level of a property’s income statement and make comparisons over time.

• Determine variances in Cost of Sales and other metrics.

• Determine which region is ripe for expansion and which may be hurting the company financially.

This list goes on.

Value

In this case, the value Power BI provided is two-fold. The executives at DLP benefited from new strategic insights. The CPA firm was able to deliver to DLP a powerful solution, increasing their value to the client.

Using Power BI, Blue Margin transformed DLP’s data into a strategic asset, empowering managers and the accounting team to make informed decisions about each property.

想要成为 Power BI 合作伙伴?

认证合作伙伴是团队的重要组成部分! 挖据新的商机、建立人脉并与世界各地的 Power BI 用户分享公司的人才和经验。

注册

需要注册方面的帮助?
请联系 pbiptnr@microsoft.com

Request demo