Abdikarim Mataan — Data Analyst · Project Manager

01About

The operations
analyst, in brief.

Data analyst and project manager with eight years of operations leadership behind the dashboard. Trained at TU Dublin, sharpened in the field.

The shift

From running operations to running the numbers.

Data Analyst and Training Officer with the EU Training Mission in Somalia. Senior Analyst and Head of Operations for the National Emergency Situations Center (Hot-line). The work taught me that decisions don't wait for a clean dataset — and that the analyst's real job is to make the call clearer, faster.

Now I do the same work — with proper tools.

Operations experience

8

Years leading teams before the dashboard.

Languages

Four.

EN fluent SO native IT reading NL reading

Status

Open.

Full-time & contract.

Data is only as valuable as the insights you extract from it. — Abdikarim Mataan

02Toolkit & Work

The toolkit,
and the proof.

The tools I reach for daily — alongside four real Power BI dashboards I’ve shipped. Hover any card on desktop to bring it forward.

Data Analysis & BI

01

Power BIDaily

DAX · Power QueryDaily

Excel — AdvancedDaily

SQL · MySQLDaily

Python · Pandas, NumPyFrequent

TableauWorking

Project Management

02

Planning & executionDaily

Stakeholder communicationDaily

Agile & productivity toolsDaily

Cross-cultural deliveryDaily

Notion · Systems thinkingDaily

Multilingual reportingEN · SO

Software & Design

03

Microsoft Office SuitePro

AI · ChatGPT, CopilotDaily

PhotoshopWorking

IllustratorWorking

CanvaDaily

UI / UX fundamentalsWorking

Pizza Sales Pizza Sales Dashboard preview

Financial

Tesla

Smoking Risk Smoking Health Risk Analysis preview

03Projects

Four projects,
in detail.

Each project below follows the same structure — objective, problem solved, measurements, and the insight delivered. All four are live, with dashboards published from Power BI.

01

Pizza Sales Dynamic Dashboard

A professional analytics dashboard providing a comprehensive view of pizza sales performance — sizes, categories, daily & monthly trends, plus best- and worst-seller rankings.

ExcelMySQLPower BIDAX

View on GitHub ↗

Pizza Sales Dashboard — Daily & Monthly Trends, % of Sales by Pizza Category and Size

Objective

Analyse key performance indicators for pizza sales to gain insight into business performance — identifying peak hours, top categories & sizes, and seller rankings to drive better decisions.

Problem solved

The shop knew its revenue but not its profile — no clarity on peak hours, best categories, or which menu items were drivers vs drag. Inventory was being ordered on instinct.

Measurements · KPIs

Total Revenue: $817,860
Total Orders: 49,574
Avg Order Value: $38.31
Total Pizzas Sold: 21,350
Avg Pizzas / Order: 2.32

Visualisations & design

Bar Chart — Daily Trend for Total Orders
Line Chart — Monthly Trend
Donut Charts — % Sales by Category & Size
Best / Worst 5 Sellers by Revenue, Quantity, Orders
Slicers — Category filters · Jan–Dec 2026

Pizza Sales Dashboard — Best & Worst Sellers by Revenue, Quantity, and Orders

Insight delivered Orders peaked on Friday and Saturday evenings, with July and January as the strongest months. Classic category and Large size drove maximum revenue. Thai Chicken led on revenue; Classic Deluxe led on quantity and orders. Brie Carre consistently underperformed — a candidate for menu removal.

02

Mataan Stores — Financial Analysis Dashboard

An executive Power BI dashboard delivering a clear, interactive overview of sales performance, profitability, discount strategy, and regional & segment efficiency.

Power BIDAXExcelData Modelling

View on GitHub ↗

Mataan Stores Financial Analysis Report — KPIs, Profit Margin, Discount Bands, Segments

Objective

Evaluate overall financial performance
Identify high & low profit markets
Analyse discount impact on profitability
Compare segment-level margins
Detect seasonal patterns
Highlight top-performing products

Problem solved

Leadership had static P&Ls that didn't surface where the margin was leaking. The dashboard makes country-level, segment-level, and discount-band performance interrogable in seconds — no accountant phone-call required.

Measurements · KPIs

Total Sales: 92,311,095 (+249.46% YoY)
Total Orders: 861,132 (+225.36%)
Total Profit: 13,015,238 (+235.58%)
Profit Margin: 14.1% (−3.97 pp)
Total Discount: 7,059,717 (+229.04%)

Visualisations & design

Bar Chart — Orders & Profit Margin by Country
Donut Chart — % Discount by Discount Band
Bar Chart — Profit Margin by Segment
Line Chart — Sales Amount by Year & Month
Bar Chart — Top 3 Products by Sales
Slicers — Country · Segment · Product

Insight delivered Highest margins came from Germany & France; the United States posted the lowest. Channel Partners was the strongest segment (73% margin); Enterprise ran negative. The majority of sales lived under high discount bands — discount strategy was diluting headline growth. Paseo was the standout product.

