👋 Hi, I'm Yuet Chan

Data Analyst | Business Analyst | IT Support Specialist

🍎 Educator Turned Data Analyst
💻 Excel, Tableau, SQL, Python, R
👟 Hiking, Golf, HIIT Workouts
📍 Charlotte, NC USA

Technical Skills

  • Tableau

  • Power BI

  • Looker

  • Project Management

  • SQL

  • Excel

  • Python

  • R

Projects

💵 Financial Analysis of World Bank Loans with SQL

Excel | Financial Trend Analysis
◾ Analyzed 1.2M+ World Bank loan records using advanced SQL to uncover global lending trends, repayment patterns, and financial outliers.
◾ Used complex SQL queries, CTEs, aggregations, and window functions to transform raw financial data into actionable insights.
◾ Conducted trend analysis on loan balances, repayment obligations, and project financing.

.

🪨⛏️Mining with Python

Python | Manfacuturing Data Analysis
◾ Explored large-scale industrial sensor data using Python to uncover operational trends and production anomalies.
◾Cleaned and transformed time-series process data for analysis and visualization using Pandas.
◾Created visualizations to monitor fluctuations in flotation column performance and iron concentrate quality using Seaborn and Matplotlib.
◾Translated complex operational data into clear analytical insights.

.

🏥 Diabetic Readmission with SQL

SQL | Healthcare Data Analysis
◾Analyzed 100K+ hospital records using SQL to identify factors associated with diabetic patient readmissions.
◾ Used JOINs, CTEs, CASE statements, and window functions to uncover trends in patient outcomes and hospital utilization.
◾Applied data segmentation and trend analysis to evaluate diabetic readmission patterns across age groups and demographics.

.

🥡 iFood Customer Loyalty Project

Excel| Exploratory Data Analysis
◾ Analyzed a modified iFood customer dataset in Excel to identify key drivers of customer loyalty and spending behavior across demographic and behavioral segments.
◾Cleaned and validated customer data by creating a helper-column duplicate detection system using TEXTJOIN() and Conditional Formatting to identify and remove duplicate records.
◾Created customer segmentation logic in Excel using IFS() and nested formulas to group customers by age range, education level, marital status, recency, and marketing campaign engagement.

.

🏀 Analyzing NBA Data with Tableau

Tableau | Dashboarding
◾ Analyzed the 2022 NBA season statistics
◾ Created Stacked Bar Charts, Heatmaps, Treemaps & Bubble Charts
◾ Built a Tableau story

.

About Me

👋 Hi, I’m Yuet — a data analyst passionate about turning complex data into clear, actionable insights.With a background in education and tech support, I bring both technical problem-solving skills and strong communication to every project. I currently use SQL extensively to analyze data, troubleshoot issues, and build reports that help drive decision-making.My toolkit includes:
• SQL
• Python
• Excel
• Tableau
• Power BII enjoy working on projects involving financial analytics, business intelligence, and large-scale data exploration. And I'm looking to help a company extract insights from their data. If you'd like to contact me, feel free to email me: [email protected].

Resume

💻 Escalated Customer Support Team Member
Kaleidoscope Learning· Remote, NC· May 2024 - Present
◾ Create and customize reports using complex SQL queries, Python scripts, and Excel to support customer decision-making and drive data-informed internal analysis.
◾ Troubleshoot and resolve complex customer issues across an e-learning platform serving over 100,000 school administrators, teachers, and students, utilizing SQL queries, database updates and Python.
◾ Manage escalated Zendesk tickets, collaborate cross-functionally with engineering teams on product defects, and communicate technical solutions in accessible terms.🏭 Management Trainee
Keer America · Indian Land, SC · Oct 2023 - May 2024
◾ Conducted daily quality and durability tests on textiles to support product quality improvement and machinery performance optimization.
◾Analyzed test data with Excel and prepared quality reports daily using Excel to identify trends and support operational decision-making.
◾ Communicated quality and new product development testing results to senior management and the engineering teams to support continuous improvement initiatives.🏫 Teacher
ILIM School · Pineville, NC· September 2021 - October 2023
◾ Collected, analyzed, and interpreted student assessment data to identify learning gaps and tailor instruction, improving overall student performance.
◾ Used quantitative and qualitative data to drive evidence-based decisions and communicate actionable insights to parents and school administrators.
◾Maintained and managed records for 20+ students, ensuring accuracy and confidentiality.