PORTFOLIO

Pornthip Phermsaphiran

- Interested in the intersection of data science and business -

Microsoft Certified Power BI Data Analyst Associate with expertise in business intelligence, data analytics, and automation solutions. Proven track record in developing interactive dashboards, implementing RAG strategies, and delivering data-driven insights. Experienced in teaching and training across BI tools, automation platforms, and analytics methodologies.

Projects Summary

    • Performed user segmentation using PCA, K-Means, and Random Forest algorithms on survey data

    • Developed detailed profiles for each segment, highlighting key demographic and behavioral insights


    • Performed hypothesis testing (T-Test, ANOVA)

    • Designed and built interactive performance dashboards

    • Retrieved and transformed data via SQL

    • Developed integrated dashboards to monitor sales performance, customer trends, and inventory levels

    • Identified cross-selling opportunities and optimized stock replenishment strategies


Project Portfolio

Project Previews

Differential Privacy in Deep Learning-Based Recommendation System

In an increasingly data-centric world, the need to protect privacy while maintaining data utility or the ability to leverage data for useful purposes is a pressing concern, especially in recommendation systems.

This study aims to explore and employ the concept of differential privacy, a noise-infusion technique that ensures rigorous privacy protection, to examine its influence on the performance of deep learning models.

As the noise injection affects the model performance, the study navigates the inherent tension between data privacy and the utility trade-off.

Automation Workflow

This portfolio showcases a series of automation projects developed to enhance business efficiency, reduce manual workload, and unlock new capabilities through AI integration. Each workflow is designed to address real operational challenges by automating routine tasks, enabling intelligent decision-making, and improving responsiveness across business functions.

  • 1. Facebook Messenger Chatbot
    Automates customer chat handling by using AI to interpret and respond to user messages in real time—improving efficiency and response speed.

  • 2. Automated Facebook Post Generator
    Converts content ideas from Google Sheets into complete, scheduled posts with AI-generated text and visuals—reducing content production time.

  • 3. Knowledge Embedding for AI Chatbots
    Processes and embeds business data into a vector database to enable accurate, data-driven responses from Retrieval-Augmented Generation (RAG) chatbots.

  • 4. LINE Chatbot with Intent Recognition
    Uses AI to detect user intent, retrieve relevant data, and respond via LINE—supporting real-time engagement and automation of common inquiries.

  • 5. AI Business Analyst via Chat
    Transforms natural-language business questions into SQL queries, returning insights and visual reports instantly through LINE—automating data analysis.

Training

Training

  • Teaching Assistant – Marketing Analytics, Thammasat University

  • Teaching Assistant – Power BI Training

    • Assisted in delivering Power BI workshops with hands-on training.

  • Teaching Assistant – SQL, Data Analytics and Data Science

Certificates and Courses