Skip to content
View lilypeng212's full-sized avatar

Block or report lilypeng212

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
lilypeng212/README.md

Peng, An-Li (Lily)

Business Analytics · Data Strategy · Product & Customer Analytics

I turn data into actionable insights and support data-driven decision-making across analytics, business strategy, and customer-focused problem solving.

💼 McKinsey & Company — Project-Based Business Analyst (E-commerce Project)
📅 Nov. 2024 – Nov. 2025 · Taipei, Taiwan

🎓 National Sun Yat-Sen University — B.A. in Political Economy

🛠 Tools & Skills:
SQL · BigQuery · Power BI (DAX, Power Query) · Looker Studio · R · Python · Dashboard Development · KPI Framework Design

Disclaimer: This portfolio uses sanitized descriptions and synthetic examples only.
No proprietary data, client information, or confidential business logic are included.

📌 Featured Experience

🏢 McKinsey E-commerce Analytics Project

Applied data analytics to support e-commerce growth strategy, including funnel analysis, keyword performance tracking, and product optimization.

🎓 Business Analytics Coursework

Applied data analytics to real-world business problems, including customer segmentation, predictive modeling, and decision-making optimization.

🛒 Customer Segmentation & Marketing Optimization (Ta Feng Retail Dataset)
Developed data-driven segmentation and predictive models to identify high-value customers and optimize marketing ROI.

🏆 Kaohsiung City Youth Bureau — Business Proposal Competition (Excellent Award)

Developed a customer-centric business proposal integrating product design, service experience, and digital travel planning for Spring Hill Resort.

  • Translated customer insights into product, service, and experience strategies

  • Designed differentiated offerings to enhance brand positioning and customer engagement

  • Built a three-layer travel experience system (brochure, website, Google Maps)

  • Project Repository — Strategy, product design, and customer experience

  • Project Website — Interactive travel planning platform

  • Google Maps Travel List — Curated nearby attractions

Popular repositories Loading

  1. Keyword-Dashboard-Big-Query- Keyword-Dashboard-Big-Query- Public

    Keyword performance analytics pipeline using BigQuery, SQL, and dashboard reporting for search and conversion analysis.

  2. Product-Name-Similarity-Analysis Product-Name-Similarity-Analysis Public

    Product name matching and data cleaning workflow using fuzzy matching and similarity analysis techniques.

  3. E-commerce-Growth-Strategy-Analytics E-commerce-Growth-Strategy-Analytics Public

    Automated reporting and analytics framework for e-commerce growth monitoring, funnel analysis, and KPI tracking.

  4. lilypeng212 lilypeng212 Public

  5. Customer-Segmentation-Marketing-Optimization Customer-Segmentation-Marketing-Optimization Public

    Customer segmentation and marketing ROI analysis using RFM modeling and predictive analytics.

  6. Business-Proposal-Competition-ALIVE-Spring-Hill-Resort Business-Proposal-Competition-ALIVE-Spring-Hill-Resort Public

    Integrated business proposal combining product design, customer experience, and digital travel planning.