MICHAEL OWUSU AGYEKUM

Data made clear.
Systems made useful.

I’m Michael, an aviation data professional specialising in Excel automation and reporting. I clean and validate operational data, build repeatable reporting workflows, and develop digital tools through PEOPB in Accra, Ghana.

AVIATION DATAAUTOMATIONPRODUCT BUILDING
BASED IN ACCRA, GHANA05°33′N 00°12′W
Michael Owusu Agyekum wearing a blue jacket
Michael Owusu AgyekumFounder & Technical Lead, PEOPB

WHERE MY WORK CONNECTS

Aviation operationsData & business intelligenceDigital products

01 / SELECTED WORK

Practical problems.
Working solutions.

From daily flight records to a live church platform, my work starts with the people who'll use what I build.

AVIATION / DATA QUALITY02

Making flight data
ready for decisions.

Daily flight-data validation and reporting that supports billing, corporate planning, and operational decisions at the Ghana Civil Aviation Authority.

  • Excel
  • Power Query
  • Power BI
  • DAX
Read the case study

The problem

Daily operational records need to be checked, cleaned, and made consistent before other teams can rely on them.

My approach

I work with flight movement data, validate records, investigate anomalies, and prepare reports. Automated checks help flag errors before data is passed to other departments.

The value

A repeatable process for turning daily records into information that Billing and Corporate Planning can use.

AUTOMATION / WORKFLOW03

Less repetition.
More useful work.

Excel and VBA workflows for compiling flight-data files, checking what has already been imported, and adding new dates in sequence.

  • Excel
  • VBA
  • Power Query
Read the case study

The problem

Compiling files across months creates repetitive work and a risk of importing the same dates again.

My approach

I developed an incremental compilation workflow that uses the flight-date field to check existing dates, skip dates already included, and continue adding new files.

The value

A cumulative dataset that can be updated without rebuilding the full year from the beginning.

Aviation projects are described at workflow level. Operational records are kept private.

02 / SERVICES

Make your reporting
repeatable.

Excel Automation & Reporting Specialist
Power Query · VBA · Power BI

If your team works with recurring Excel or CSV files, I can help turn the process into a reliable workflow—from cleaning the source data to producing the final report.

01 / AUTOMATE

Excel reporting automation

Reduce repetitive copying, merging, and formatting when preparing recurring spreadsheet reports.

  • Excel/VBA or Power Query workflows
  • Recurring file consolidation
  • Refresh instructions and a clear handover

Related work: flight-data compilation

Discuss automation
02 / VALIDATE

Excel & CSV data cleaning

Make inconsistent operational records ready for analysis with clear formatting and data-quality checks.

  • Cleaned, consistent datasets
  • Validation and error checks
  • Exception lists for records needing review

Related work: flight-data validation

Discuss data cleaning
03 / REPORT

Power BI operational dashboards

Bring recurring operational figures into clear views that help teams understand their activity and performance.

  • Operational KPI views
  • DAX measures and clear visuals
  • Refresh guidance for recurring reporting

Related experience: operational reporting

Discuss a dashboard

One connected process

Clean and validate the files. Automate the recurring steps. Produce a report or dashboard the team can use.

Aviation experience. Services for operational teams across industries.

03 / THE PERSON BEHIND THE WORK

I work where
operations meet
technology.

Accra, Ghana · Working across data and technology

My background is in Information Technology. My daily work is grounded in aviation. Building useful systems brings the two together.

At the Ghana Civil Aviation Authority, I work with flight data that other departments depend on. Through PEOPB, I build digital solutions, including Aseda Church Suite.

I care about getting the details right, understanding the workflow, and making technology useful to the people doing the work. That perspective also shapes my involvement in church technology and media.

EDUCATIONBSc Information Technology
COMPLETEDGoogle Data Analytics Professional Certificate
CONTINUING TO BUILDSQL & Python skills
Meet PEOPB

04 / LET’S CONNECT

Have a role, a project,
or a useful problem?

Tell me about your data files, reporting process, and the outcome you need. I’m also interested in data and technology roles with international teams.