I'm a UK-based statistician by training with seven years’ experience across data analysis, business intelligence and digital entrepreneurship. I use SQL, data modelling and BI tools to turn operational, customer and commercial data into reliable reporting and decision-ready insight.
I'm also a creator and digital educator who has built a 313K+ cross-platform audience through educational content and digital products.
Hi, I'm Tess Ogamba 👋🏾
Data Analyst & BI Developer
Core Analytics toolkit
SQL • Python • Excel • Power BI • Tableau • Looker Studio • Data Modelling • ETL • Data quality
Case Management BI & Reporting Pipeline
Production BI solution spanning 3M+ records, combining SQL extraction, Power Query transformation, dimensional modelling, DAX and data-quality controls to deliver reliable operational and performance reporting. Reduced annual reporting turnaround by over 50%, moving core preparation from multiple weeks to a matter of days.
Retail Customer & Sales Analytics
Built a tested retail data pipeline in dbt Cloud and Snowflake, transforming raw customer, order and payment data into dimensional models for customer and sales analysis in Tableau.
Financial Performance Analytics
Analysed 23 financial metrics across 12 public companies using BigQuery and reusable SQL models, with data-quality tests and an interactive Looker Studio dashboard covering growth, profitability and financial risk.
Selected data and analytics work. Full code on GitHub.
Featured Analytics Projects
Frameworks & Publications
A Data & Analytics Audit Framework for Nonprofits
A practical 23-page framework for assessing data maturity, governance, data quality and analytics capability, with a structured roadmap for implementation and improvement.
Expertise
Business Intelligence & Reporting
Turning complex operational data into trusted dashboards, KPI frameworks and decision-ready reporting for business and organisational teams.
Designing analytical data models, ETL workflows, data-quality controls and BI solutions using SQL and modern reporting tools.
Commercial & Customer Analytics
Data Modelling & BI Development
Analysing acquisition, engagement, customer behaviour, revenue and performance to identify the factors driving growth and commercial value.
About Tess Ogamba
I’m a UK-based Data Analyst and BI Developer with a BSc in Biostatistics and seven years’ experience across quantitative research, programme delivery, digital entrepreneurship and business intelligence.
My career has followed one consistent pattern: understanding how organisations, customers and systems work, using data to identify opportunities for improvement, and translating that insight into clearer reporting and better decisions.
Today, I work in operational, customer and commercial data, combining SQL, data modelling, data-quality practices and BI tools with practical experience in audience growth, digital products and online education.
From the Blog
Practical articles on business intelligence, data quality, reporting, commercial analytics and better decision-making.