Samuel Ayomide Makanjuola

I am Data Analyst, an Analytics Engineer and BI Analyst who builds end-to-end data solutions from raw transactional data to executive dashboards that drive real decisions.

I combine dimensional modeling, KPI design and automated reporting workflows to give business teams a single, reliable view of performance. Currently consulting on investor decks and executive strategy presentations for client engagements.

View Projects LinkedIn GitHub

Projects

End-to-end analytics and BI projects from data modeling and SQL pipelines to interactive dashboards and automated workflows. Full details available on GitHub.

End-to-End Sales Data Warehouse & BI System

SQL Server | Power BI | DAX | Git | Draw.io | Notion

Full Bronze-Silver-Gold analytics pipeline with star-schema dimensional modeling. Consolidated sales, profitability, retention and customer KPIs into a single executive dashboard, replacing multiple manual reports with one reliable, structured data warehouse.

Open PDF View on GitHub →

Business Intelligence Dashboard

SQL Server | Power BI | DAX | Power Query

Executive BI dashboard built on a Gold-layer data model supporting decision-making across sales performance, profitability risk and customer behavior. Features time-intelligence measures, conditional formatting and drilldown analysis across multiple business dimensions.

Open PDF View on GitHub →

Marketing Campaign Performance Dashboard

Power BI | Power Query | DAX

Interactive dashboard tracking 8 core campaign KPIs including Ad Spend, ROI, CTR, Conversion Rate and Revenue. MoM time-intelligence measures surface underperforming segments automatically, reducing the time needed to identify issues from manual review to instant visual identification.

Open PDF View on GitHub →

Call Center Performance Dashboard (Excel)

Microsoft Excel | Pivot Tables | Pivot Charts | Slicers

Three-part Excel analytics project covering 1,000 call records, functions, pivot tables and a fully interactive dashboard. KPI cards, monthly trend analysis, rep performance comparison and gender breakdown all filterable by representative using slicers. Includes 10 advanced HR business questions answered using XLOOKUP, FILTER, SUMIFS and nested formulas.

Open PDF View on GitHub →

Customer Purchase Behavior Analysis

MySQL | SQL

Analyzed 2,000+ retail transactions to surface repeat purchase patterns, churn signals and seasonal revenue trends. Built using CTEs and window functions, producing prioritized recommendations for resource allocation and revenue growth.

Open PDF View on GitHub →

Sales Data Cleaning & Trend Analysis

Python | pandas | matplotlib

Python data preparation workflow that cleaned and structured multi-source raw sales data, then analyzed monthly revenue growth, product performance and regional trends across multiple dimensions. Visual summaries produced for inventory and planning decisions.

Open PDF View on GitHub →

Automated Weekly Business Report Pipeline

n8n | Google Sheets | JavaScript | Gmail

Fully automated reporting pipeline that pulls 80 sales records from Google Sheets every Monday, calculates 10 business KPIs in a JavaScript code node and delivers a formatted HTML report to stakeholders automatically with zero manual intervention.

Open PDF View on GitHub →

Investor Deck — ElRoi Dynasty AfricaSuit (Strategy Consulting)

PowerPoint | Business Strategy | Market Sizing | Financial Modeling

Designed and delivered a 10-slide investor deck for a premium African formalwear brand. Covered market opportunity analysis (N27B TAM, 246,000+ annual suit purchases), competitive positioning, three-tier product strategy, five-year financial projections (N330M Year 5 revenue) and a N20M seed investment ask with 4.8x projected return. Engaged as Strategy Presentation Consultant via SWOT Builds.

Open PDF

Skills

Analytics Engineering

Dimensional Modeling Star Schema Bronze/Silver/Gold Architecture Data Quality Checks KPI Definition Metric Validation

Business Intelligence

Power BI DAX Power Query Executive Dashboards Time Intelligence Insight Storytelling

SQL & Data

SQL Server MySQL CTEs Window Functions Data Transformation Reconciliation Logic

Automation & Workflow

n8n Workflow Automation Scheduled Pipelines Google Sheets Integration Email Reporting Automation

Strategy & Presentation

Investor Deck Design Executive Narrative Structuring Market Sizing Financial Modeling PowerPoint Business Strategy Communication

Tools

Excel (Advanced) Python (pandas, matplotlib) Git/GitHub Notion Airtable Draw.io Azure Fundamentals

Soft Skills

Communication Problem Solving Stakeholder Management Attention to Detail Critical Thinking Resilience

Experience

Business Analyst — SWOT Builds (Contract)

Remote, Nigeria • Mar 2026 — Present

  • Engaged on a project-by-project consulting basis to transform complex business strategies into executive-ready PowerPoint presentations for investor and stakeholder audiences.
  • Designed and delivered a 10-slide investor deck for ElRoi Dynasty's AfricaSuit brand covering market opportunity analysis (N27B TAM), competitive positioning, three-tier product strategy, five-year financial projections (N330M Year 5 revenue, 25% net margin) and a N20M seed investment ask with 4.8x projected return.
  • Structured the full investor narrative from market sizing through unit economics and exit strategy, ensuring every slide served a specific persuasion purpose for an executive audience.
  • Handled end-to-end client communication and iterated across multiple deck versions based on structured feedback, delivering polished brand-consistent outputs within a one-week project timeline.

Financial Secretary (Volunteer) — NYSC CDS – Breast Without Cancer (BWS CDS)

Nigeria • Jun 2025 — Dec 2025

  • Maintained structured financial records and tracked weekly contributions for ~300 members, building a reliable data system that supported budgeting and accountability.
  • Identified and followed up on outstanding balances using structured tracking, improving payment compliance and ensuring funds were available for planned activities.
  • Prepared periodic financial summaries for leadership review, translating raw contribution data into clear reports that informed budgeting decisions.

Affiliate Marketer — Expertnaire (Contract)

2021 — 2022

  • Analyzed lead conversion patterns across WhatsApp, Facebook and Twitter to identify which channels and messaging approaches drove the highest quality prospects.
  • Built a structured sales funnel and wrote conversion-focused copy that improved follow-up consistency and overall conversion rate.

Data Entry Specialist — Airmax Computer Institute of Technology

Madalla, Suleja, Niger State • May 2019 — Sep 2020

  • Registered ~500 student records on the JAMB examination database with high accuracy, maintaining data integrity under time-sensitive conditions.
  • Supported daily operations and customer-facing service delivery, ensuring smooth workflows and minimal disruption.

Computer Operations Manager — God'swill Computer Institute

Mar 2018 — Apr 2019

  • Managed daily operations across ~15 workstations, ensuring system reliability and consistent service delivery for students and customers.
  • Trained and mentored ~20 students in practical computer skills, improving digital literacy and operational confidence across the institute.

Certifications

Data Analysis Program — Axia Africa

American Council of Training and Development (ACTD) • Excel, SQL, Power BI, Python • 90% Overall Score • 2025

View Certificate

National Youth Service Corps (NYSC)

2025

Contact

Feel free to reach out for collaborations or opportunities.

+234 903 625 9471 Email Me LinkedIn GitHub