Open to Remote Opportunities

Daniel Peter
Akpan

// data-analyst · sql · python · power-bi · excel

2 years turning raw data into business decisions. Specialising in financial modelling, BI dashboards, and Python-driven analytics — based in Cape Town, open to US & UK remote roles.

2Years Experience
7Portfolio Projects
500K+Records Processed
5Certifications
Core Tech Stack
Python pandas NumPy Matplotlib Seaborn SQL Power BI DAX Excel VBA ETL Pipelines Tableau GitHub

Available immediately · GMT+2 · Remote-ready for US & UK

Skills & Tools

A full-stack data analytics toolkit built over 2 years of professional practice — from raw data to executive boardrooms.

🐍
Python
pandas, NumPy, Matplotlib, Seaborn — EDA, data cleaning, automation, statistical analysis, and pipeline scripting.
📊
Power BI
End-to-end dashboard development, custom DAX measures, star schema modelling, interactive KPI reporting.
🗄️
SQL
Complex queries, joins, CTEs, aggregations, data extraction and transformation across relational databases.
📗
Excel & Google Sheets
Advanced formulas, VBA macros, pivot tables, financial modelling, scenario analysis, report automation.
💹
Financial Modelling
Synergy models, M&A analysis, cost-benefit frameworks, scenario planning (conservative / base / aggressive).
🔄
ETL & Data Pipelines
Power Query, Python-based ingestion, multi-source data transformation, quality validation workflows.
👥
Stakeholder Communication
Executive reporting, data storytelling, C-suite presentations, cross-functional collaboration.
📈
Tableau
Interactive visualisations, calculated fields, story-driven dashboards for business insight delivery.

Professional Experience

2 years of real-world analytics experience — from property markets to global corporate simulations.

🏢
Data Analyst
Jan 2024 – Dec 2025
Jide Taiwo & Co · Lagos, Nigeria (Remote)
  • Collected, cleaned, and processed large volumes of real estate transaction data using Python (pandas) and SQL, improving data accuracy by 30% and enabling reliable market trend reporting.
  • Built and maintained interactive Power BI dashboards tracking occupancy rates, average listing prices, and regional demand — used weekly by senior management for strategic decisions.
  • Conducted exploratory data analysis (EDA) using Python (Matplotlib, Seaborn) to identify pricing anomalies, seasonal trends, and high-performing property segments across Lagos and Abuja markets.
  • Automated monthly and quarterly Excel reports using VBA macros, reducing manual reporting time by 40% and eliminating formula errors across 15+ report templates.
  • Developed Python scripts to pull, transform, and load data from multiple internal sources into a centralised database — supporting an ETL pipeline feeding the BI reporting environment.
  • Performed A/B analysis on property listing strategies; identified that listings with professional photography converted 22% faster — insight adopted company-wide.
  • Supported the finance team with scenario-based financial modelling in Excel, analysing revenue projections under conservative, base, and aggressive growth assumptions.
PythonSQLPower BI Excel VBAETLEDA Financial Modelling
💼
Deals Advisory Analyst Simulation
2026
PwC · Forage Virtual Experience
  • Built a dynamic scenario-based Excel model for an aviation M&A deal, quantifying $13–22M in synergy potential across conservative, base, and aggressive scenarios.
  • Analysed the Cisco × Splunk $28B acquisition, identifying four key synergy drivers across security, AI, revenue expansion, and business model transformation.
  • Developed a client-facing presentation deck and drafted executive email summaries with actionable findings.
M&A AnalysisFinancial Modelling ExcelExecutive Reporting
📊
Data Visualisation Analyst Simulation
2026
Tata Group · Forage Virtual Experience
  • Conducted deep-dive analysis to identify key performance drivers and built high-impact visuals for executive decision-making at Tata Consultancy Services.
  • Developed strategic reporting frameworks and C-suite question structures focused on effective data storytelling.
Data VisualisationStorytellingC-suite Reporting
🛒
Data Analytics Simulation
2026
Online Retail · Forage Virtual Experience
  • Orchestrated an end-to-end Power BI data cleaning pipeline for 500,000+ records, ensuring 100% financial reporting accuracy.
  • Built custom DAX measures for Total Revenue and YoY growth; designed interactive dashboards isolating international performance to identify high-growth regions.
  • Used Python (pandas) to validate dashboard outputs against raw data exports.
Power BIDAXPythonData Cleaning

Featured Projects

7 real-world analytics projects delivering measurable business impact across HR, property, finance, retail, and enterprise intelligence.

