Revenue?
Q3 vs Q3?
which number?
two sources, two answers
MRR ≠ MRR
churn = ?
last updated: ?
the numbers look off
who owns this?
can we trust this?
that's not what finance said
Report_v7_final_FINAL
Dashboard (old)
Copy of Copy
manual export
pending review
stale data
board meeting Monday
no single source of truth
flying blind
missed target
gut feeling
#REF!
NULL
Sheet3
No Visibility · Unreliable · Too Late

Every business is drowning in data it can't trust.

Scroll to bring it into focus↓
Skip story → view the work
01 · Ingestion

Kingsley Andy: I build order out of this.

He leads the BI function at 10Alytics, owning the reporting stack end to end: ingestion, warehouse pipelines, semantic models, executive dashboards, and the automation that keeps it all running. As co-founder of Duten Nexa, he delivers the same discipline for international clients direct.

B.Sc. Mathematics & Statistics. Microsoft Certified Data Analyst. Has trained 200+ professionals, including teams at Kuda Bank and InfraCredit, to bring the same rigor to their own numbers.

02 · Modeling

Structure emerges.

Every scattered source gets a place in one model: a semantic layer that turns disagreement into a single trusted number.

Semantic Layer
BI & Analytics
Power BIDAXPower QueryLooker Studio
Data Engineering
SQLPostgreSQLBigQueryAirbyte
Automation & Apps
Power AutomatePower AppsApps ScriptReact
Sources & Systems
HubSpotZoho CRMGA4Meta Ads
03 · Clarity

The numbers you can trust.

Five real projects, five messes resolved into one reliable read for leadership.

Power BIDAX
Enterprise HSE Analytics Platform
Audited and rebuilt a Gulf safety platform's KPI engine so every dashboard reports one trusted number.
4
indexes rebuilt
1
formula layer / measure
AVP
presented at
View case study →
Power BIPower Query (M)DAX
150 Reporting Tables into One Model
Collapsed ~150 per-cohort tables and ~190 duplicated measures into one scalable model.
150 → 1
tables
~190 → ~9
measures
158
queries fixed
View case study →
Google Apps ScriptZoho CRM APIGoogle Sheets
Marketing → Sales Funnel Engine
Automated engine unifying six sources into one funnel view, refreshed around the clock.
31,000
leads deduped
6
sources unified
2 hrs
refresh
View case study →
Power BIHubSpot APIIncremental refresh
HubSpot CRM → Power BI Migration
Moved a New Zealand client's management reporting off native dashboards onto an owned BI platform.
5.0★
client rating
Upwork → Direct
relationship
12h
time gap bridged
View case study →
Power BIPower QuerySQL Server
Energy Monitoring Platform Migration
Migrated a monitoring reporting layer from Azure Data Explorer to SQL Server with no rebuild of the downstream reports.
ADX → SQL
migration
0
report rebuilds
View case study →
04 · The Storyteller

Behind every clean dashboard, someone who can explain why it's right.

Kingsley Andy is a Business Intelligence Team Lead and Analytics Engineer based in Lagos, Nigeria, with 5+ years turning messy, disputed numbers into reporting leadership trusts across EdTech, Fintech, HSE, and CRM analytics.

PL-300 CertifiedB.Sc. Mathematics & StatisticsMBA, Marketing — expected 2027Upwork Top Rated · 100% JSSMVP Award, 10Alytics 2025200+ professionals trained
★★★★★
“Kingsley continues to deliver outstanding results, even when faced with highly complex data and processes.”
Power BI reporting client · New Zealand
★★★★★
“His problem-solving skills enabled us to seamlessly navigate challenges despite a 12-hour time difference.”
HubSpot dashboards client · New Zealand
★★★★★
“His communication was great throughout and he is super pleasant to work with.”
Power Automate client · Singapore
Open to opportunities: UK · UAE · Canada · remote or relocation

Let's talk about your data.

hello@kingsleyandy.comLinkedInDownload CV
Kingsley AndyThe WorkContactCV