Hello, I'm Guan-Lun

Welcome to my portfolio!

About Me

I am a dedicated machine learning enthusiast, skilled in Python, SQL, and Git. I thrive in exploring innovative solutions in machine learning, AI, and data visualization, turning complex datasets into meaningful insights. Passionate about transforming raw data and communicating technical findings effectively, I enjoy the challenge of uncovering patterns and making data-driven decisions. Join me as we harness the power of data to shape the future of technology!

My Portfolio

Here are some of my projects that I have done in the past.

Bird Species Classification

Project 1
  • Neural Networks
  • Tensorflow
  • Transfer Learning
  • Audio Fiter

This project focuses on developing a robust classification system capable of identifying bird voice. Leveraging librosa VGG16 pretrained deep learning model, we successfully transfer audio files into spectrogram image and improve the accuracy of classification.

Economic Analyze for Provinces in Canada

Project 1
  • Power BI
  • Python
  • SQL
  • Data Visualization

This project aims to provide a comprehensive overview of the economic performance of Canadian provinces using interactive visualizations created with Microsoft Power BI. By looking at Provincial GDP and average house price, the dashboard enables users to explore key economic indicators, identify trends, and gain insights into regional economic patterns across Canada.

SQL Boxstore

Project 1
  • MySQL
  • DBeaver
  • ERD
  • DBMS

The BoxStore project involves handling a dataset from a box store. The dataset includes comprehensive details about the products. The goal of the project is to efficiently store, normalize, and manage the data in a MySQL database, create additional realistic data, and visualize the relationships using an ERD.

Online Student Portal

Project 1
  • Python
  • SQLite
  • File Handling
  • DBMS

This is a terminal-based online student portal project written in Python. The portal allows students to register, log in, and manage their details, documents, and course fees. The application uses SQLite to store data and includes a status tracking system to monitor the student's progress through the registration process.

My Contacts

I'd love to hear from you! Feel free to reach out via email or connect with me on LinkedIn or GitHub.