Hello there, I'm

Alan-Deng

Electrical Engineer → Data Analyst

About

Data Analyst with an Electrical Engineering background and a passion for Solving Complex Problems. I analyze data to uncover valuable information that leads to Effective Business Decisions.

My Technologies

external-sql-coding-and-development-outline-outline-juicy-fish
SQL

Structured Query Language

python--v1
Python

Programming Language

tableau-software
Tableau

Data Visualization

ms-excel
Excel

Spreadsheet Editor

Personal Projects

World Happiness Dashboard

An interactive dashboard that visualizes correlations between the World Happiness Index and factors like population, education spending, and migration.

  • Python
  • SQL
  • Excel
  • Data Cleaning
  • Data Visualization

Pet Image Classification Model

An AI-powered tool identifies pet types (cats, dogs, etc.) from uploaded photos.

  • Python
  • Ai Model Training
  • Data Collecting
  • Data Cleaning

Screen Time Analysis

An Excel dashboard analyzes how screen time impacts middle-aged adults compared to other age groups.

  • Excel
  • Data Analysis
  • Data Visualization

Dashboards

Microsoft Excel Dashboards

A repository of interactive Excel dashboards showcasing advanced techniques like dynamic charts, pivot tables, and effective data visualization.

Tableau Portfolio

My Tableau portfolio features interactive dashboards that turn complex data into actionable insights, showcasing expertise in data storytelling and visual analytics.

Education

Bachelor of Engineering (Honours), Electrical Engineering

University of Ontario Institute of Technology / Ontario Tech University

  • Strategic Thinking
  • Problem Solving
  • Project Management
  • Time Management

Completed: May 2020

Data Analytics Boot Camp

University of Toronto School of Continuing Studies

  • Python
  • Microsoft Excel
  • HTML
  • CSS
  • JavaScript
  • Statistical Modeling
  • Data Visualization

Completed: June 2023

Online Courses

Google's Foundations of Project Management

Coursera

  • Project Management
  • Strategic Thinking
  • Organizational structure

Completed: Oct 2021

Responsive Web Design

freeCodeCamp

  • HTML
  • CSS

Completed: Dec 2023

The Complete JavaScript Course 2024: From Zero to Expert!

Udemy

  • JavaScript
  • Data Structures
  • Object-Oriented Programming
  • HTML
  • CSS

Completed: June 2024

Statistics for Data Science and Business Analysis

Udemy

  • Microsoft Excel
  • Data Science
  • Business Analytics
  • Statistics

Completed: Nov 2024

MySQL for Data Analytics

Analyst Builder

  • SQL
  • Data Cleaning
  • Exploratory Data Analyst

Completed: Dec 2024

MySQL Interview Crash Course

Analyst Builder

  • SQL
  • Data Cleaning
  • Exploratory Data Analyst

Completed: Dec 2024

Advanced MySQL for Data Analysis

Analyst Builder

  • SQL
  • Query Optimizing
  • Store Procedures
  • Triggers and Events

Completed: Dec 2024