Lab Operations Performance Dashboard
Designed an Excel dashboard tracking 1,470 lab samples with automated KPI reporting — completion rates, failure rates, and processing time. Mirrors real-world laboratory performance monitoring.
1,470 samples84% completion100% approval
ExcelDashboardLab KPIs
view project
Sales Performance Executive Dashboard
Analysed $2.3M revenue and $286.4K profit across multiple regions. Identified 46.9% YoY sales growth and 12.5% profit margin for C-suite decision making.
$2.3M revenue46.9% YoY growth
Power BIExecutive BISales Analytics
view project
CRM Sales Performance Dashboard
Built a CRM dashboard analysing 8,800 opportunities across a $10M revenue pipeline. Tracked win rates, client activity, and sector performance with fully automated reporting.
8,800 opportunities$10M pipeline
ExcelCRMPipeline Analytics
view project
Full Business ERP System in Python
Developed a complete Python ERP system — procurement, inventory, HR/payroll, financial reporting, and sales automation. Built end-to-end to digitise operations for businesses moving from manual processes.
procurementinventoryHR & payrollfinance
PythonERPAutomation
view on github
COVID-19 Global Data Exploration
Explored global COVID-19 data using JOINs, CTEs, Temp Tables, Window Functions, and Aggregates. Found 90% of case severity concentrated in major nations vs minimal impact in smaller countries.
SQL ServerCTEsWindow Functions
view project
Movie Revenue Correlation Analysis
Investigated gross revenue drivers using Pandas for wrangling, NumPy for stats, and Matplotlib for visualisation. Identified budget and production company as the strongest revenue predictors.
PythonPandasMatplotlibCorrelation
view notebook
Nashville Housing Data Cleaning
Transformed raw housing data into analysis-ready format — standardised dates, resolved nulls, split concatenated addresses, removed duplicates. Enterprise-grade data quality demonstration.
SQL ServerData CleaningETL
view project
Jumia E-Commerce Web Scraper
Built a Python scraper using BeautifulSoup and Requests to extract live product pricing from Jumia — replacing hours of manual price research with a single automated script run.
PythonBeautifulSoupWeb Scraping
view on github
Data Professional Survey Visualisation
Interactive Power BI report comparing salaries, satisfaction, and career paths across data roles. Used Power Query for ETL and built dynamic comparative multi-dimensional charts.
Power BIPower QuerySurvey Analysis
view report
Bike Sales Visualisation Dashboard
End-to-end Excel project: cleaned raw data, applied Pivot Tables for aggregation, built an interactive dashboard showing buyer demographics and regional sales breakdown.
ExcelPivot TablesDashboard
view dashboard
AirBnB Seattle Housing Analysis
Cleaned Seattle AirBnB data in Excel, then built Tableau visualisations showing pricing by neighbourhood, occupancy trends, and seasonal variation patterns across the city.
TableauGeo AnalysisHousing Data
view on tableau
AI-Driven Business Process Automation
Python automation workflows replacing repetitive business tasks — auto-generating reports, routing data between systems, triggering smart notifications, and eliminating manual data collection.
PythonAI PipelinesAutomation
view on github
