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.

Stylized illustration of the rebuilt HSE analytics dashboard with unified safety KPI indexes
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
Stylized illustration of ~150 fragmented reporting tables consolidated into one scalable data model
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
Stylized illustration of the automated marketing-to-sales funnel dashboard unifying six lead sources
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
Stylized illustration of the management reporting dashboard migrated from HubSpot into Power BI
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
Stylized illustration of the energy monitoring reporting dashboard migrated from Azure Data Explorer to SQL Server
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 · US · UAE · Canada · remote or relocation

Let's talk about your data.

hello@kingsleyandy.comLinkedInDownload CV
Kingsley AndyThe WorkContactCV