Unlocking Growth Potential: A Closer Look at Workforce Structure

Unlocking Growth Potential: A Closer Look at Workforce Structure

We often talk about organizational strength in terms of numbers—headcount, growth, and size. But that only tells part of the story. What really matters is how people move within the system and whether the structure actually supports that movement. To explore this on this project, I worked with a 1,470-employee HR dataset from Kaggle and built out a Power BI dashboard to see what’s really going on beneath the surface

Design and Methodology. I pulled together key metrics—things like tenure, workforce size, and promotion readiness—and used Power BI to make sense of them. With a mix of DAX measures, some basic statistical breakdowns, and the use of charts such as cards, the goal was simply to turn raw data into something you can actually read and question.

Assumptions and key insights. A few things became very clear after visualising the data.

• The workforce is highly centralized. Most employees live close to the office, which usually helps with collaboration and day-to-day connection. That part looks solid.
• But then you notice the structure. A large majority—about 73%—sit at the lower job levels. And once you move up, there’s a sharp drop. That gap at the mid-level isn’t just a number—it’s a signal that growth paths might be tighter than they should be
• It gets more interesting when you look at promotions. Over half of the workforce—797 people—are due for one. That’s a lot of people waiting for the next step in a system that doesn’t seem to have enough room. You don’t need to overanalyze it to see the risk there
• On the flip side, retention isn’t all bad news. Very few employees are close to retirement, and there’s a noticeable group that’s been around for years. That kind of loyalty doesn’t happen by accident.
• Final Thoughts and Actions What this really shows is a company that’s stable and grounded, but a bit stuck in the middle. The foundation is strong, no doubt—but without clearer paths upward, that strength could start to work against it. To resolve some of these issues, the company will need to:
• Evaluate and redesign the promotion framework to avoid high performers leaving due to lack of growth.
• Train and create more job roles at higher levels to ensure upward mobility of employees.

I also leaned on AI a bit during the process to speed things up—mostly for sorting through the data and spotting patterns—but the interpretation and direction came from me by digging into what the numbers were actually saying.