Available for freelance · Dublin & remote

Hi, I'm Rijo. I build dashboards people use, SQL that tells the truth, reports in plain English and models that forecast.

Got a spreadsheet nobody wants to open? Send it my way. I'll turn it into clear dashboards and reports your team can act on, with every number checked at the source and explained in plain English. Dublin-based · Power BI, SQL and a bit of Python.

Portfolio projects
3
Certifications
4
Degrees, MSc & BSc
2
Typical reply
< 24h
sample_report.pbix demo data

Weekly sales

Week 6 is the standout. It's worth asking what went right and doing it again.

select * from about_me

About

Hi, I'm Rijo. I studied maths back home in Kerala, came to Cork for an MSc in Business Analytics, and found out my favourite part of the work isn't the formulas.

It’s the moment someone looks at a chart and says, “Oh, so that’s what’s been going on.”

about_me1 row
name
Rijo Johnson
based_in
Dublin, Ireland
work_auth
Stamp 1G, eligible to work full-time
education
MSc Business Analytics, UCC
BSc Mathematics, MG University
availability
Freelance & contract, remote or on-site in Dublin
reply_time
Usually within a day

That moment, in five seconds

Messy export in. Clear answer out.

Example data
sales_export_FINAL_v3.xlsx6 rows · 5 problems
Example sales export, before and after cleaning
rowA · dateB · storeC · itemD · sale
103/02/20243 Feb 2024DublinLatte€4.50
22024-02-033 Feb 2024dublinDublinlatteLatte4.5€4.50 duplicate
3Feb 33 Feb 2024CorkWrap€7.00
403-02-243 Feb 2024CORKCorkLatteblank⚑ no price
503/02/20243 Feb 2024DublinWrap€7.00
63/2/243 Feb 2024DublinLatte€45.00€45 €4.50

The question

Which store sold more on 3 Feb?

Dublin?€16.00
Cork?€7.00

1 Cork sale with no price yet

From this spreadsheet? Honestly, hard to say.

Dublin took €16 and Cork €7, but one Cork sale has no price, so the gap is probably smaller than it looks.

5 date formats✓ one date format mixed-up store names✓ names matched a duplicate row✓ duplicate removed a €45 latte?✓ €45 → €4.50, checked a sale with no price⚑ missing price flagged

Who I build for

The restaurant floor

I've worked a busy restaurant floor, so I know most reports get read by people with ten other things to do. That's who I build for. My QSR dashboard starts with the question every shift manager actually asks: when do I need more hands?

ShowsDesigning for busy people

Business ↔ tech

The go-between

At Murickens Trading I was the go-between for the business and the tech team. I learned how each team really worked day to day, then built dashboards with short guides so people could find their own answers instead of waiting on someone.

Shows

Where I am now

The pattern-spotter

Now I work in security at AIB. It isn't a data job, but I still can't help noticing patterns. When the same customer questions keep coming up, I write them up for the team who can fix the cause.

ShowsSpotting patterns

Working with me

Straight answers

Working with me is simple. I ask a lot of questions up front, check numbers at the source, and explain everything in plain English, something I first learned as a cadet captain in the National Cadet Corps, organising blood donation camps. If your data looks off, I'll tell you, even when it's awkward.

ShowsAsking good questionsChecking at the sourcePlain English

If your spreadsheets have turned into a second job, send me a couple of lines. I'll reply within a day and tell you honestly whether I can help.

Send me a couple of lines

select service from what_i_can_do

How I can help

Four things I'm good at, and happy to do for teams that want answers rather than more spreadsheets.

Power BI dashboards

From scattered exports to a clean star-schema model, tidy Power Query steps and DAX measures. The result is a report your team actually opens every morning.

  • Data model and report pages
  • Measures explained in plain English
  • A short how-to guide for your team

Excel & reporting clean-up

Spreadsheets that have grown out of hand, rebuilt into reliable, refreshable reports, with every number checked at the source.

  • Structure and formulas you can trust
  • Weekly or monthly reports that repeat
  • Far fewer copy-and-paste steps

SQL & data analysis

A specific business question answered with SQL or Python (joins, trends, drivers) and written up so anyone can follow the reasoning.

  • Queries you can re-run later
  • Findings in plain English
  • Charts that make one point well

Requirements & process mapping

Not sure what you need yet? I'll sit down with your team, map how things work today, and turn it into a clear plan everyone agrees on.

  • Process maps and pain points
  • User stories and acceptance criteria
  • A plan everyone signs off on

How a project runs

1

A quick chat

We talk through the problem and what a good result looks like. No jargon, no hard sell.

2

Check the data

I look at what you have, check numbers at the source, and flag anything odd early.

3

Build and review

You see work in progress early and often, so nothing is a surprise at the end.

4

Hand over and explain

You get the files, a short guide and a walkthrough, so your team can run with it.

select proof from skills where skill = :picked

Toolkit

Pick a skill and I'll show you where I've actually used it: projects, roles, certificates and study.

select * from projects order by impact desc

Projects 3 rows

Each one opens into the full story: the problem, what I did, and how it turned out.

select role, org from experience order by start desc

Experience 2 rows

Sep 2024 to Oct 2024

Artificial Intelligence Intern

Corizo, Bangalore

Used Python (pandas, matplotlib) to explore large datasets and surface behavioural trends and performance drivers. Built interactive BI dashboards and Excel reports for non-technical audiences, plus regression and classification models to automate workflows.

PythonpandasBI dashboardsExcelML models
Sep 2022 to Sep 2023

Business Analyst

Murickens Trading Company

Gathered requirements across teams and turned conversations into clear, agreed plans. Mapped day-to-day processes, spotted bottlenecks and proposed practical fixes. Acted as the bridge between business and tech, and shipped self-serve dashboards for sales, inventory and supplier costs, with guides so people could find answers themselves.

RequirementsProcess mappingPower BIStakeholders

select degree, field from education

Education 2 rows

MSc, Business Analytics University College Cork

Where the maths met the business: turning data into decisions.

Business Data Analysis & VisualizationPredictive & Prescriptive AnalyticsPython for Business AnalyticsEnterprise Business ProcessesDesign Thinking
BSc, Mathematics Mahatma Gandhi University

The foundation: logic, proof and a love of patterns.

Probability & StatisticsLinear AlgebraNumerical MethodsMathematical ModellingDiscrete Mathematics

select name, issuer from certifications

Certifications 4 rows

Power BI Data Analyst Professional CertificateMicrosoft
Certified ScrumMaster (CSM)Scrum Alliance
Google Data AnalyticsGoogle
Getting Started with CybersecurityIBM

insert into inbox (your_project)

Let's build your next dashboard.

Got a dashboard that needs building, a spreadsheet that's gotten out of hand, or numbers nobody can quite agree on? Drop me a line. I read every message, I'm friendly, and I usually reply within a day.

Based in Dublin, Ireland.

Tell me about your project

Pick what fits, add a line or two, and I'll write back.

What do you need?

Your message comes straight to my inbox. I only use your details to reply to you.

Case study