John Mwendwa

Collaborated on data projects, contributing to data cleaning, analysis, and visualization. Developed dashboards and reports for stakeholders, enabling data-driven decision-making. Solved complex data challenges and presented results to improve project outcomes.

Utilized Excel to extract and organize data on bike purchases from customer databases. Transformed data by categorizing age groups and analyzing factors such as income, marital status, and occupation to improve reporting processes. Visualized data with pivot tables and charts to identify key insights for enhancing sales performance.

Used SQL scripts to clean, stage, and analyze layoff datasets, identifying trends and key insights. Applied advanced SQL queries to analyze layoff patterns across industries. Visualized rolling totals of layoffs to show progression across sectors.

Retrieved data from Kaggle and performed exploratory data analysis using Python to uncover patterns and trends in a movie dataset. Cleaned data, handled missing values, and ensured data consistency. Used Power BI to create visual reports highlighting the trends.

Performed exploratory data analysis using Python to uncover patterns and trends in weather data. Cleaned data, handled missing values, and ensured data consistency. Used Matplotlib and Seaborn to create visual reports highlighting weather trends.

Provided technical support for IT systems, maintaining server, network, and database performance. Ensured data security by implementing backups and adhering to security protocols. Conducted staff training on IT best practices to improve technological efficiency.

Completed a Bachelor of Business Information Technology with a focus on Business Analytics and Data Analytics. Gained skills in data cleaning, exploratory analysis, and visualization, preparing for a career as a data analyst.