👥
⭐ Featured
HR Analytics & Workforce Engagement Dashboard
People Analytics Project

Built an end-to-end HR analytics dashboard modelling workforce engagement, attrition risk, and headcount trends. Transformed raw HR and survey data into interactive Power BI visuals for strategic people decisions.

↓35%Attrition Risk
KPIEngagement Score
BIPower BI
Power BIHR Analytics DAXSurvey Data Workforce Modelling
🏘️
Business Intelligence
Real Estate Market Analytics Dashboard
Jide Taiwo & Co

Comprehensive Power BI dashboard tracking occupancy rates, listing prices, and regional demand trends across Lagos and Abuja property markets — used weekly by senior leadership for strategic decisions.

30%Data Accuracy ↑
22%Conversion ↑
15+Reports Auto
Power BIPython SQLDAXETL
🔬
Finance
Cisco × Splunk $28B Acquisition Analysis
PwC · Forage

Deep-dive analysis of the Cisco × Splunk $28B acquisition, identifying four key synergy drivers across security, AI integration, revenue expansion, and business model transformation. Delivered as a client-facing executive report.

$28BDeal Size
4Synergy Drivers
M&A AnalysisExcel Financial ModellingExecutive Reporting
✈️
Finance
Aviation M&A Synergy Model
PwC · Forage

Scenario-based Excel financial model quantifying $13–22M in synergy potential for an aviation M&A deal. Built across conservative, base, and aggressive scenarios — presented as a client-facing deliverable.

$13–22MSynergies
3Scenarios
ExcelScenario Analysis Financial ModellingM&A
🛒
Business Intelligence
Retail Revenue & International Growth Dashboard
Online Retail · Forage

End-to-end Power BI pipeline processing 500,000+ records. Built custom DAX measures for Total Revenue and YoY growth with interactive dashboards isolating international performance to identify high-growth regions.

500K+Records
100%Accuracy
Power BIDAX PythonData Cleaning
🔁
Automation
Excel Report Automation System
Jide Taiwo & Co

Designed a VBA macro suite automating 15+ monthly and quarterly report templates, eliminating manual errors and saving 40% of reporting time for finance and operations teams.

40%Time Saved
15+Templates
ExcelVBA AutomationFinance
🐍
Python · EDA
Property Market EDA & A/B Analysis
Jide Taiwo & Co

Used Python (pandas, Matplotlib, Seaborn) to conduct exploratory data analysis on Lagos and Abuja property listing data. A/B tested photography strategies — discovering professional imagery drove 22% faster conversions, an insight adopted company-wide.

22%Conversion ↑
EDAPython
Pythonpandas SeabornMatplotlib A/B Testing
📊
⭐ Featured Business Intelligence
Sales Performance Dashboard
Multi-Region Retail · Power BI

A 5-page interactive executive dashboard built with SQL, Excel, and Power BI — tracking $2.3M in total sales, $286K profit, and 5,009 orders across regions, categories, and customer segments. Covers revenue trends, subcategory profit analysis, customer insights, product performance, and delivery KPIs including 3,993 late orders flagged.

$2.3MTotal Sales
12%Profit Margin
5Dashboard Pages
Power BISQLExcelDAXRevenue AnalysisDelivery KPIs
🔄
Business Intelligence
Customer Churn Analysis Dashboard
Retention Analytics · Power BI

A dynamic Power BI dashboard analysing customer churn patterns and key retention drivers. Built using SQL for data extraction and transformation, with interactive visuals designed to help business leaders identify at-risk segments and make data-driven decisions to reduce churn and improve customer lifetime value.

SQLData Layer
Power BIDashboard
KPIChurn Rate
Power BISQLChurn AnalysisDAXRetention Strategy

Certifications

Formal credentials completed in 2026 to validate skills built and applied across 2 years of professional data analytics practice.

Note: These certifications were completed to formally validate the technical skills I developed and applied throughout my professional experience at Jide Taiwo & Co from 2024–2025.
ALX Africa
Professional Certificate in Data Analytics
2026 · Remote
PwC · Forage
Deals Advisory Virtual Experience Programme
2026
Tata Group · Forage
Data Visualisation: Empowering Business with Effective Insights
2026
Forage
Online Retail Data Analytics Simulation
2026
Education
HND — Business Administration & Management Studies
2022 · Yaba College of Technology, Lagos

Get In Touch

Open to remote opportunities in the US & UK

I'm actively looking for data analyst roles where I can bring Python-driven analysis, BI dashboards, and financial modelling to a team. Available immediately. GMT+2 timezone — great overlap with UK hours.