Detailed project case study
Secure HR Analytics & Encrypted Reporting
A protected HR reporting solution combining API extraction, encrypted warehouse storage and controlled access to salary data.
Built secure HR reporting with encrypted data handling and controlled Power BI access, protecting sensitive fields while improving people insight.
Context
HR needed better reporting visibility across sensitive people and salary data. Access had to be tightly controlled from ingestion through storage, modelling and presentation.
My mandate
Built secure HR reporting with encrypted data handling and controlled Power BI access, protecting sensitive fields while improving people insight.
Scope
- Sensitive departmental data
- Data & BI
- Softcat
Selected technologies
Key decisions
- Extracted HR data through APIs and moved it through controlled SSIS pipelines.
What the team delivered
- Used encrypted warehouse storage, SQL functions and stored procedures for sensitive fields.
- Applied Power BI parameters and access rules to control salary visibility.
Outcome
- Improved HR reporting while protecting sensitive information.
- Created clearer separation between general people insight and restricted salary data.
- Embedded GDPR-aware controls throughout the reporting flow.
Evidence
Public details are limited to the operational record and outcomes that can be discussed safely. Supporting evidence is available in interview where appropriate.
What this demonstrates
The project shows that useful analytics and strong data protection can be designed together, rather than treating security as a final reporting-layer check.