Dataproject (List)

Data Projects

I have a strong passion for data analytics and visualization, and have therefore dedicated myself to applying these skills to real-world business challenges. Along the way, I’ve completed several projects that showcase my ability to transform data into actionable insights and impactful solutions. Take a look at my portfolio below.

Image of a female call centre agent wearing headphones and smiling.

Call Centre Data Cleaning

The call center provided a messy dataset of customers. The objective was to clean, standardize, and remove duplicates to create an accurate, organized contact list. I used Pandas to load, explore, clean, and export the data, delivering a refined list ready for effective customer outreach.

Image of woman wearing a blue shirt and black trousers sealing a box placed on a table.

Covid Layoff Data Exploration

This project report summarizes the exploratory data analysis (EDA) conducted on the "layoffs_staging2" dataset. Through SQL queries, the analysis provides insights into layoffs, including company details, dates, total count, percentage, industry, country, and funding stage.

Image of two hospital staff in a hospital corridor.

COVID-19 Data Analysis

This is a project using SQL to explore data on covid related deaths and cases globally since 2020.

ETL Pipeline for Bank Data

Bank Market Data ETL is a Python project that automates the process of extracting, transforming, and loading financial market data. It retrieves data from JSON and CSV files, converts market capitalization values from USD to GBP, and logs the ETL process. This project simplifies the handling of financial data for analysis and reporting purposes.

Image of a woman wearing a white shirt sitting by a desk that has stacks of files.

Automatic File Sorting System

The Automated File Sorter is a Python script that organizes files in a specified directory by categorizing them into folders based on their file extensions (.xlsx, .png, .pdf, .txt). It automatically creates folders, sorts files into the appropriate directories.