LANGUAGE / 語言

arrow_back Career Timeline

Career 03 · Jun 2021 – Dec 2021

Mighty IT League Inc.

Data Analyst Intern

Data Foundation

Jun 2021 – Dec 2021
database

MY STORY

這是我正式進入 data analytics 的階段，也是我把商業問題轉成資料邏輯的起點。This was my formal entry into data analytics and the starting point of translating business questions into data logic.

OVERVIEW

在 Mighty IT League，我擔任 Data Analyst Intern，使用 SQL、R 和 MySQL 處理大量資料。我處理過 5M+ records 的資料集，建立 MySQL ETL 流程，也產出過 50+ SQL reports。這段經驗讓我從單純整理資料，逐步進入資料查詢、清理、轉換、報表和 business analysis 的完整流程。At Mighty IT League, I worked as a Data Analyst using SQL, Python, R and MySQL to handle large datasets. I processed 5M+ records, built MySQL ETL flows and produced 50+ SQL reports. This experience moved me from data organization into the full cycle of querying, cleaning, transforming, reporting and business analysis.

我主要負責什麼What I Owned

  • check_circle我使用 SQL / MySQL 查詢、清理和轉換資料，將 raw data 轉成可以分析和報告的格式。I used SQL and MySQL to query, clean and transform raw data into formats suitable for analysis and reporting.
  • check_circle我參與建立 MySQL ETL 流程，讓資料可以更穩定地被抽取、整理和使用。I helped build MySQL ETL flows so data could be extracted, organized and used more consistently.
  • check_circle我產出 50+ SQL reports，支援團隊和 business stakeholders 查看不同維度的數據結果。I produced 50+ SQL reports to help teams and business stakeholders review data from different perspectives.

我如何理解 Data Analyst 的角色How I Understood the Data Analyst Role

  • check_circleData Analyst 不是只把資料拉出來，而是要知道 business question 是什麼。A Data Analyst is not just someone who extracts data; the role starts with understanding the business question.
  • check_circle我需要確認欄位定義、資料來源、過濾條件、時間範圍和 aggregation logic，否則報表很容易看起來正確但實際上解讀錯誤。I had to confirm field definitions, data sources, filters, time ranges and aggregation logic; otherwise a report could look correct but be interpreted incorrectly.
  • check_circle我學會在寫 SQL 時思考結果是否合理，而不是只看 query 有沒有跑出數字。I learned to check whether SQL results made business sense, not just whether the query returned numbers.

我建立的 technical foundationTechnical Foundation I Built

  • check_circleSQL reporting：熟悉 JOIN、GROUP BY、CASE WHEN、aggregation 和 filtering 等基礎邏輯。SQL reporting: building familiarity with joins, grouping, case logic, aggregation and filtering.
  • check_circleETL thinking：理解資料需要經過 extraction、transformation、loading 才能成為可用資料產品。ETL thinking: understanding that data needs extraction, transformation and loading before it becomes a usable data product.
  • check_circleLarge dataset handling：開始理解效能、資料量、查詢結構和資料表設計的重要性。Large dataset handling: understanding the importance of performance, data volume, query structure and table design.

What I Took Away

這段經驗是我 data career 的基礎。它讓我從 business operation 走向 data-driven problem solving，也讓我後來能在更複雜的 enterprise analytics 環境裡持續往前推進。This experience became the foundation of my data career. It moved me from business operations into data-driven problem solving and prepared me for more complex enterprise analytics environments.

arrow_back 上一頁Previous 下一頁Next arrow_forward