Self-service headcount analytics using Microsoft BI: salary analysis

Mike Burger Slalom Consulting

Mike Burger

In many companies, executives are often concerned about employee turnover. In this scenario, employee exit surveys have revealed that the staff and managers have stated that their salaries are lower than the market averages, and that the only reason they are leaving is due to significant salary increases. An HR analyst has been tasked with using both internal and external data to confirm or deny this theory. The salary analysis below was built using the Microsoft BI solution stack and can be implemented with any company that captures employee salary information. Read more of this post

Self-service headcount analytics using Microsoft BI: cost-benefit analysis

Veronica Butler Slalom Consulting

Veronica Butler

An attractive employee benefits package that is affordable to a company can assist in recruitment and retention, reduce employee out-of-pocket expenses, and increase employee morale and loyalty. To keep employees healthy and provide a good work-life balance, executives review the standard components of healthcare options, retirement plans, and other incentives annually. Read more of this post

Self-service headcount analytics using Microsoft BI: succession planning

Jason Drucker

Jason Drucker

Many of today’s executives are concerned about the balance of resources across their company. Ideally, they would like a proper blend of experienced veterans and cost-efficient junior resources to fill out the roster, but currently have no simple insight into employee tenure and experience. As executives begin to think about this relatively unchartered territory of talent analytics, many questions are being asked, such as: Read more of this post

Self-service headcount analytics using Microsoft BI: spans & layers analysis

Brian Ringley

Brian Ringley

Spans & Layers is an organizational design methodology that is predicated on the fact that increasing managers’ “spans” (i.e., number of direct reports) and reducing the number of supervisory “layers” within an organization results in better communication throughout the company and a more efficient management process. The Spans & Layers analysis dashboard in our self-service headcount analytics solution helps companies quickly analyze their org. structures to understand and optimize the ratio of staff to manager to executives. Performing this exercise helps companies build a solid foundation for future innovation and growth. Read more of this post

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.

Read more of this post

%d bloggers like this: