Pretoria, South Africa · Available for work

Ndivhuwo
Netshiendeulu

Data Analyst

Data Scientist with a scientific and environmental analytics background, gained from 13+ years as a Hydrogeologist in water resource management. I translate complex datasets into clear, actionable insights — skilled in SQL, Python, Power BI, Tableau, and Excel, with hands-on experience in dashboards, ETL, feature engineering, and predictive machine learning.

500K+ records analyzed
9 end-to-end projects
SQL · Python · Power BI · Tableau
About

Rigor from science. Fluency in data.

I'm a Data Analyst / Data Scientist with a unique foundation: over 13 years as a Hydrogeologist at South Africa's Department of Water and Sanitation, where I worked with large environmental datasets, statistical analysis, GIS mapping, and stakeholder-facing reporting. I've since transitioned that analytical rigor into the world of data analytics and data science — building predictive machine learning models, designing dashboards, and turning messy real-world data into decisions that matter.

I'm skilled across the full analytics workflow: gathering and documenting business requirements, performing ETL and data cleaning, exploratory data analysis, feature engineering, predictive modelling, and building dashboards that communicate insight to both technical and non-technical audiences. I'm also fluent in leveraging AI tools — ChatGPT, Claude, Lovable, NotebookLM, and Canva — to accelerate analysis, prototyping, and presentation.

13+ Years
Scientific & environmental analytics experience
9 Projects
End-to-end data analytics & ML projects
500K+
Largest single dataset analyzed (Bright Motors)
7+ Tools
SQL, Python, Power BI, Tableau, Looker, Databricks, BigQuery
Toolkit

Skills & Tools

A stack built for the full analytics workflow — from raw ingest to executive-ready insight.

Languages

  • SQL
  • Python

BI & Visualization

  • Power BI
  • Tableau
  • Google Looker Studio
  • Excel (Pivot Tables, XLOOKUP, VLOOKUP)

Data Platforms

  • Jupyter Notebooks
  • Databricks
  • Google BigQuery
  • Google Colab

Analysis Methods

  • Exploratory Data Analysis (EDA)
  • Data Cleaning
  • Feature Engineering
  • Predictive ML Modelling
  • Statistical Analysis
  • ETL Processes
  • KPI Tracking

Other Tools

  • GitHub
  • ArcMap (GIS)
  • Microsoft PowerPoint
  • AI: ChatGPT, Claude, Lovable, NotebookLM, Canva
Case Studies

Featured Projects

End-to-end data analytics and machine learning projects — from raw data to business recommendations.

01

Patient Readmission Predictive Model

End-to-end binary classification model predicting 30-day patient hospital readmissions across 3,000 records.

PythonScikit-LearnPandasSeabornMatplotlib
  • Ran data ingestion, feature inspection, label encoding, and scaling to prep multi-variable health indicators (BP, blood sugar, prior admissions, stay duration).
  • Analyzed class imbalance (~29% readmission rate) and feature importance to identify primary drivers, supporting cost-saving clinical interventions.
02

Bright Motors Sales Analysis

Analyzed 558,811 vehicle sales records to improve future sales, optimize inventory, and guide marketing strategy.

SQLExcelLooker StudioDatabricksLovableClaudeChatGPT
  • Uncovered R7.61B revenue across 558,811 units (2012–2015); R7.0B in 2015 alone; Q1 drove 62% of revenue.
  • Identified Ford/F-150 as top make/model and FL, CA, PA, TX as top states — over R3.7B combined.
  • Flagged 83.5% of sales in a low-margin tier; delivered recommendations on expansion, seasonal promos, and dealership pricing strategy.
03

Bright TV Viewership Analytics

Viewership analytics on 4 months of transactional data across 21 channels and 9,993 viewers to grow the subscription base.

SQLExcelLooker StudioLovableCanva AI
  • Revealed audience skew (87% male, Youth 18–34 at 56%); Supersport Live Events top channel with 1,637 viewers.
  • Identified Afternoon as peak viewing (37.3%); proposed sport-focused promotions, content diversification, and loyalty programmes.
04

Bright Coffee Shop Sales Analysis

6-month diagnostic sales analysis of 149,116 transactions across 3 store locations for a new CEO.

