PORTFOLIO

Pornthip Phermsaphiran

- Interested in the intersection of data science and business -

Results-driven Business Intelligence Analyst with a Master's in Marketing Analytics & Data Science, specializing in enterprise-scale Power BI implementations and end-to-end project delivery. Extensive experience in client requirement gathering, proposal development, and timeline management, combined with technical capabilities in AI automation and machine learning. Proven ability to transform complex business needs into scalable analytics solutions that optimize performance across diverse industry verticals.

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

View All

Dashboard & BI Tools

Explore my comprehensive Power BI dashboard portfolio showcasing end-to-end analytics solutions. Each project demonstrates the complete data pipeline process: from data extraction and transformation using Power Query, to advanced calculations with DAX, resulting in interactive visualizations that drive business decisions.

Click below to view sample projects across various industries.
View Project
View Project

Project Previews

Time Series Analysis
Cluster Analysis
Churn Predictions
Count Data Model (Poisson)

Differential Privacy in Deep Learning-Based Recommendation System

Automation Workflow

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.

View Project

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.

View Project

  • 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

  • Digital marketing: customer engagement, social media, planning, and analytics

  • Digital strategies for business

  • Innovation of products and services: MIT's approach to design thinking

  • Business analytics: from data to insight

  • Digital Marketing Strategies: Data, Automation, AI & Analytics

  • Digital Marketing Strategies