Skills
Tools
PowerBI
Excel
PowerPoint
Word
Tableau
Programming
HTML
CSS
JavaScript
SQL
Python
Languages
English
Mandarin
Spanish (Novice)
It's a bit of a cliche, but I like to get hands-on when learning things. So in addition to common analyst tools, I picked up some programming languages in my spare time to build this website! Professionally, I've worked with tools like Power BI and Excel, where I've built financial models, automated reports, and created interactive dashboards to drive decision-making. My experience with Excel includes using pivot tables, macros, and advanced formulas to streamline workflows and improve data accuracy. In Power BI, I've developed dashboards that visualize key trends and performance metrics, providing clear insights to stakeholders.
I'm also learning Spanish as a hobby. I'm still very new but as of today's date, I'm on a 90 day streak on Duolingo! My aspiration is to be able to hold a basic conversation and get around without help when I visit Spain and Mexico one day.
I'm also learning Spanish as a hobby. I'm still very new but as of today's date, I'm on a 90 day streak on Duolingo! My aspiration is to be able to hold a basic conversation and get around without help when I visit Spain and Mexico one day.
Projects
Vancouver Real Estate
Excel
pivot tables
built-in functions
pivot charts
An Excel-based interactive dashboard breaking down Greater Vancouver's real estiate market.
Performance Tracker
PowerBI
DAX
This multi-tab dashboard I made analyzes manager performance in terms of revenue generation and operational efficiency. It compares net revenue from 2020 to 2021, showcasing individual manager contributions and highlighting actual revenue versus targets.
The "Data Hygiene" section highlights missing or invalid client data and groups each row by their associated manager. This helps identify gaps or inconsistencies in client information that may need to be addressed.
Call Center
PowerBI
DAX
When learning Power BI, I created this interactive dashboard that offers a high-level overview of a call center's performance. It focuses on metrics like call answering rates, resolution effectiveness, and agent response times. It tracks monthly call volume, shows how quickly agents are responding to calls, and provides insights into customer satisfaction levels.