Power Platform & Solution Engineering

Designing, building and deploying integrated digital solutions - from workflow automation to data analytics and system integrations.
MeasureUp PL-200 Power Platform Functional Consultant Cert Ready badge - Microsoft certification in progress

PL-200 Cert Ready · Power Platform Functional Consultant · Power Automate · Power BI · Power Apps · Azure Logic Apps · SharePoint · Moodle API · Arlo TMS · SurveyMonkey · PowerShell · Selenium

PL-200 Cert Ready - Microsoft Power Platform Functional Consultant (exam in progress)
Power BI Learner engagement dashboards at UCL and IKON
Dataverse Custom data models for UCL tracker and Connecting Carers
Power Automate Automation workflows across UCL, IKON and Scottish Tech Army

About This Work

This section covers the technical and analytical work that sits underneath the learning and training delivery: the automation infrastructure, the data pipelines, the integrations between platforms, and the reporting systems that make operations visible and manageable.

The work spans two organisations - IKON Training and UCL - and several platforms. In both contexts, the starting point is the same: what problem does this solve, for whom, and can it be maintained by someone other than the person who built it?

Solution engineering here means taking ownership of the full lifecycle: requirements gathering, design, build, test, deploy, train, document, evaluate, and iterate. It is not just technical work - it requires stakeholder management, change management, and clear communication with non-technical audiences throughout.

MeasureUp PL-200 Power Platform Functional Consultant Cert Ready badge

PL-200

Microsoft Power Platform
Functional Consultant

Cert Ready - exam preparation in progress. Covers solution architecture, Power Automate, Power Apps, Power BI, and Dataverse - from design through to deployment and evaluation.

Workflow Automation & Solution Engineering

Designing and building automation solutions across commercial training and higher education - from the IKON Digital Transformation (Zapier → Power Automate → Azure Logic Apps → API integrations) to teaching UCL staff to build their own flows.

Covers: Power Automate · Azure Logic Apps · Zapier · REST APIs · JSON · Arlo TMS · Moodle API · SurveyMonkey · SharePoint · Teams approvals · change management

Read More

Data, Analytics & Reporting

Building reporting infrastructure that turns operational data into visible, actionable insight - attendance and engagement monitoring, learner analytics, Kirkpatrick-Phillips evaluation, feedback pipeline design, and interactive data visualisation.

Covers: Power BI · PowerShell · Selenium · SurveyMonkey · Moodle analytics · Kirkpatrick-Phillips · Bokeh visualisation · accessible reporting

Read More

Dataverse Data Modelling

Across both the UCL STEaPP Moodle Engagement Tracker and the Connecting Carers CRM discovery, I designed Dataverse entity models to integrate data across platforms and automate reporting. Dataverse provides a structured, governed data layer that multiple Power Platform apps can read from and write to - replacing fragmented data held in spreadsheets or separate systems with a single, consistent source of truth.

Dataverse entity relationship diagram in the Power Apps maker portal - showing connected tables including Care For, Activities, Emails, Cases, Tasks, Appointments and Teams chats

Dataverse entity relationships mapped during the Connecting Carers CRM discovery - illustrating the breadth of connected activities, cases and communications across the organisation's data model.

Why Dataverse

Rather than storing data in SharePoint lists or Excel files - which are difficult to query and harder to govern - the solutions described on this page use Dataverse as the central data store. This allows different interfaces (Canvas Apps, model-driven apps, Power Pages, Power BI) to read from and write to a single, structured model, with role-based access control and audit logging built in.

What Was Built
  • A Dataverse model for the UCL STEaPP Moodle Engagement Tracker, covering learners, modules, enrolments, Moodle activities, completions, last access, scrape runs and related operational records - feeding into a Power BI reporting dashboard
  • Entity relationship mapping for the Connecting Carers Dynamics 365 / Dataverse environment, identifying data ownership gaps and manual re-entry points during the CRM discovery engagement
  • A model-driven Power App as the administrative configuration interface for the UCL tracker

Tools & Technologies

Automation
  • Power Automate
  • Azure Logic Apps
  • Zapier
  • Power Apps
  • SharePoint workflows
Integration
  • REST APIs
  • JSON / HTTP connector
  • Moodle API
  • Arlo TMS API
  • SurveyMonkey API
  • OpenAI connector
  • SendGrid
Data & Analytics
  • Power BI
  • PowerShell
  • Selenium
  • Office Scripts / VBA
  • Bokeh (Python)
  • Moodle analytics
  • SurveyMonkey reporting
Platforms & Storage
  • SharePoint
  • Microsoft Teams
  • OneDrive
  • Moodle LMS
  • Arlo TMS
  • GitHub
  • Azure

For the AI integration strand that intersects with this work, see AI for Learning & Assessment.