Analytics & reporting case study: Pensions Authority

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

case studies

The Pensions authority: Data audit

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

An old man stacking up coins indicating towards Idiro's work for Pensions Authority
A group of people putting their hands on top of each other
An old couple looking outside the window. Idiro's case study on Pensions Authority

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

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

The Department of Business Enterprise and Innovation

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

Interpretation of customer data

Data infrastructure and reporting for a government body

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.

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

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

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

Analytics & reporting case study: Pensions Authority

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

Interpretation of customer data

Data infrastructure and reporting for a government body

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
A child holding crayons colouring inside her drawing book at her school, that Idiro helped with analytics.
Teacher asking a question about analytics and children raising their hand to answer it.
Children working on their homework in a class explaining Idiro's work for one of it's clients.

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

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

Analytics & reporting case study: Pensions Authority

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

The Department of Business Enterprise and Innovation

Data infrastructure and reporting for a government body

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