SQLMicrosoft Excel
  • Revenue grew ~50% over 6 months (R2,300 → R6,400/month), driven by seasonal changes from May onward.
  • Hell's Kitchen was the top store; Coffee the top revenue product. Recommended loyalty programmes, weekend deals, and evening specials.
05

Prosper Loan Data Analysis

Analyzed 113,937 rows × 81 columns of borrower, credit, and loan data (2005–2015) to understand borrower risk and loan performance.

Python
  • Engineered new features (LoanRating, IncomeRangeClass); most borrowers in the 'Poor' income class with C/B credit ratings.
  • Smaller loans (< $25K) carried higher interest and higher delinquency — informing lending risk insights.
06

KMS Superstore Dashboard

Analyzed 8,400 sales records to identify profit drivers across regions and customer segments.

Power BI
  • Uncovered $25.13M in sales and $1.52M in profit (2009–2011); Yukon was the top-performing region.
  • Technology led product categories at $11.6M; Corporate customers drove 39.41% of profit.
07

Superstore Sales Dashboard

Analyzed 9,995 sales records (2014–2017) to surface geographic, product, and seasonal patterns.

Tableau
  • California led states with $457.7K; Phones and Chairs were top sub-categories.
  • Consistent year-end seasonality and a clear upward YoY sales trend through 2017.
08

Orders Sales Dashboard

Analyzed 8,904 multi-country orders (Nigeria & South Africa) across 3 outlet types and 13 producers.

Microsoft Excel
  • Convenience Stores led with 39.3% of sales; Nigeria drove 93% of total revenue, led by Field Sales.
  • Drinks had the highest average order quantity — informing category-level strategy.
09

Multi-Dataset Visualization Projects

Dashboards across three separate datasets (Retail Sales, Shopping Trends, Coffee Shop Sales) to extract insights and support decisions.

Looker StudioPower BI
Career

Experience

  1. Hydrogeologist (Scientist Production)

    September 2015 – Present
    Department of Water and Sanitation
    • Managed a multi-million-rand Intermediate Reserve project for the Upper Orange Catchment and presented results to stakeholders to support Water Use License Application (WULA) decisions.
    • Compiled groundwater Reserve determinations (Rapid and Desktop) and produced GIS (ArcMap) maps for quaternary catchments.
    • Analyzed groundwater quality and quantity data using statistical methods in Excel, calculating median values and setting 10% groundwater quality limits for domestic use.
    • Mentored a junior scientist on Reserve methodology, improving team capability and consistency.
  2. Candidate Scientist

    April 2012 – March 2015
    Department of Water and Sanitation
    • Compiled groundwater Reserve determinations and produced GIS (ArcMap) maps for quaternary catchments, supporting WULA decisions.
    • Analyzed groundwater quality/quantity data using statistical methods in Excel.
    • Provided technical input on other scientists' projects to improve report quality.
  3. Graduate Trainee

    April 2008 – March 2012
    Department of Water and Sanitation
    • Compiled desktop groundwater Reserve determinations and GIS maps for multiple catchments.
    • Updated the groundwater Reserve tracking system for accurate, consistent documentation.
    • Assisted senior scientists with technical inputs to improve report quality.
Academic

Education

2012

Master of Science (M.S.), Geohydrology

University of the Free State

2009

B.Sc. Honours, Geohydrology

University of the Free State

2007

Bachelor of Science (B.S.), Geology

University of the Witwatersrand

Credentials

Certifications & Achievements

Feb 2026 – Present

Data Science Certificate — BrightLearn

Hands-on training in Python, Machine Learning, SQL, Excel, Power BI, Google Looker Studio, AI tools (ChatGPT, Claude, Lovable, NotebookLM, Canva), and data cleaning for analytics and dashboard creation.

2023

Data Analytics Certificate — Lighthall

Hands-on training in SQL, Python, Excel, Power BI, Tableau, and data cleaning for analytics and dashboard creation.

558,000+
Records analyzed (Bright Motors)
R7.61B
Revenue insights uncovered in a single project
13+ Years
Stakeholder-facing scientific analysis
Get in touch

Let's Connect

Open to Data Analyst / Data Scientist opportunities and collaborations — feel free to reach out.