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.

Gaining a better understanding of how your company’s management hierarchy is currently organized will ensure the appropriate staffing levels within each layer of your organization. This leads to better communication, happier employees, and a more efficient workforce. Slalom’s Spans & Layers analysis was built using the Microsoft BI solution stack and can be implemented by any company that wants to capture employee hierarchy and location information.

How the Spans & Layers analysis works

As an analyst, I open the Spans & Layers dashboard on the Headcount Analytics SharePoint site. At first glance, things appear to be normal, and there’s a relatively even distribution of staff to managers to executives. But as I dig deeper into the Spans & Layers of each department, I notice that there is only one layer, Manager, within the Marketing department, with only two total employees. Something seems odd and I immediately begin to question if we have enough people for our needs; what our hiring strategy is; and, most important, who is in charge of Marketing. By using the dashboard I can determine the department leader and schedule a more in-depth conversation to better understand the situation.

Spans and Layers Dashboard

Spans & layers analysis by title and location

Now I want to view total headcount by title and location to see where the majority of the executives are located, so I quickly switch over to the next tab in the workbook. I click on the Sr. Vice President and Vice President titles and see the vast majority of executives are located in Seattle and Chicago. This fits in with our company’s strategic plans for innovation and growth over the next several years, so our workforce is well equipped to make significant strides in these areas.

Spans and Layers Analysis by Title and Location

By leveraging Slalom’s headcount analytics solution, I now have immediate access to perform in-depth, ad-hoc analysis on a variety of data points and sources to answer the wide range of questions that leadership requires in order to make accurate and informed decisions regarding the company’s most strategic initiatives.

To learn more about our self-service headcount analytics solution, read our first post in the series.

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

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

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

  3. 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: