Matshidiso Hlalele
Data Analyst | Scientific Researcher
Data Analyst Portfolio
I began my career as a scientific researcher in academia, agriculture, and environmental fields, where I learned how to design experiments, collect data and work with complex datasets to uncover meaningful patterns. I am currently transitioning into a data analyst role and specialize in transforming raw data into clear insights that drive data decision-making.
This portfolio contains a curated selection of projects that demonstrate end-to-end analytical skills: data extraction, cleaning/ETL, exploratory analysis, visualization, and communicating results for stakeholders.
Skills & Technologies
- Data Manipulation & Analysis: SQL, ETL, Excel
- Visualization & BI Tools: Tableau, Power BI
- Databases: MySQL, PostgreSQL, Microsoft SQL Server
- Development & Workflow Tools: Docker, Git
Education
- Bachelor of Science, Honores - University of the Free State
- Bachelor of Science in Entomology - University of the Free State
- Core data analysis skills from BSc Entomology include Statistical analysis (ANOVA, regression), data collection and management, data visualization, Excel/R, research reporting, ecological and agricultural data interpretation.
Featured Projects
1. SQL Data Warehouse Project
Goal: Building a modern data warehouse with SQL Server, including ETL processes, data modeling and analytics Data Analyst Job Market 2023 Tech Stack: SQL
- Analysing the most in-demand skills for data analysts, and the market value of both essential and niche technical expertise. 🔗 View Project on GitHub
2. 📊 Customer Churn Prediction
Goal: Identify customers likely to churn for a telecom company.
Tech Stack: Python, Scikit-learn, Logistic Regression, Random Forest
- Cleaned and explored 6K+ customer records
- Trained multiple ML models with GridSearchCV 🔗 View Project on GitHub
Professional Experience
Biodiversity Officer | Department of Forestry, Fisheries and the Environment (Mar 2018 - Sept 2021)
- Supported biodiversity conservation efforts by transforming complex datasets into actionable insights for policy and program development.
- Routinely updated and managed databases to ensure timely access to data, reducing reporting errors and streamlining analysis.
- Conducted data cleaning, transformation, and validation to ensure accuracy in datasets.
- Collected and visualized environmental data, revealing key trends that informed policy decisions.
Laboratory Technician | University of Pretoria (Apr 2014 - Mar 2015)
- I effectively contributed to entomological research by conducting data collection and analysis, leading to impactful findings.
- Conducted statistical analyses that identified trends, aiding in research publications and academic reports.
- Maintained organized records of experiments, ensuring data accessibility for future research initiatives.
Blogs
SQL Joins Explained with Simple Examples —
📬 Let’s Connect!
Thanks for stopping by! Feel free to explore my repositories and reach out if you’d like to collaborate or connect.