The Drôme Departmental Council implements community-based and solidarity initiatives that address the daily lives of its residents in areas such as senior citizens, people with disabilities, children, social services, roads, middle schools, the environment, and culture. There is a growing volume of available data and a constant need for Human Resources to obtain relevant metrics. As a result, the Departmental Council has decided to implement a business intelligence tool.
A look back at the solution’s rollout, featuring testimonials from Catherine Lepoutre and Xavier Pradon, both project managers in the Drôme department.
What was the starting point for this business intelligence project?
“There is a real awareness within the department of the importance of metrics for managing our human resources. In fact, today we want to be able to track our operations and performance in real time, while optimizing our HR.”
Until now, dashboards were created manually in Excel. This was very time-consuming for the Human Resources Department. The department needed a solution to reduce these time-consuming, repetitive tasks and minimize errors, which were caused by manual data entry.
“We wanted to start this project with Human Resources and then roll it out to the other departments within the organization. So we needed a tool that would allow us to create dashboards—but ones tailored to each department within our local government—in order to standardize the metrics.”
How did you choose this new solution?
“We knew that the Gironde department had launched a similar project with DigDash. So we drew inspiration from their approach and conducted a POC (“proof of concept”) with this software provider. The POC was successful, so we decided to implement the tool, which is also UGAP-certified.”
We were also won over by the solution’s intuitiveness and the autonomy it provides. In fact, we plan to eventually expand the use of the software to our entire organization. To do that, we needed a cross-functional tool. And that’s exactly what DigDash Enterprise is.”
And today, what’s the status of your project?
“The implementation within our information system was very quick and straightforward. The most challenging part was creating our data warehouse, which was virtually nonexistent. We had to set it up by classifying all the data at our disposal in order to subsequently generate high-quality dashboards and obtain accurate metrics.”
Management will soon be using this solution. The goal is to control payroll costs, anticipate retirements, gain a comprehensive overview of the positions filled within the department, and understand absenteeism… In other words, to optimize human resources management within the local government. The goal is to provide senior management with clear, real-time dashboards to enable faster decision-making.
“We then plan to roll out the tool to the Finance and Facilities departments. This will allow us to optimize the management of the department’s budget and real estate portfolio—all while continuously adding new metrics to make the most of our data. ”