| Python, SQL | Social Media Engagement Capstone Project |
Developed and implemented an end-to-end ETL pipeline for processing social media engagement data across Instagram, Twitter, and YouTube. The pipeline encompassed extracting raw data, performing data transformation using Python, orchestrating the pipeline on PostgreSQL, and creating a dashboard using Tableau. View Code on GitHub
| Python | FIFA 21 Players Dataset Data Cleaning & Transformation |
Analyzed the FIFA 2021 player dataset with a focus on data cleaning, transformation, and exploratory data analysis (EDA). This extensive dataset provided in-depth information about football players, encompassing attributes, ratings, positions, and personal details. Through EDA, I delved into player attributes and positions, uncovering valuable insights, including the identification of highly valuable but underpaid players. View Code on GitHub
| Excel | Coffee Bean Sales Dashboard |
Analyzed global coffee bean sales data using Excel. Ulitized Excel functions such as XLOOKUP, Index Match, Pivot Charts to clean and format columns. Visualized key insights, including interactive timeline, sales over time, bean roast preferences, package size, top sales by country, and top 5 customers.
