Client reference
Aliancia sektorových rád
Aliancia sektorových rád is a Slovak association founded by the ministries of labour and education together with employers, trade unions and municipalities. It runs 24 sector councils that track labour market needs and feed them into the national classifications of occupations and qualifications.
Problem
Comparable data from employers across 24 sectors
Solution
A public Power Pages survey with data in Dataverse
24
Sectors of the economy in one data collection
110
Questions across 24 forms
770
Numeric cells with automatic totals
0
Accounts an employer has to create
The association needed to find out how ready Slovak employers are for an ageing workforce, in numbers comparable between companies and across 24 sectors. SBID built a public survey on Power Pages. An employer signs in with a company ID and a code from their inbox, fills in only what applies to them, and the answers land in Dataverse ready for analysis.
Problem: a survey you cannot send as a spreadsheet
Workforce age profile, sick leave, health checks, training, benefits and social dialogue. The association needed all of it from hundreds of employers in a form comparable across sectors. The survey grew to 8 sections, 24 forms and 770 numbers in tables. Sending it out as a spreadsheet would have meant collecting dozens of differently filled-in versions and merging them by hand.
Solution: a public survey the association manages itself
SBID built the survey as a public Power Pages site with data in Dataverse. The association creates an employer, access goes out by email automatically and the employer fills the survey in without registering. The solution covers:
- Sign-in: company ID and an emailed code, no accounts to create
- Scope: each employer sees only the sections that apply to them
- Tables: totals calculated while typing, required fields checked by the form
- Questions: stored as data in Dataverse, not in the site's code
- Administration: a model-driven app for employers, questions and answers
- Automation: 7 Power Automate flows between the site and Dataverse
Result: comparable data from 24 sectors
- Every employer's answers in one structure, ready for analysis
- Employers fill in only their own scope, so they finish the survey
- Missing or inconsistent numbers are caught by the form, not by an analyst afterwards
- The association adds a new question itself, with no deployment and no developer
- The same tool serves further rounds of data collection
What we used on this project
