Analytics & reporting case study: Pensions Authority

An old man stacking up coins indicating towards Idiro's work for Pensions Authority

case studies

Idiro were engaged by The Pensions Authority to carry out a range of analytics, reporting and data auditing functions.
The outset of the project required an overall exploration and auditing of the data currently held within The Pension Authority’s data warehouse to identify anomalies, inconsistencies or duplication. From there, specific areas of focus were identified for further analysis, updating of existing reporting processes and development of new reports.

Exploring a wealth of data

The Pensions Authority holds many years of data on trends in citizens’ retirement ages, contributions and payments

Ensuring data quality and reliable analysis

This project brought clarity and the ability to improve services for people and planning for regulatory procedures

If you require further information about this case study or wish to learn more about how Idiro can help your business exploit its data to better meet your business objectives, please contact us.

The Pensions Authority's mission is:

“To regulate and influence the policy environment so that people working in Ireland are confident that they are making adequate provision for their old age and that their pensions’ expectations will be met.”

case studies

Our work

Our pioneering work in the field of data analytics places solutions at your fingertips to full fill every customer requirement efficiently

The Department of Business Enterprise and Innovation

Government business executive holding his laptop while talking on a phone call.

case studies

Data analytics for government services

The Department of Business, Enterprise and Innovation (DBEI) required a forecast model to identify the staffing levels that would be required in the childcare and early childhood education sector, year on year to 2030.

35 days

This project was an urgent requirement, and was turned around extremely quickly.

Sophisticated forecast capability Achieved

Ireland’s government can now accurately estimate the needs for childcare and education and take into account trends that arise on an ongoing basis.

We coordinated across multiple stakeholders from DBEI as well as the Department of Children and Youth Affairs, the Department of Education, the Central Statistics Office and the Economic and the Economic and Social Research Institute. The core factors that needed to be considered in calculating the future needs of the sector were:

  • Current Demand & Supply
  • Forecasted population change
  • Changes in level of education or training required by staff
  • Changes in Staff:Child ratios

Data came from the various government departments and organisations to feed into a comprehensive calculation on future demand. Our expert analysts were onto the data immediately. There were significant challenges in the data availability, format and completeness,  and we called on extensive expert advice from stakeholders to correctly mitigate problems and appropriately apply assumptions.

A logo of Department of Business, Enterprise and Innovation of Ireland

Output

Idiro delivered a thorough report on the factors that will affect the sector and staffing levels over the years of interest. A required deliverable was also an Excel based calculator that would allow for various conditions to be adjusted and updated forecasts created. We also delivered data visualisation showing the change in demand over time given the set of conditions specified.

case studies

Our work

Our pioneering work in the field of data analytics places solutions at your fingertips to full fill every customer requirement efficiently

Interpretation of customer data

Teacher asking a question about analytics and children raising their hand to answer it.

case study : Interpretation of customer data

Interpretation of customer data

The Catholic Primary Schools Management Association (CPSMA) provides advice and support for Chairpersons and Principals of Boards of Management in over 2,800 schools. It collaborates with other management bodies and negotiates on behalf of these schools with the Department of Education and Skills and other education partners. They decided to seek Idiro’s expertise in customer data analysis.

Analysis of a large volume of call records

Data analysed:

  • School location
  • Gender of pupils (All boys, All girls, mixed)
  • School size
  • Deis or Non-Deis
  • Gaelscoil or English
  • 5 years worth of data

Our project was to discover the core drivers of contact the organisation receives and identify any insights that would help to better manage and inform their members and thus reduce the volumes of calls received. To do this, we examined records of calls over a five-year period – approximately 35,000 calls. Summary notes and details of each call (date, time, duration, etc.) were stored in a Microsoft Access database. Idiro took an extract from the database and performed an in-depth data analysis.

Trends and comparisons were made under a variety of headings:

  • School location
  • Gender of pupils (All boys, All Girls, Mixed)
  • School size
  • Deis or Non-Deis
  • Gaelscoil or English
  • Year on year

Output

Idiro conducted customer data analysis and delivered a comprehensive report highlighting key findings in relation to reasons for contact and giving solutions to reduce contact volumes within certain categories. An interactive dashboard was also delivered providing the ability to drill into the detail of the analysis and examine data right down to the individual school level.

case studies

Our work

Our pioneering work in the field of data analytics places solutions at your fingertips to full fill every customer requirement efficiently

Data infrastructure and reporting for a government body

case studies Data infrastructure and reporting for a government body Changes in regulations bring extra compliance requirements, which for one Irish regulatory body resulted in a massive increase in the need for transparent reporting and analytics.  We worked with this organisation to understand its current data infrastructure and to identify improvements in the data warehouse […]

Continue reading