MediaScopePH: Entity-Level Framing of News Coverage on the West Philippine Sea Dispute React · Vite · TailwindCSS · Vercel · Render · Neon PostgreSQL · HuggingFace

• Developed a web-based dashboard to analyze framing patterns across local and international news outlets, facilitating comparative analysis of entity portrayal across sources.
• Integrated a pre-trained NER and cloud-hosted transformer models to perform entity-level framing predictions, enabling real-time classification and automated entity selection.
• Deployed the application across a distributed cloud stack to manage hosting and database, ensuring reliable public access and persistent storage of analysis results.

Power BI: Employee Attrition & HR Analytics Dashboard Google BigQuery · SQL · Power BI · DAX

• Created a 5-page Power BI dashboard connected to BigQuery to track attrition across 5,000 employees, surfacing an 18% overall attrition rate, peaking at 24% in Customer Support.
• Developed 16 DAX measures to transform raw HR data into actionable KPIs, highlighting a 1.3 higher burnout score and a 0.5 wider promotional gap among departing employees.

Music Listener Segmentation: Behavioral Clustering Kaggle · Scikit-Learn · Python · Pandas · NumPy · Matplotlib · Seaborn

• Built a K-Means model to analyze 4,000 listener records for behavior-based personas, delivering 6 interpretable segments validated as free from demographic bias.
• Engineered a feature pipeline to resolve a 0.98 multicollinearity issue and outlier splits, producing a production-ready pipeline for real-time persona scoring.

Web Crawling and Scraping with Scrapy: Job Data Extraction from OnlineJobsPH Python · Scrapy

• Built an automated Scrapy spider to extract job postings from OnlineJobsPH, structuring the scraped data into clean formats for downstream analysis.
• Implemented custom item pipelines to clean text and remove duplicate entries, exporting production-ready JSON files for seamless database integration.

Power BI: Pizza Sales Analytics Dashboard Power BI · DAX · Power Query

• Designed a 3-page Power BI dashboard to track a full year of sales, linking multiple relational tables to build a unified view of daily order metrics.
• Developed custom DAX measures and a Menu Engineering Matrix to rank top and bottom-selling pizzas, providing clear insights to guide menu updates and promotions.

Visualizing the History of Nobel Prize Winners Python · Pandas · NumPy · Matplotlib · Seaborn

• Analyzed 122 years of Nobel Prize records to track winner demographics, identifying US-born men as the most common recipients while highlighting historical first figures.

Exploring NYC Public School Test Result Scores Python · Pandas · Matplotlib

• Filtered NYC public school data to rank top institutions by total SAT scores, computing standard deviations by borough to pinpoint where educational performance gaps were widest.

Getting a Good Sleep at Night Python · Pandas · Matplotlib

• Grouped health records for 374 individuals by occupation and BMI to evaluate sleep quality, revealing the top 5 at-risk professions and confirming that insomnia correlates with BMI.

Investigating Netflix Movies Python · Pandas · NumPy · Matplotlib

• Filtered Netflix’s 2000–2010 movie catalog by genre and runtime, determining the most frequent type of movie released on the platform during that decade.

Uncovering the Oldest Businesses in the World Python · Pandas

• Merged multiple datasets using inner, outer, left, and right joins to organize historical commerce data, mapping the world's oldest continuously operating businesses by country and industry.