Work

Selected work across brand design, communications and marketing analytics

Grouped by type — brand identity, marketing analytics, campaign and print design, publications, websites, video and writing.



02

Marketing Analytics Projects

What the work actually did — tracked, analysed and reported, not assumed.

App-market insights dashboard

HNG Tech · 2025

Led a team building a Google Play Store business-insights dashboard, integrating predictive analytics and Apple App Store competitor data. Finished the internship ranked top 432 of 11,285. Python · SQL · Excel.

View project ↗

SQL-based marketing campaign analysis

HNG Tech · 2025

Cleaned and modelled a 200,000-row marketing-campaign dataset in PostgreSQL, then ran eight analytical queries on ROI, click-through rate, cost per conversion and channel performance. Found an overall CTR of 9.98% against a 1–5% benchmark, identified the top-ROI campaign and the three highest-impression cities, and ranked Google Ads and Email the strongest conversion channels — delivered as a structured SQL report with reproducible scripts. PostgreSQL · SQL · Python · Excel.

View project ↗

Retail sales performance dashboard

Power BI

An interactive Power BI dashboard analysing $1.2M of retail sales across 8,500+ items and four outlet types — sales broken down by item category, fat content, outlet size and location tier, with slicers for drill-down and a KPI header for total and average sales, item count and rating. Power BI · DAX · data modelling.

View project ↗

Year-on-year sales dashboard

Power BI

A Power BI sales dashboard tracking year-to-date against prior-year-to-date — a KPI header (sales, gross profit, GP%), monthly YTD/PYTD trends by product line, a country-level bottom-10 view, a month-by-month waterfall, and a GP%-versus-sales profitability scatter. Built on DAX time-intelligence measures.

View project ↗

Campaign & channel performance tracking

First Icon Group · 2024–25

Built and ran the First Icon social-media metrics tracker — 23 staff across five platforms, weekly snapshots, growth-over-time and a posts log — which cut stakeholder reporting time by 30%. Paired with content frameworks that lifted cross-platform engagement 26% and LinkedIn engagement 20%. GA4 · Google Sheets.

View project ↗



05

Publications, Newsletters, PitchDecks

Recurring newsletters, corporate documents and decks — designed, laid out and shipped.

Weekly Market Review

Recurring publication

A weekly market-review publication covering the global economy (US, Asia, Europe, Africa) and the local market — a scannable editorial layout with data call-outs, section dividers and a consistent masthead.

View project ↗

Corporate Profile

Company profile

A 24-page corporate profile for a financial-services group: business overview, products, approach and methodology, board and contacts — cover, contents, section openers and a consistent grid, laid out end to end.

View project ↗

Staff newsletter — February edition

Internal newsletter

An edition of a recurring internal staff newsletter — company news, features and updates, art-directed and laid out for a 1,000+ employee readership.

View project ↗

Staff newsletter — 2026, issue 001

Internal newsletter

The first internal newsletter of the year, with a refreshed cover and section system carried across the rest of the run.

View project ↗

Customer newsletter — June edition

Customer newsletter

An edition of a recurring customer newsletter — product notes, market updates and service information for a large contributor base.

View project ↗

SolarGuys pitch deck

Pitch deck

A 12-slide investor pitch deck for a solar-energy company — market opportunity, product, model and ask — with a bold colour system, iconography and full-bleed imagery.

View project ↗

06

WordPress Websites

Live WordPress sites I build and maintain — the role I hold and the skills applied on each.

www.trustfundpensions.com ↗ Manage & maintain

WordPress administration, section builds and ongoing content for the Blog, Events and Lifestyle areas, publishing workflow, on-site SEO and performance reporting to management.

www.sundayoladokun.com ↗ Design & build

WordPress and Elementor, a custom design system with global styles and variables, responsive layouts, a light/dark theme, SEO and structured data, and performance optimisation.


07

Reels and Videos

Short-form video for social — concept, script, edit and motion graphics.

Pension communications reels

Short-form video

A set of social reels explaining pensions to a general audience — a Contributory Pension Scheme myths-vs-facts explainer, a mobile-app download promo, a relatable 'PFA excuses' piece and a campaign video. Concept, scripting, editing and motion graphics.

View project ↗

08

Writings and Blog Articles

Longer pieces on brand, communications and reading the numbers.


Looking for this kind of thinking on your team?

Contact me ↗