Andrew Yu

Hi, I'm a Data Analyst. Explore my projects— if you're tackling a challenge and want to make better decisions, I'm always open to discussing how data can make a difference.

Data Projects & Portfolio

Projects

Showcasing my data analysis projects and case studies.

A laptop with an open screen displaying dashboard analytics featuring charts, graphs, and numerical data related to sales and subscriptions. The interface is predominantly dark-themed with sections highlighting key performance metrics. The device shown is a MacBook Pro, indicated by the keyboard layout and branding.
A laptop with an open screen displaying dashboard analytics featuring charts, graphs, and numerical data related to sales and subscriptions. The interface is predominantly dark-themed with sections highlighting key performance metrics. The device shown is a MacBook Pro, indicated by the keyboard layout and branding.
A laptop displaying a stock market graph with a rising trend is placed on a desk. Next to the laptop are several books stacked on each other, with titles related to investing. A mouse is positioned to the right of the laptop.
A laptop displaying a stock market graph with a rising trend is placed on a desk. Next to the laptop are several books stacked on each other, with titles related to investing. A mouse is positioned to the right of the laptop.
A financial report is laid out with an intricate chart showing data trends over multiple years. Surrounding text appears to be in a newspaper format, with graphs and tables prominently displayed. The focus is on a detailed line graph illustrating fluctuations.
A financial report is laid out with an intricate chart showing data trends over multiple years. Surrounding text appears to be in a newspaper format, with graphs and tables prominently displayed. The focus is on a detailed line graph illustrating fluctuations.
A person with a striped shirt and a cap is standing in front of a computer screen displaying data and analytics. Another laptop is open on a desk below the monitor, and a large metallic tank with a pressure gauge is nearby.
A person with a striped shirt and a cap is standing in front of a computer screen displaying data and analytics. Another laptop is open on a desk below the monitor, and a large metallic tank with a pressure gauge is nearby.

Hi, I’m Andrew Yu — a data analyst with a strong interest in turning data into practical insights that support business decision-making. I recently completed the Google Data Analytics Certificate, where I developed core skills in data cleaning, analysis, visualization, and working with tools such as SQL, R, Tableau, and spreadsheets.

As part of the program, I completed a capstone project analyzing smart device usage data for Bellabeat, a wellness technology company. The goal was to identify user behavior patterns and provide data-driven recommendations to inform their marketing strategy. You can view the full project here, including my process, findings, and insights.

Going forward, I’ll be expanding my portfolio with new analysis projects and sharing the results on this site. Feel free to explore my work or reach out if you'd like to connect.

Datasets

A person is viewing a map with red data points on a computer monitor, likely indicating a geographical distribution. The image has a focus on technology and data analysis.
A person is viewing a map with red data points on a computer monitor, likely indicating a geographical distribution. The image has a focus on technology and data analysis.
Customers

Customer-related information intended to support analysis and insights that can improve the overall customer experience and inform business decisions.

A digital dashboard displaying various analytics charts and graphs. There is a line graph showing user engagement over time on the left, a section with total revenue marked as $74K, and bar charts illustrating user statistics by region. The central section highlights users in the last 30 minutes, focusing on different countries such as the United States, Canada, India, Pakistan, and Brazil.
A digital dashboard displaying various analytics charts and graphs. There is a line graph showing user engagement over time on the left, a section with total revenue marked as $74K, and bar charts illustrating user statistics by region. The central section highlights users in the last 30 minutes, focusing on different countries such as the United States, Canada, India, Pakistan, and Brazil.
A person holds a smartphone displaying a stock market application with graphs and financial data. A laptop is visible in the background, slightly blurred.
A person holds a smartphone displaying a stock market application with graphs and financial data. A laptop is visible in the background, slightly blurred.
A tablet screen displaying a financial chart with two lines, one red and one cyan, representing data trends over time. The background is dark with text showing figures at the top, including maximum, minimum values, and a percentage.
A tablet screen displaying a financial chart with two lines, one red and one cyan, representing data trends over time. The background is dark with text showing figures at the top, including maximum, minimum values, and a percentage.
Climate

Information related to climate trends, environmental impact, and green energy metrics. It is intended to support analysis on sustainability, energy efficiency, and eco-friendly practices.

What is Data Analysis?

The purpose of data analysis is to discover useful insights and make informed decisions for both businesses and individuals to solve real problems.

Think about a situation in your own life where you are unsure what to do. Instead of relying on your intuition alone, having the right data can help you understand the problem more clearly and choose a smarter path forward. That is the power of data analysis: turning uncertainty into clarity. We do this by collecting, organizing, and examining data using tools like Excel, SQL, R, and Python.

At its core, data analysis empowers us to understand what’s happening, why it’s happening, and what actions will lead to better outcomes.

What is Data Analysis?

The purpose of data analysis is to discover useful insights and make informed decisions for both businesses and individuals to solve real problems.

Think about a situation in your own life where you are unsure what to do. Instead of relying on your intuition alone, having the right data can help you understand the problem more clearly and choose a smarter path forward. That is the power of data analysis: turning uncertainty into clarity. We do this by collecting, organizing, and examining data using tools like Excel, SQL, R, and Python.

