Skip to content
View xyzplanet's full-sized avatar
1 follower · 4 following
  • Liverpool, UK

Achievements

Achievement: YOLO

Achievements

Achievement: YOLO

Block or report xyzplanet

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.

Content in all repositories owned by your account will be closed.
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
xyzplanet/README.md

Hi I'm Yancong 👋

🥷 Data Analyst | Data Technician

Data Analyst focused on building end-to-end analytics pipelines, SQL modeling, and interactive BI dashboards.

🛠️ Tech Stack & Tools

  • Languages & Libraries: Python (Pandas, NumPy), SQL (PostgreSQL, Azure SQL)
  • Cloud & Databases: Azure (Blob Storage, SQL Database), SQL Server
  • Visualization: Power BI, Tableau
  • Workflow & Tools: Git/GitHub, VS Code, Jupyter Notebooks

🥷About Me

  • 🔭 I’m currently working on: Building end-to-end data analytics pipelines (Retail RFM customer analytics) using Python, SQL window functions, and Azure Cloud, alongside developing computational chemistry / AI-driven software workflows.
  • 🌱 I’m currently learning: Advanced Azure Cloud architecture (Data Factory & Azure SQL optimization), React Native / Supabase for full-stack apps, and deep-dive football spatial analytics (mplsoccer).
  • 👯 I’m looking to collaborate on: Open-source data analytics tools, Python-based computational chemistry workflows, or sports analytics projects.
  • 🤔 I’m looking for help with: Best practices for CI/CD automated deployment pipelines on Azure and scaling cloud-native data platforms.
  • 💬 Ask me about: Python (Pandas/PyTorch), SQL data modeling & window functions, computational chemistry & molecular simulations, or how to build interactive BI dashboards!

🚀 Featured Portfolio Projects

  • Ecommerce RFM & Customer Segmentation: End-to-end data pipeline using Azure Blob Storage, Python ETL, SQL window functions, and Power BI.
  • 📫 How to reach me: [Your Email Address] | [Your LinkedIn Profile URL]

Popular repositories Loading

  1. zoom-recording-downloa_snologyder zoom-recording-downloa_snologyder Public

    Forked from ricardorodrigues-ca/zoom-recording-downloader

    Downloads and organizes all cloud recordings from your Zoom Business account for synology nas system

    Python

  2. L3-Certificate-in-AI-Programming-with-Python L3-Certificate-in-AI-Programming-with-Python Public

    Forked from CherylPawluk/L3-Certificate-in-AI-Programming-with-Python

    Holds the .txt/.py files used in this unit.

    Python

  3. smart-llm-router smart-llm-router Public

    A generalized, lightweight, and extensible AI Gateway & Routing Framework built with FastAPI and Streamlit.

    Python

  4. xyzplanet xyzplanet Public

  5. RFM_project RFM_project Public

    Jupyter Notebook