About Me

I'm a Network Systems graduate who has transitioned into the world of Data Analytics, and my path so far has been fueled by curiosity, a passion for problem-solving, and a drive for transforming raw data into valuable insights. I'm constantly excited to explore what lies ahead in this rapidly growing field. My expertise spans data analysis, data visualization, and an advancing proficiency in tools like Python, Excel, SQL, and Power BI all directed toward enabling data-driven decisions and tackling real-world business challenges. Beyond my technical background, I bring an enthusiastic mindset and a genuine dedication to everything I pursue. I flourish in team environments where communication and collaboration spark great results.

Skills

Experience

Education

Technical Skills

  • Programming & Analysis: Python, R
  • Data Manipulation & Cleaning: pandas, NumPy
  • Data Visualization: Matplotlib, Seaborn, Excel charts, Pivot Tables
  • Tools & Environments: RStudio, Jupyter Notebook, Excel

Soft Skills

  • Analytical thinking
  • Problem-solving
  • Communication skills
  • Attention to detail
  • Team collaboration
  • Time Management
  • Jul 2025 - Current
    Data Analyst intern at Cmmg
  • Dec 2024 - Feb 2026
    Data Analyst intern at Capciti
  • Jul 2024 - Oct 2024
    Cybersecurity Learnership at Go Fourth Learning
  • Mar 2021 - Dec 2023
    Diploma In Networks Systems at Boston City Campus
  • Jan 2015 - Dec 2020
    Matric at The Glen High School

My Services

Data Analyst

Passionate about turning complex datasets into clear, compelling stories. Leveraging tools like Python, Excel, SQL, and Power BI to analyze, visualize, and communicate data-driven insights that support strategic business decisions and solve real-world challenges. I bring curiosity and analytical thinking to every dataset, always asking the right questions to uncover the insights that truly matter to a business.

My Work

Sales Analysis Project

Sales Performance Analysis Project

A dual-version analysis project using both Excel and Python to extract actionable business insights from a company sales dataset. Applied EDA techniques, pivot tables, and visualizations to uncover regional trends, salesperson performance, and product-level patterns — with strategic bonus recommendations for top performers.

KEY QUESTIONS ANSWERED

  • Which region generated the highest total sales?
  • Top 3 salespersons by total revenue
  • Monthly trends per product category
  • Regional differences in units sold vs. revenue
  • Peak month, dominant product and region
  • Bonus recommendations for top performers
Python Excel pandas Matplotlib Seaborn EDA
View on GitHub
Healthcare Analytics

HealthTech Analytics Project

A case study simulating a data analyst role at a healthcare startup. Used SQL within Python to query a relational database of patients, visits, doctors, treatments, and diagnoses — uncovering demographic patterns, departmental diagnosis trends, treatment costs, and visit frequency insights to support data-driven hospital decisions.

    KEY OBJECTIVES

    • Patient distribution by city — bar chart
    • Diagnosis trends per department via joins
    • Top 5 patients by total treatment cost
    • Frequent patients (5+ visits) — monthly trend line
Python SQL SQLite pandas Seaborn Matplotlib NumPy
View on GitHub
Revenue Insights

NYC Flights Delay Analysis (SQL in R)

An advanced data science project integrating SQL queries within the R environment to analyze over 300,000 flight records from the 2013 NYC flights dataset. Focused on improving airline operations by extracting insights on departure delays, carrier performance, destination trends, and on-time rates — all via SQL executed inside R using sqldf.

DATASET

nycflights13::flights 300,000+ records NYC departures 2013

KEY QUERIES ANSWERED

  • Top 5 flights with the longest departure delays
  • Average arrival delay per airline — worst performers ranked
  • Top 3 destinations by highest average arrival delay
  • Average flight distance per origin airport
  • Daily flight count and average delay throughout January
  • On-time performance % per airline (arrival delay ≤ 0)
  • Flights delayed 60+ mins traveling over 1,000 miles
R SQL SQLite sqldf nycflights13 RStudio
View on GitHub

My Certifications

Documented achievements showcasing my continuous learning journey in data analysis and professional development.

Excel Certificate

Microsoft Azure Data Fundamentals (DP-900)

Built a solid understanding of fundamental data concepts and cloud-based data solutions within Microsoft Azure. Gained knowledge of relational and non-relational data, data workloads, and analytics processes.

Issued: 26 March 2026
Azure Fundamentals Certificate

Microsoft Azure Fundamentals (AZ-900)

Demonstrated foundational knowledge of cloud services and how those services are provided with Microsoft Azure, including cloud concepts, core Azure services, security, privacy, compliance, and pricing.

Issued: 30 September 2024

Contact Me

I am actively seeking opportunities where I can contribute my skills, learn from experienced professionals, and grow in my career. Please feel free to reach out.

Email

magwaxazaomphile@gmail.com

Phone

0695787850

Location

Pretoria, South Africa

LinkedIn

Omphile Magwaxaza

GitHub

Omphile Magwaxaza

copyright @Omphile Mogomotsi Wandile Magwaxaza