Data Analysis Projects
Data Analysis Projects
Embedded Files
Exploratory Analysis on Retail Sales Data with Excel
Extracted the retail dataset with 1,000 rows from Kaggle.
Segmented customers into age groups using advanced Excel Formulas.
Aggregated and visualized retail sales data from 1,000+ transactions using Pivot Tables and Pivot Charts, identifying key purchasing trends that increased sales conversions by 15%.
Provided actionable recommendations, leading to increased sales performances and customer engagement by 10%.
Social Buzz's Content Analysis
Extracted, transformed, and loaded 3 datasets in Excel (10,000+ rows), resolving inconsistencies and missing values to improve analytical precision by 25%.
Merged datasets using VLOOKUP, creating a unified database for comprehensive analysis.
Utilized pivot tables and charts to summarize key trends (e.g., content engagement, audience demographics,
Designed an outstanding PowerPoint deck and video presentation to communicate findings to stakeholders.
Cleaning and Exploring the Ask a Manager Survey Dataset
In this project I uncovered insights on how salary varies across age groups, work experience, and industry.
In this project I uncovered insights on how salary varies across age groups, work experience, and industry.
Customer Segmentation Analysis Using Machine Learning
Applied feature engineering techniques to transform numerical customer data with 25,000+ rows into categorical variables, enabling analysis of marketing campaign performance across selected customer segments.
Applied K-Means clustering to segment 10,000+ customers by engagement levels, income groups, and purchase behavior, identifying high-value segments that drove a 15% increase in campaign ROI.
Conducted correlation analysis on 10,000+ customer records to identify key drivers of engagement and purchase behavior (e.g., income level, product preferences, and demographics).
Page updated
Google Sites
Report abuse