SkyAnalysis — Godwin Thompson, Data Analyst
Godwin Thompson  ·  SkyAnalysis

I build dashboards
people actually
use.

Practical SQL, Excel, Python, and Power BI analytics for questions that need a clear answer, not just a chart. Based in Lagos, working with data wherever it lives.

SKY
Data Analytics Expert
18
End-to-End Projects
6
Analytics Roles
NG
Based in Nigeria
Tools & Platforms
SQL Python Power BI PostgreSQL DAX Streamlit Git & GitHub
What I Do

I turn raw data into decisions someone can act on.

I own analytics projects end to end — from a messy raw dataset through to a dashboard a non-technical stakeholder can open and actually understand.

🗄️

SQL & Data Modeling

Joins, subqueries, and window functions against PostgreSQL and SQLite, structured into clean star schemas built for reporting.

📊

Dashboards & Reporting

Interactive Power BI dashboards with DAX and proper data modeling, Tableau, Excel, and Streamlit. Built for executives and non-technical audiences, not just other analysts.

📈

Forecasting & Anomaly Detection

Time-series decomposition, statistical anomaly detection, and forecast models validated against real holdout data before anyone trusts the number.

The Way I Work
  • Built for the stakeholder who has to explain it later
  • Validated against real data, not assumed correct
  • Documented — assumptions and limitations included
  • Version-controlled, issue-tracked, reproducible
  • AI-assisted, but never AI-trusted blindly
  • Clear enough that the chart doesn't need a caption
"Good analysis should change what someone decides to do next."
Selected Work

Three problems, three end-to-end builds.

Each project below went from raw data through SQL and Python to a dashboard or app a stakeholder actually opens — built at Infotact Solutions & Co.

01
CAC, CPC & ROAS by channel, toggle between attribution models

Multi-Touch Marketing Attribution

Replaced last-click attribution bias by merging ad spend, web analytics, and CRM conversion data with SQL window functions, sequencing each customer journey, then building a Power BI dashboard that lets managers toggle between First-Touch, Last-Touch, and Linear models.

SQLWindow FunctionsPower BIDAX
View on GitHub →
02
12-month CLTV by segment, retention mapped month over month

Cohort Retention & CLTV Analysis

Grouped users by acquisition month in Python and PostgreSQL to identify exactly when churn happens, built a retention heatmap, and calculated 12-month Customer Lifetime Value by segment — delivered as a four-page Power BI dashboard and a published LinkedIn article.

PythonPostgreSQLPower BI
View on GitHub →
03
Prophet forecast beat baseline and ARIMA — 22.8% MAPE vs. 27.7% / 28.1%

Supply Chain Demand Forecasting & Anomaly Detection

Decomposed daily sales into trend, seasonality, and residuals, benchmarked Z-score, IQR, and Isolation Forest anomaly detection against decomposition residuals to cut false positives, then validated ARIMA and Prophet forecasts with chronological train/test splits — shipped as an interactive Streamlit app.

PythonstatsmodelsProphetStreamlit
View on GitHub →
How I Work

From raw data to a decision someone can trust.

Every project I ship follows the same process, whether it's a two-day dashboard fix or a four-week forecasting pipeline.

01

Understand the Question

Before writing a single query, I get clear on what decision the analysis actually needs to support — and who's making it.

02

Clean & Structure the Data

Missing values, inconsistent timestamps, duplicate records — resolved and documented, with assumptions stated up front, not buried.

03

Explore Before Concluding

Trend, seasonality, and residuals get looked at before I trust any pattern — a spike is often seasonality, not a signal.

04

Test, Don't Assume

Multiple methods benchmarked against each other, validated on real holdout data — the model that wins on paper has to prove it first.

05

Build for the Reader

Findings become a Power BI dashboard or an interactive app a non-technical stakeholder can open and use without me in the room.

06

Document Every Decision

Assumptions, limitations, and reasoning get written down — version-controlled on GitHub, not left in my head.

Godwin Thompson
Business Intelligence Analyst

A data analyst who owns projects end to end — from writing SQL against relational databases to building Power BI dashboards non-technical stakeholders actually use. Strong foundation in financial modeling and KPI reporting, with a track record of communicating findings to executive audiences.

Lagos, Nigeria SQL & Python Power BI Financial Modeling
The best dashboard is the one nobody has to ask you to explain.
— How I approach every project

I'm a Data Analytics Expert at Infotact Solutions & Co., where I've owned three end-to-end analytics projects — marketing attribution, customer retention, and supply chain forecasting — from raw data through stakeholder-ready dashboards. Before that, I built financial and operational dashboards as a Data Analyst Intern at Bliss Analytics.

I hold a B.Eng. in Mechanical Engineering from Obafemi Awolowo University, and I build AI tools into my daily workflow to move faster on SQL, Python, and documentation — while always validating and correcting the output myself before it reaches final analysis.

Get In Touch

Have data that needs an answer?

Open to Data Analyst and Power BI Developer roles. If you've got a messy dataset and a real question behind it, I'd like to hear about it.