Welcome To My Workspace
Full-Stack
Data
Analyst/Scientist
Transforming raw data into strategic insights. I architect dashboards, build predictive models, and turn complexity into clarity for data-driven businesses.
Power BI
SQL Server
PostgreSQL
Python
MySQL
R
Excel
001 / About Me
Turning Data Into
Decision Power
I'm a Senior Data Analyst with 6+ years of experience working across finance, e-commerce, and SaaS industries. I specialise in building end-to-end analytics pipelines — from raw data ingestion to executive-ready dashboards.
My work bridges the gap between engineering and business strategy, translating complex datasets into actionable narratives that drive revenue and operational efficiency.
6+
Years Experience
50+
Projects Delivered
30+
Dashboards Built
12
Happy Clients
002 / Expertise
Skills & Capabilities
Every tool in my stack is chosen for impact. Here's what I bring to the table.
Power BI
Enterprise dashboard design, DAX, data modelling, Power Query
Python
Pandas, NumPy, Matplotlib, Scikit-learn, data pipelines
SQL / T-SQL
Complex queries, stored procedures, performance tuning
Excel & VBA
Advanced modelling, pivot tables, automation macros
PostgreSQL
Relational schema design, window functions, CTEs
R / Statistics
Statistical modelling, ggplot2, A/B testing, regression
AWS / Azure / GCP
Azure Data Factory, BigQuery, Synapse Analytics, cloud pipelines
Data Storytelling
Translating analytics into executive narrative and strategy
Microsoft Fabric
Unified data analytics, lakehouse architecture, data engineering, real-time analytics
Google Sheets
Collaborative spreadsheets, formulas, dashboards, and data analysis
Google Apps Script
Automation, custom workflows, triggers, and Google Workspace integration
Google Looker
Semantic modeling, governed BI dashboards, exploration, and reporting
Google AppSheet
No-code app building, mobile workflows, approvals, and automation
Git
Version control, CI/CD, Github Action, codespaces, Collaboration, Workflows, State Management and Security
Kubernetes
containerization, container orchestration, GitOps, DevOps, Monitoring (Prometheus/Grafana)
003 / Tech Stack
Tools I Master
004 / Certifications
Certification Showcase
A selection of certifications that back up the tools, latforms, and analytics workflows I use.
005 / Portfolio
Featured Projects
A selection of data projects that delivered measurable business outcomes.
Google Workspace
Real-time Inventory Management App
Real-time inventory management app that automatically alerts warehouse teams when stock hits reorder levels — eliminating stockouts and reducing manual stock-checking time by up to 80%.
Looker StudioAppScriptAppSheetGoogleSheetJavaScript
Power BI
Sales Performance Dashboard
End-to-end Power BI solution tracking KPIs across 7 regions, enabling regional managers to self-serve insights and reduce reporting overhead by 60%.
Power BIDAXMs Excel
Python
Customer Churn Prediction
Machine learning pipeline using gradient boosting to predict customer churn with 89% accuracy, saving an e-commerce client an estimated £240k annually.
PythonScikit-learnPostgreSQL
T-SQL . Power BI
NHS Inpatient Analytics
A complete intelligence layer built on 22.5 million NHS inpatient episodes across 590 NHS providers organisations. Business requirements, clinical insights, data profiling, and report design — all in one place
Power BIT-SQLCSV
R
A/B Testing Framework
Built a reusable statistical testing framework in R for a SaaS product team, enabling data-driven feature decisions with rigorous power analysis and significance testing.
RStatistics
Python · Excel
Supply Chain Analytics
Python-powered supply chain optimisation model identifying £1.8M in excess inventory across 12 warehouses and automating weekly reorder recommendations.
PythonMySQLExcel
BigQuery · PowerBI
Marketing Attribution Model
Multi-touch attribution analysis across 9 channels using BigQuery and Tableau, revealing a 40% reallocation opportunity in the digital marketing budget.
BigQueryPowerBIPython
Ms SQL · PowerBI
Business Performance Dashboard
End-To-End PowerBI/SQL Solutions tracking KPI's across Revenue, Profit, Season, Time and client's Demographic helping business to make a fail-proof infomed decisions that increase revenue by 15%.
MsSQLPowerBIPython
BigQuery · Tableau
Alcohol-Related Death Analysis- NHS UK
This project analyzes alcohol-related deaths in the UK, providing insights into trends and contributing factors with insight that can reduce mortality rates by 40% over 5 years.
BigQueryTableauPython
T-SQL · Excel
Operations Revenue Analysis
T-SQL Project analysing SaaS recurring revenue across employee hierarchy, customer lifecycle, and subscription MRR events using recursive CTEs, window functions, and CROSS APPLY
T-SQLExcel
Langchain · FAISS . PyPDF
Education RAG App
A Retrieval-Augmented Generation (RAG) system that allows students and staff to query university policy documents in natural language, with cited sources saving students, staff and university administrators 30% on time spent and cost on losses due to misinformation
PythonLangChainFAISSPyPDFStreamlitOpenAI. API . Embeddings
LLM. RAG · FastAPI
RAG Pipeline for PostgreSQL Queries
Custom RAG pipeline over direct PostgreSQL queries — no embedding costs, no stale indexes, no extra infrastructur.
FastAPINext.js 16PostgreSQL
R · Statistical Analysis
HESA Graduate Earnings & Occupational Analysis
A rigorous quantile-regression analysis of 229 UK higher education providers, linking occupational outcomes from HESA Dataset.
quantile-regressionNGROKStatistics
PyTorch · Computer Vision
Medical Image Classification (CNN)
Deep learning pipeline using ResNet-50 architecture classifying chest X-rays for pneumonia detection with 94% accuracy, integrated with a Flask API enabling clinicians to batch-process 1000+ images daily.....Ongoing
PyTorchResNet-50FlaskOpenCV
Transformers · NLP
Multi-Language Sentiment Analysis (BERT)
Fine-tuned BERT model analyzing customer reviews across 8 languages with 91% F1-score, processing 500k+ reviews monthly to extract actionable product feedback and competitive intelligence......Ongoing
HuggingFaceBERTSpaCyPostgreSQL
EDA · Visualizations · Storytelling
Sales Method Analysis
A complete exploratory analysis of three sales strategies — Email, Call, and Email + Call — across 15,000 customer records from a 6-week new product launch at Pens & Printers
PandasSeabornMatplotlibEDA
Scikit-learn · Binary Classification
Binary Classification Predictive Model
A predictive model for a food chain to predict trafficon their recipe menu with 32.8% improvement in accuracy over random methods
Machine LearningBinary ClassificationPythonLogistic Regression
006 / Contact
Let's Work
Together
Whether you need a full analytics strategy, a Power BI overhaul, or a quick data audit — I'd love to hear about your challenge.
LinkedInlinkedin.com/in/tunji-ologun
GitHubgithub.com/gatemediang
LocationManchester, UK · Remote Available