At its core, data analysis empowers us to understand what’s happening, why it’s happening, and what actions will lead to better outcomes.

6 Major Steps of Data Analysis

1. Clarify Your Goal

Start by defining what you’re trying to achieve. Are you exploring a trend, solving a problem, or making a decision? A clear goal helps keep your analysis on topic and focused. If you're analyzing for someone else, ask questions to fully understand their needs. During the phase, using SMART questions can help turn vague ideas into clear, measurable questions.

2. Prepare your Data

Once your goal is clear, figure out what data you need. This could mean collecting raw datasets, scraping websites, or pulling from databases. Make sure your sources are reliable and relevant to your objective. Think about: what kind of data will actually help you answer your question? Avoid sources that might introduce bias or lead to misleading results.

If you need help on collecting data, here are some suggestions on how to collect reliable and useful data.

3. Process the Data

Most data come in messy. Cleaning it, removing duplicates, correcting errors, and standardizing formats is a big part of data analysis. At this stage, you're making the data usable while remaining reliable which leads to accurate results. At the end of this process, write a simple data cleaning report to keep track of what you changed. It helps others understand your process and makes your work easier to review or repeat later.

4. Analyze the Data
5. Share Your Findings (Data Visualization)
6. Next Steps & Follow-ups

Now it’s time to dig into the data. Use tools like Excel, Tableau, Python, or R to explore patterns, trends, and relationships. You might use pivot tables, charts, or statistical methods to look for patterns, trends, or relationships that help answer your question.

Make sure to double-check your calculations to make sure everything is accurate before drawing conclusions. The goal is to turn raw data into clear insights

Present your insights in a way that’s quick and easy to understand. A good rule: your audience should grasp your graph within 5 seconds. Use clear, relevant visuals—like charts, dashboards, or reports—and focus on what matters most. Tell an interesting story and explain what it means, don’t just show data.

Think about your audience: What will make the message click for them? Also, keep accessibility in mind (color, labels, readability), and remember to write a short markdown summary and cite your sources.

To make your analysis truly useful, make sure actions are taken. List clear next steps based on your findings—it can be refining a product, adjusting a strategy, or asking new questions.

Always revisit your assumptions and build a feedback loop. Good analysis doesn’t end with answers—it leads to better decisions and continuous improvement.

Below, I break down the 6 key steps I follow in my analysis workflow — from defining the problem to turning data into clear answers and practical next steps.

Andrew Yu

Phone
Email

778-319-3727

andrew@thoughtyose.co.site

Kaggle
Infantry Soldier | The Republic of China Armed Forces
  • Demonstrated resilience and adaptability in high-pressure environments while maintaining a solutions-oriented mindset

  • Practiced disciplined execution and attention to detail critical to team safety and operational success.

Additional Skills

Experience

Education & Certifications

Co-Founder | Metric Innovative Solutions
  • Designed and developed the company website from scratch using Google Sites, applying principles of UX and content optimization to drive 1,000+ unique visitors.

  • Built Sun Metrics Calculator, an Excel-based solar ROI tool that collects user inputs and automatically logs data into a centralized database, improving lead tracking and client analysis.

  • Developed automated workflows to streamline internal processes, including client intake, proposal generation, and performance tracking—reducing manual work and increasing consistency.

  • Created detailed 3D solar proposals and technical diagrams that supported permit applications and solar feasibility analysis across BC, Alberta, and Ontario.

  • Used structured data and system modeling to support client decision-making, including solar production forecasts, ROI projections, and shading analysis.

  • Maintained and monitored internal data to improve operations and inform marketing priorities, including early-stage customer behavior from web and form submissions.

Structural Detailing Engineer | Profab Steel Ltd.
  • Applied strong attention to detail in reviewing drawings, part specifications, and fabrication data, supporting error-free documentation and quality control.

  • Maintained organized file structures and implemented naming conventions for technical documents, improving team efficiency and version control.

  • Ensured clear, consistent communication with architects, structural engineers, fabricators, and site supervisors to support project workflows, reduce fabrication and construction issues, and clarify project requirements.

  • Used and maintained spreadsheet-based material tracking tools (BOMs, inventories), helping ensure accuracy in part lists and fabrication readiness.

  • Assisted in tracking drawing revisions and change requests to identify patterns in design adjustments and support ongoing quality assurance.

Google Data Analytics Certification
  • Developed analytics tools; proficient in Spreadsheets, intermediate in R for statistical analysis, and SQL for database querying

  • Developed analytics tools; proficient in Spreadsheets, intermediate in R for statistical analysis, and SQL for database querying

Microsoft Certified: Azure AI Fundamentals
  • Demonstrated proficient knowledge of AI concepts, machine learning, and Azure AI services for data-driven decision-making

Computer Information Technology Diploma
  • Applied skills in database management, web development, and data analysis to create functional and scalable solutions

  • Developed technical proficiency in SQL, Python, R, HTML, CSS, JavaScript, and React through hands-on projects and coursework.

  • Additional Technical Skills: Business Analytics, Project Management, DeepSeek, CAD, Tableau

  • Languages: English, Mandarin

gray computer monitor

Get in Touch

Let me know what you're curious about. Questions, comments, or critiques are always welcome. If you'd like to connect or chat more, feel free to reach out.