Detailed project case study

simplehuman BI Migration, SQL Upgrade & Sage 200 Data Work

A BI and data-platform modernisation spanning Power BI adoption, SQL Server upgrades, Sage 200 migration and ETL development.

Portfolio headline

Supported a BI and data modernisation including Power BI adoption, SQL Server upgrades, Sage 200 migration, ETL development and user training.

01

Context

Ageing SQL infrastructure, legacy reporting and a business-system migration created risk around data access, recovery, validation and user adoption.

02

My mandate

Supported a BI and data modernisation including Power BI adoption, SQL Server upgrades, Sage 200 migration, ETL development and user training.

03

Scope

  • Business systems / data platform
  • Data & BI
  • simplehuman

Selected technologies

  • Power BI
  • SQL Server 2008 / 2016
  • ETL
  • Sage 200
  • Backup and recovery
  • Data migration
  • Data auditing
  • User training
04

Key decisions

  • Helped establish Power BI as the new reporting tool and delivered more than 20 training days and workshops.
05

What the team delivered

  • Upgraded SQL Server 2008 components to SQL Server 2016 and improved backup and recovery.
  • Supported Sage 200 migration and built ETL processes for validation, auditing and reporting.
06

Outcome

20+Training and workshops

Training days and workshops supporting adoption and transfer.

Evidence available in interview.
  • Modernised the reporting and database foundation.
  • Improved recovery, data quality and migration assurance.
  • Built user confidence through hands-on workshops and knowledge transfer.
07

Evidence

Public details are limited to the operational record and outcomes that can be discussed safely. Supporting evidence is available in interview where appropriate.

08

What this demonstrates

This engagement connected data delivery with platform ownership and became the bridge into wider technology and operational leadership at simplehuman.