Skip to content
View Phemelocodemode's full-sized avatar
🎯
Focusing
🎯
Focusing

Block or report Phemelocodemode

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Phemelocodemode/README.md

I turn messy datasets into decisions that matter.

Currently working as a Data Analyst in financial services, building reports, dashboards and pipelines that drive real business decisions. My background is in fintech data β€” remittances, payments, customer behaviour β€” and I'm pushing further into data engineering with Microsoft Fabric and Spark SQL.


πŸ”₯ What I'm Working On

  • Day job: Data Analyst Intern at a financial services company in Cape Town β€” building silver layer staging in Microsoft Fabric, writing Spark SQL, and producing reporting solutions
  • Certs: PL-300 Power BI Data Analyst Associate in progress
  • Portfolio: Documenting real analysis projects on GitHub so the work doesn't go to waste

πŸ“ Projects

🏦 Mukuru Remittance Analysis

SQL β€’ Python β€’ Excel β€’ Power BI

End-to-end analysis of 568,000+ remittance transactions for a leading African fintech company. Built paid order volume trends (MoM and YoY), customer retention metrics and a data quality validation framework across Mukuru's Southern African corridors.

  • 330,064 paid orders analysed across 13 months (Apr 2012 to Apr 2013)
  • Active customer base grew 53% over 11 consecutive months
  • Average Repeat Sender Rate of 62.7% β€” strong habitual usage signal
  • Zimbabwe corridor identified as 72% of payout volume β€” concentration risk flagged

View Repository β†’


πŸ›’ Retail Sales Analysis

SQL β€’ Python β€’ Power BI

Analysed 8,000+ retail transaction records to identify revenue trends, outlet performance and KPI drivers. Built a Power BI dashboard tracking $997K in sales with drill-down capability by region and product category.

View Repository β†’


πŸš— Ride-Hailing Business Analysis

SQL β€’ PostgreSQL

Queried multi-table ride-hailing datasets across 7,000+ records to extract driver performance metrics, revenue trends and user behaviour patterns using joins, window functions and aggregations.

View Repository β†’


πŸ₯ VitaCare Telemedicine System

Python β€’ Data Analysis

Contributed to data processing and reporting components for a telemedicine platform. Focused on backend data flow and system documentation.

View Repository β†’


πŸ›  Tech Stack

Core Tools

SQL Python Power BI Tableau Excel

Data & Engineering

PostgreSQL Pandas Microsoft Fabric Azure Git


πŸ“œ Certifications

  • βœ… Google Data Analytics Professional Certificate
  • βœ… Google Business Intelligence Certificate
  • βœ… Microsoft Azure Data Fundamentals (DP-900)
  • πŸ”„ Microsoft Power BI Data Analyst Associate (PL-300) β€” In Progress

πŸ“Š GitHub Stats


🐍 Contribution Snake

contribution snake

🀝 Let's Connect

LinkedIn Email GitHub


Pinned Loading

  1. health-insurance-premiums-dashboard health-insurance-premiums-dashboard Public

    Tableau dashboard exploring NY health-insurance premiums. Includes KPIs, trends, and insurer comparisons. Highlights core data cleaning and visualization skills.

  2. HNG-Ride-SQL-Analysis HNG-Ride-SQL-Analysis Public

    SQL-based business analysis of a simulated ride-hailing platform using PostgreSQL. The project analyzes revenue trends, driver performance, rider behavior, and operational efficiency through data c…

  3. Phemelo-portfolio Phemelo-portfolio Public

    A clean, responsive personal portfolio built with HTML, CSS, and modern UI design principles. Showcases data analytics projects, dashboards, education, technical skills, and contact links. Designed…

    HTML

  4. retail-sales-analysis retail-sales-analysis Public

    SQL, Excel, and Power BI–based analysis of retail sales data for a fictional company (VistaCart), focusing on sales performance, outlet analysis, product categories, and operational insights. The p…

    TSQL

  5. Vitacare-TeleMedicine Vitacare-TeleMedicine Public

    Vitacare β€” A Kivy-based mobile application designed to help users manage their health and wellness. The app provides easy access to medical information, reminders, and essential health tools throug…

    Python

  6. Mukuru-Case-Study Mukuru-Case-Study Public

    End-to-end remittance data analysis for a leading African fintech β€” SQL, Python, Excel and Power BI across 568K+ transactions covering paid order trends, customer retention and data quality validat…