As a Data Analyst consulting for a banking institution, I conducted an in-depth analysis of a dataset containing 13.6 million customer records to uncover insights into customer behavior and identify cross-selling opportunities for the bank's products. Leveraging Python and its extensive libraries, I performed data cleaning and visualization tasks, which included standardizing column names, addressing missing values, and creating a refined dataset of 949,609 unique customers. For further analysis, I exported the...

Embark on a journey into the world of retail as this project uncovers valuable insights for Sylip Corporation, a versatile retail company offering household items, groceries, clothing, and more. Leveraging sales data...

This project centers on analyzing energy consumption and CO2 emissions data to uncover insights into global energy trends and their environmental impact. Using SQL, I conducted a comprehensive analysis, including trend analysis, correlation analysis, as well as regional and country-specific evaluations. Key findings reveal a general increase in both energy consumption and CO2 emissions over time, a strong positive correlation between these two factors, and significant variations in energy intensity and emissions across different regions and countries. The project serves as an exploration and research initiative in the fields of energy and environmental analysis, offering a foundation for predictive modeling and the integration of additional data sources. By harnessing the power of SQL and various data analysis techniques, this project provides valuable insights into the intricate relationships between energy consumption, CO2 emissions, and environmental sustainability.

Leading a talented team of 5 analysts at Digital Echoes, I spearheaded a project focused on analyzing key performance indicators (KPIs) for Facebook and Instagram advertisements and campaigns. The primary objective was to provide actionable recommendations to enhance the effectiveness of these ads. We began by meticulously extracting, cleaning, and validating the data to ensure its integrity. Through comprehensive exploratory data analysis (EDA), we examined critical metrics such as ad spend, reach, engagement, and monthly growth rate, uncovering valuable insights and trends. Leveraging SQL, we extracted meaningful insights that enabled us to pinpoint areas for improvement in the advertisements and highlight components that excelled. We presented our findings via Power BI, offering a clear, data-driven approach designed to transform advertising and business strategies, ultimately maximizing their impact and effectiveness.