Self-service headcount analytics using Microsoft BI: introduction

Brian Ringley

Brian Ringley

Slalom Chicago’s Information Management & Analytics practice recently implemented a self-service business intelligence (BI) headcount analytics solution for one of the largest retail real estate investment trust (REIT) companies in the United States. The client realized that it needed to be organized and adaptable in order to stay on top of an ever-changing business environment and to stay competitive within the market. To do this, the organization needed to shift to a people-focused model.

This shift caused many disruptions in the day-to-day business operations and forced the organization to focus on leadership, communication, and organizational structure. The client quickly realized that it was unable to confidently or accurately answer some fairly basic questions around its workforce, headcount, payroll, taxes, benefits, open positions, retention, employee performance, and succession planning.

This is where Slalom’s solution came into play. The solution solved the major business problems the client faced by automating the capture, integration, and cleansing of relevant information from a variety of source systems. The data was also enriched by including custom calculations, creating a dimensional model, and adding the ability for analysis of both historical and forecasted information. Finally, the information was surfaced through the Microsoft tools the company already owned and was comfortable using. All of the changes enabled the client to derive insights from their data, which would allow them to support the organization’s shift in priorities.self-service headcount analytics

The results

The client business users are now able to confidently answer the questions about their workforce (mentioned earlier) among other meaningful metrics that were uncovered during the project implementation. Through the use of the self-service capabilities within the Microsoft BI stack, the client is now able to support its evolution into an innovative and people-oriented organization.

Headcount analytics are gaining more momentum as organizations look for ways to capitalize on their greatest investments: their people. In fact, some of the largest companies in the world (including Coca-Cola, Chiquita, and General Motors) are heavily investing in this area as noted in the latest issue of CIO magazine.

Stay tuned

This post is the first installment in a six-part series. Please stay tuned for more common and practical analytic scenarios that were developed as part of Slalom’s headcount analytics solution.

4 Responses to Self-service headcount analytics using Microsoft BI: introduction

  1. Pingback: Self-service headcount analytics using Microsoft BI: spans & layers analysis | The Slalom Blog

  2. Pingback: Self-service headcount analytics using Microsoft BI: health benefits analysis | The Slalom Blog

  3. Pingback: Self-service headcount analytics using Microsoft BI: payroll analysis | The Slalom Blog

  4. Pingback: Self-service headcount analytics using Microsoft BI: salary analysis | The Slalom Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: