fc
Data Analyst & Automation Specialist

Turning messy data
into clear decisions

I build data systems, automate reporting workflows, and create dashboards that help organisations act on what their data is actually saying.

10+
Years with data systems
4
Core tools mastered
Spreadsheets automated
0
Tolerance for manual work
Excel Power BI Python AI & Prompting Aviation safety
Scroll
01

About me

I'm a data analyst who finds the story buried in spreadsheets, safety logs, and operational databases — and builds the tools to tell it clearly.

My work sits at the intersection of data engineering and practical business intelligence. I specialise in Excel automation, Python scripting, Power BI, and applied AI — building end-to-end pipelines from raw data to decision-ready dashboards and insights.

I write regularly about data analysis, AI tools, and automation — sharing frameworks that help professionals work more effectively with their data.

Excel & Power Pivot Power BI Python AI & Prompting Aviation safety Reporting automation Data visualisation
10+
Years working with data systems
4
Core tools mastered deeply
Spreadsheets tamed & automated
0
Tolerance for manual reporting
02

Skills & tools

Excel & Office

  • Dynamic arrays (FILTER, SORT, UNIQUE)
  • Power Pivot & data models
  • Power Query (M language)
  • Advanced formulas & VBA
  • Pivot tables & slicers
  • Automated reporting workflows

Business Intelligence

  • Power BI reports & dashboards
  • DAX measures & calculations
  • Interactive safety dashboards
  • KPI design & alerting
  • Data storytelling
  • Executive reporting
≺/≻

Programming & Data

  • Python (pandas, matplotlib)
  • Data cleaning & transformation
  • Predictive modelling
  • SQL & database querying
  • Automated data pipelines
  • Crew & safety report analytics

AI & Automation

  • Advanced prompt engineering
  • Claude, GPT-4, Gemini workflows
  • AI-assisted data analysis
  • Automated report generation
  • LLM integration in pipelines
  • Agentic workflow design
03

Writing & research

Whitepaper · Featured

Developing a Comprehensive Aviation Safety Data Analysis System

A complete framework combining crew reporting analytics, Python pipelines, and Power BI dashboards into a unified aviation safety intelligence system.

Technical framework

Optimising Crew Report Analysis for Enhanced Safety Intelligence

How to connect Excel, Python, and Power BI to extract actionable signals from high-volume crew report and inflight event data.

Excel

Advanced Year-Specific Data Analysis and Filtering in Excel

Master year-specific analysis using dynamic filters, Power Query time intelligence, and professional Excel workflows.

Excel

Unlocking Dynamic Arrays: The Excel Functions Every Analyst Needs

A practical deep-dive into FILTER, SORT, UNIQUE, and SEQUENCE — and why they change how organisations work with data.

Power BI

Building a Dynamic Safety Dashboard in Power BI

Step-by-step guide to designing real-time dashboards that connect live data sources, track risk indicators, and support operational decisions.

Excel · Power Pivot

Mastering Power Pivot: A Game-Changer for Organisational Data Analysis

Build smarter data models, streamline multi-source reporting, and unlock analytical capabilities beyond standard Excel.

04

Aviation specialisation

Beyond general data analysis, I have deep domain expertise in aviation safety data — the specific challenges of crew reporting systems, incident classification, regulatory compliance, and safety performance monitoring.

Aviation generates high volumes of structured and unstructured safety data. I build the analytical infrastructure to make that data meaningful: tracking trends, surfacing early warning signals, and delivering clear reporting for safety management teams and regulators.

This domain expertise means I understand not just the data, but the operational context behind it — which is where the most valuable analysis lives.

Crew reporting analytics Safety management systems Incident trend analysis Regulatory reporting Risk modelling
Domain expertise

Aviation Safety Data Analysis

Crew report ingestion & classification
Safety event frequency modelling
Power BI safety dashboards
Python-based automated pipelines
Regulatory & SMS reporting
Predictive risk indicators
05

Get in touch

Always happy to connect with fellow data professionals, discuss analytical challenges, or explore how I might contribute to interesting projects.

Whether you're working on a data problem, want to discuss something I've written, or simply want to connect — my inbox is open.

I typically respond within a couple of days.