Winner of a Drexel LeBow Analytics 50 Award

Winner of a Drexel LeBow 

Analytics 50 Award

The City of Raleigh Enterprise Data Management (EDM) team, in partnership with Human Resources, was recently announced as a winner of a Drexel LeBow Analytics 50 award. The recognition is an initiative of the Drexel University LeBow College of Business.

Honorees are chosen for applying creative solutions involving data analytics to a business challenge.

The City of Raleigh had a variety of ways of collecting human resources data. In some cases, data was not tracked or was inaccessible or incomplete. A tool was needed to help collect, aggregate and visually display data in a secure environment to enable the City to become a more data-driven organization. The tool needed to give staff the ability to use data to help staff make better decisions about staffing well ahead of posting an open position.

The EDM team created new visibility into HR data and trends by using Microsoft's Power BI analytics tool to discover relationships between vast datasets. The project has highlighted places within the HR process where key data should be collected.

The City now has a comprehensive (and developing) picture of the following data:

• A holistic look at current vacancies, the number of referrals for each position, time to hire, time to source.

• Diversity demographic analysis of applicants, referrals, and hires.

• For current employees, a complete set of demographics in one place, including years of service, salary equity, and retirement eligibility.

• Termination data associated with overall turnover rate, and analysis of the reasons for short-tenure employees.

This new capability, enabled by the appropriate data collection tool and trained staff, improves the quality of the data collected and analyzed by all departments, facilitates HR process change, and enables the City of Raleigh to use data and analytics to inform business decisions.

The Drexel LeBow Analytics 50 is a national recognition of analytics innovators. Past honorees have included UPS, Southwest Airlines, Starbucks, Citrix and the Cities of Boston, Cincinnati, Los Angeles, and Pittsburgh.

Read more about the honorees here: https://www.information-management.com/news/top-50-organizations-for-data-analytics-to-be-honored