Selected work across brand and graphic design, digital communications and marketing analytics
Grouped by type: brand identity, marketing analytics, publications, websites, video and writing.
Brand design projects
Marketing analytics projects
What the work did, with the numbers to show it.
App-market insights dashboard
HNG Tech · 2025Led 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.
SQL-based marketing campaign analysis
HNG Tech · 2025Cleaned 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 to 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 BIAn 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 BIA 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 to 2025Built and ran the First Icon social-media metrics tracker, covering 23 staff across five platforms with 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 ↗Publications, newsletters and pitch decks
Recurring newsletters, corporate documents and decks, designed, laid out and shipped.
Weekly market review
Recurring publicationA weekly market-review publication covering the global economy (US, Asia, Europe, Africa) and the local market, in a scannable editorial layout with data call-outs, section dividers and a consistent masthead.
View project ↗Corporate profile
Company profileA 24-page corporate profile for a financial-services group: business overview, products, approach and methodology, board and contacts, with a cover, contents, section openers and a consistent grid, laid out end to end.
View project ↗Staff newsletter, February edition
Internal newsletterAn 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 newsletterThe 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 newsletterAn edition of a recurring customer newsletter: product notes, market updates and service information for a large contributor base.
View project ↗SolarGuys pitch deck
Pitch deckA 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 ↗WordPress websites
Live WordPress sites I build and maintain: the role I hold and the skills applied on each.
WordPress administration, section builds and ongoing content for the Blog, Events and Lifestyle areas, publishing workflow, on-site SEO and performance reporting to management.
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.
Company website for Virgin-landmarts Limited, covering real estate, construction, facility management and interior design.
Reels and videos
Short-form video for social: concept, script, edit and motion graphics.
Pension communications reels
Short-form videoA set of social reels explaining pensions to a general audience, including 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 ↗Writing and blog articles
Longer pieces on brand, communications and reading the numbers.