Projects.

Built ingestion pipelines from Infor Syteline and SAP Cloud, transforming data with PySpark in a medallion architecture shaped around how the business actually works. Includes a configurable data quality engine with per-rule, per-column validation.

The semantic model uses DirectLake with complex row-level and column-level security and advanced DAX analytics. We trained five analysts and department heads along the way, so the platform outlasts the engagement.

• Microsoft Fabric
• PySpark
• DAX
• Power BI
• DirectLake
• SAP
• SQL Server
• Python

Migrated the reporting stack from a maze of exports and spreadsheets to a Microsoft Fabric platform with Power BI on top. Reports now run against billions of rows spanning purchases, funnels, regional breakdowns, and marketing spend. A second report covered occupancy, revenue, and booking behaviour.

The numbers finally agree with each other, and the team that looks at them has doubled in size and capability.

We also trained five junior analysts in SQL, data analysis, and Power BI over the course of the engagement. Row-level security was configured so each regional team only sees the markets they own.

• Microsoft Fabric
• Power BI
• BigQuery
• PySpark
• T-SQL
• DAX
• Row-Level Security

Built Power BI reports with calculation groups, dynamic format strings, and a contemporary UX. Scope covered revenue, gross profit, AOV, and units by team and segment, alongside full P&L, cash flow, balance sheet, and covenant tracking. Rolling LTM analysis and per-rep appendices.

• Power BI
• DAX
• Dataflows
• Calculation Groups
• Data Modelling

Troubleshot and stabilised a set of failing Azure Data Factory pipelines during a move onto Dynamics 365. Then rebuilt the reporting layer so the operational and fundraising teams had reliable visibility of their numbers post-migration.

• Power BI
• Azure Data Factory
• Dynamics 365
• DAX
• Dataflows

A full data migration from Care NG to Beacon CRM, covering millions of historical supporter records built up over decades of fundraising. We rebuilt the data model, wrote the transformation and validation logic, and ran iterative rounds of reconciliation with the fundraising and supporter care teams to catch the edge cases that only they knew about.

Data quality lifted from roughly 30% to 90% against a set of field-by-field rules we agreed with the client up front.

Beyond the migration itself, we embedded a data-quality culture across the team: written standards for data capture, training sessions, and a set of operational reports that now sit inside daily workflows rather than being run once a quarter and filed away. By the end, the team was running the new system themselves, with a clearer sense of what good data looked like than when we started.

• Beacon CRM
• SQL
• Power BI
• Data Migration
• Data Quality
• Training

Multi-stage pipeline pulling from Dynamics 365 through DAX Studio exports and MariaDB for SQL transformations, then recombining with SharePoint sources to produce campaign-ready datasets with consent fields intact. Built supporting Power BI dashboards and data quality checks.

• SQL
• MariaDB
• Power BI
• DAX Studio
• Dynamics 365
• SharePoint

Built Azure Data Factory pipelines processing CSV exports into Dataverse. Months of careful cleansing and deduplication using Power BI, Airtable, SQL, and C#. We led hypercare after go-live, then rebuilt the cross-departmental reporting suites.

Data quality elevated by 90% against the client's own acceptance criteria.

• Azure Data Factory
• Dynamics 365
• Power BI
• SQL
• C#
• Dataverse

Trained junior analysts in Power BI, SQL, and data system design. Delivered reporting strategies through a major organisational restructure. Over a dozen reports freed care staff to spend more time on residents than on paperwork. We also built a .NET API that replaced a two-week manual process.

• Power BI
• SQL
• DAX
• .NET API
• Data Strategy
• Training