Projects Portfolio

Welcome to my projects portfolio! I am a mid-career professional transitioning into the world of data analytics, machine learning and AI. I am passionate about continuous learning and currently building my skills in:

• Programming for data analysis and machine learning - Python, SQL
• Data Visualization - Tableau, Power BI
• Automation - Power Automate, UiPath, Zapier, Make.com, n8n

Data Visualization and Storytelling

1. Analysis and report titled “From Past to Present: An Analytical Overview of Singapore’s Parliamentary Elections”
   • all report writing and data work and data appendix are done within RMarkdown
   • extract elections data from the Elections Department (ELD) via data.gov.sg API
   • Constuct a range of visually compelling visualization to highlight significant events

Language/Program used: R/R Studio, Packages: tidyverse, ggplot2, dplyr, jsonlite, geojsonsf

Data Wrangling, Analytics & Visualisation

1. Customer Satisfaction Analysis for a New Shopping Mall
   • Create Python scripts to automate the acquisition and processing of web and spreadsheet data
   • Assemble effective data flows in MySQL, Python & R as part of a reproducible workflow process
   • Design and implement effective data visualizations in R

Language/Prgram used: Python/Jupyter notebook, MySQL/TablePlus, R/R Studios

1. Data wrangling using MySQL statements
   • CREATE Table, ALTER Table, Modify data type, mapping data
   • Generate summary tables to explain relationship amongst the variables in the dataset

Language/Program used: MySQL/TablePlus/MySQL Workbench

AI-powered automation workflows

• Multilingual Agentic Chatbot is a n8n automation workflow that integrates a Telegram bot with AI Agents capable of handling both text and voice messages to fulfil users’ queries and execute tasks.

• Running Route Bot is a Telegram bot that generates personalized running routes based on user inputs like distance, run type
• It integrates real-time weather data and generates a Google Maps links for navigation

• a personal hobby project that combines my love for running and learning new technologies

Program used: n8n, Zapier automation, Claude.ai, Telegram, SerpAPI, OpenWeatherMap API, OpenRouteService API, Strava

LLM-powered Low code App Development

• Build a simple chatbot app using Flowise with LangChain Framework.

Language/Program used: Hugging Face, Flowise

Predictive Analytics and M/L (E-Commerce Customer Analytics)

• Data Preparation, Transformation (Power Query) and Visualization (PowerBI)
• Build and Evaluate a Churn prediction model using KNIME

Language/Program used: Excel Power Query, PowerBI Desktop, KNIME

Regression Analysis

Building and evaluting a simple linear regression

• This project was done in the course Regression Analysis: Simplify Complex Data Relationships,
• which is part of Google Advanced Data Analytics Professional Certificate.

Language/Program used: Python/Jupyter notebook, libraries: Pandas, statsmodels, matplotlib, seaborn

Hypothesis testing

• this project is to demostrate knowledge of how to conduct a two-sample hypothesis test
• using stats.ttest_ind(a, b, equal_var) function to conduct two-sample t-test

Language/Prgram used: Python/Jupyter notebook, libraries: Pandas, stats.scipy

Back to github