Blue Margin - IT Company

Blue Margin used Power BI and R to help Initech, an IT and software development company, to get control of their data and provide actionable insights to their people.

파트너에 문의 비디오 보기

IT Software Company

Initech (name changed for privacy reasons) is a software development company with several offices throughout the United States. Blue Margin worked with Initech to provide a view of their operational performance to drive focus and productivity in its various service categories.

The Problem

Initech had a difficult time keeping up with the status of their many projects in the areas of business development, hardware, software, and support. If a Senior Executive wanted the status of a project, the Project Manager would have to manually assemble data from various sources and people to generate a (somewhat speculative) answer. The process was cumbersome, the information was not reliable, and the result was that projects would get off track too late to inform the client or make needed changes. The company found itself asking clients for forgiveness, rather than permission. And it was unable to effectively increase the utilization of its people, which hurt profits.

Initech Executives needed answers to critical questions, such as:

• What is our current WIP contract value?

• How do current versus prospective contracts compare in terms of profit?

• Is there sufficient staff hired to meet contract requirements?

• How is cash flow and profitability trending, and are we on track to meet our goals?

Initech’s Executive Team needed a single source truth for its financial KPIs and operational performance. Project Managers needed easy, visual indicators when projects were getting off track, and an easy way to update and report on project status.

Solution

Using Power BI, and integrated R scripts, Blue Margin took data from several sources and transformed it into intuitive, actionable visualizations that allow both the Executive Team and Project Management team to navigate their business from a single pane of glass. We developed regression charts in R that show the trend of key financial indicators, and their goals, so users could easily see if they were on track to meet objectives.

Now, users can easily:

• Gain insight from a high-level management dashboard with combined data from all projects across all geographic locations.

• See projects broken down by job type – software, hardware, support, business development.

• Determine the profitability status of each project, by marginal range, and at the project level.

• Keep track of a full list of status updates, by contract.

Now, Project Managers update their project plans online, every day. If not, the status report alerts the Executive Team to ensure the project is performing on track and on schedule. Everyone receives the right information at the right time.

Value

Using Power BI and the integration with R for statistical analysis, Blue Margin transformed Initech’s data into a strategic asset, empowering both the Executive and Project Management teams to make informed decisions about the status of their projects across their business.

Power BI 파트너가 되고 싶으세요?

인증 파트너는 팀의 중요한 부분입니다. 새로운 비즈니스 기회를 찾고, 연결하고, 전 세계 Power BI 사용자와 귀사의 재능과 경험을 공유하세요.

등록

등록하는 데 도움이 필요하세요?
pbiptnr@microsoft.com에 문의하세요.

Request demo