03

Tesla Stock & Sales Analysis

An interactive Power BI dashboard analysing Tesla vehicle stock sales, pricing behaviour, mileage trends, EMI financing indicators, and accident-history impact across U.S. states.

Power BIDAXExcelPhotoshop

View on GitHub ↗

Tesla Stock Sales Analysis — Model Y view with state pricing, mileage, EMI, and DAS comparisons

Objective

Analyse Tesla pricing patterns
Evaluate mileage & odometer distributions
Measure EMI (financing) indicators
Assess accident-history influence
Compare regional (state-level) variation
Understand DAS pricing impact

Problem solved

Buyers and analysts saw headlines but not the underlying market structure. The dashboard separates noise from signal — how price, mileage, and accident history actually interact across states and models.

Measurements · KPIs

Average Price: $43.78K
Median Odometer: 27.28K
Average EMI: $706.53
% Without Accident: 1.00
% With Accident: 0.05

Visualisations & design

Bar Chart — Price by State
Bar Chart — Mileage by State
Donut Chart — Avg Price by DAS (Autopilot / Enhanced / FSD)
Central Visual — Dynamic Tesla model image
Slicers — Model · Accident History toggle

Insight delivered Vehicle prices vary significantly by state, reflecting regional market structure. Higher-mileage states show lower prices. Vehicles without accident history dominate listings and price more reliably. FSD-equipped cars consistently command premium pricing. Premium models (Model S, Cyber Truck) carry the highest EMI averages.

04

Smoking Health Risk Analysis Dashboard

An interactive healthcare analytics dashboard exploring the relationship between smoking behaviour, patient demographics, and cardiovascular & metabolic risk indicators.

Power BIDAXExcelPhotoshop

View on GitHub ↗

Smoking Health Risk Analysis — Heart view, Total Patients, Smoking Status, Gender comparison, Cholesterol & Hypertension risk

Objective

Analyse patient demographics & health indicators
Measure smoking prevalence & segmentation
Evaluate intensity across age groups
Compare behaviour by gender
Assess cholesterol & hypertension risk
Enable Healthy vs Damaged organ toggle

Problem solved

Public-health stakeholders had cohort data but no interrogable interface — analysts couldn't filter by age, gender, or smoking status without rebuilding the view. The dashboard makes the cohort dynamic and the story visible.

Measurements · KPIs

Total Patients: 67.0 (Heart cohort)
vs Avg Age: ▼ 53.3
vs Avg BMI: ▲ 30.4
Smoking Status: Never / Current / Former breakdown
Risk Bands: High · Low · Normal

Visualisations & design

Donut Chart — % of Smoking Status
Bar Chart — Smoking Status by Gender
Line Chart — Years of Smoking & CPD by Age Group
Stacked Column — Cholesterol & Hypertension Risk
Dynamic Visual — Heart · Body · Kidney · Liver · Lungs (Healthy ↔ Damaged)

Smoking Health Risk Analysis — Human Body view showing Healthy state with anatomical detail

Insight delivered Current and former smokers represent a significant portion of the patient cohort. Smoking duration (YOS) and consumption (CPD) peak in middle-age groups — not the oldest. Cholesterol and hypertension risk climb with age, but the strongest health signal is duration of exposure, not just volume. The Healthy ↔ Damaged toggle makes the clinical consequence visible at a glance.

04Credentials

Education &
certifications.

Completed and verifiable. Certificates linked through Coursera, Microsoft Learn, and TU Dublin.

Education

04.1

Higher Diploma in Data Analytics

TU Dublin

Completed

Master’s Degree — Project Management

Postgraduate qualification

Completed

Master’s Degree — International Cooperation

Postgraduate qualification

Completed

Bachelor of Business Administration

BBA

Completed

Professional certifications

04.2

Google Data Analytics Professional

Google · Coursera

Certified

Microsoft Power BI Data Analyst

Microsoft · PL-300

Certified

IBM Data Analyst Professional

IBM · Coursera

Certified

Cultures & Interpretations

Cross-cultural collaboration

Certified

05Career

Eight years before
the dashboard.

Operations leadership in environments where bad data had consequences. The analytical mind was earned, not taught.

2022 — Present

Founder

MataanSkills

Educational platform serving learners globally. Active content pipeline and audience growth. Operations, content production, and community management end-to-end.

Operations Content Growth

[Add dates]

Senior Analyst & Head of Operations

National Emergency Situations Center (Hotline)

Led national hotline operations during a public health emergency. Managed staff scheduling, reporting cadence, and inter-agency coordination at scale.

Leadership Operations Reporting

[Add dates]

Data Analyst & Training Officer

EU Training Mission — Somalia

Designed and delivered training programmes for Somali defence personnel. Produced analytical reports for mission leadership on training outcomes and operational metrics.

Training Analysis Reporting

Abdikarim Mataan.

The operations
analyst, in brief.

From running operations to running the numbers.