My Portfolio
Welcome to my project portfolio! Here, I showcase the various data analytics and geographic information system (GIS) projects I’ve worked on using a range of tools including SQL, Excel/VBA, Power BI, Python, and GIS software. Each project highlights my ability to analyze data, build visualizations, and create actionable insights. Explore the sections below to see how I’ve applied these skills to real-world problems.
Depression Dataset Analysis
A Comprehensive Analysis of Mental Health, Lifestyle, and Socioeconomic Factors
Source: Kaggle
Description: This dataset contains various lifestyle, health, and socioeconomic factors linked to mental health. It includes attributes like age, education, income, employment, sleep, and more. A key feature is the identification of individuals with a history of mental illness.
Goal: To explore the relationships between mental health and these factors to understand trends and correlations.
Global Sales and Warehouse Data Analysis
Description: This project focuses on analyzing sales performance, product distribution, and warehouse efficiency using Power BI. The dataset consists of sales transactions, product characteristics, and warehouse mapping data. The goal of the project is to uncover insights related to the Cost of Goods Sold (COGs), year-over-year order trends, delivery costs, and operational inefficiencies across warehouses and regions. Through data visualizations and KPIs, the project highlights areas for cost optimization and operational improvements within a global logistics context.
Customer Sales and Shipping Insights Dataset
Description: This dataset is a comprehensive collection of sales and shipping records for a retail company. It consists of multiple sheets that capture various aspects of the business, including orders, customer returns, shipping costs, and personnel management. The dataset is used to perform detailed analysis on sales performance, customer behavior, product profitability, and shipping efficiency.
Goal: The goal of this analysis is to utilize the dataset to answer key business questions that provide insights into customer behavior, sales performance, product profitability, and shipping efficiency.
