?????What I learned in the past 1 year as a data analytics engineer? 2024

????What I learned in the past 1 year as a data analytics engineer? 2024

Frank Lin Frank Lin

Frank Lin

Data Analytics Engineer | Product & Marketing | ex-Google | ex-POYA

发布日期: 2024年4月28日
+ 关注

Many things we can learn from our work and project, I like to list some I learned.

If you interested in joining our team, feel free to follow our pages and my linkedin:

??MySQL

  • Primary Key Design Patterns for better query performance and data constraint.
  • Index design for better query performance.
  • Cluster architecture like writer and readers.
  • Sharding concept like vertical sharding.

??Redshift

  • Distribution key and Sort key design.
  • Query best practice.

??Airflow

  • Backfill best practices.

??Others

  • Google Analytics API.
  • Google API.
  • Slack API.
  • Metabase design.
  • Docker, K8S, Linux, Grafana.
  • Software stuff and culture, you know~

Note

  • i think i will turn this into one page slide someday for something, but this is good for now.



要查看或添加评论，请登录

Frank Lin的更多文章

  • ??Top Tips to Enhance Your LinkedIn Profile
    2024年12月14日

    ??Top Tips to Enhance Your LinkedIn Profile

    1. Name Section ?? Keep it simple and easy to remember.

    3 条评论
  • ?? Do You Know How to Be a Spark in Your Team?
    2024年9月17日

    ?? Do You Know How to Be a Spark in Your Team?

    Managing a project can be frustrating at times, but how do you encourage your teammates to stay proactive and engaged?…

    1 条评论
  • ??Book Review: NGs of Graphic Design
    2024年6月18日

    ??Book Review: NGs of Graphic Design

    ?? TL;DR This is a book review for デザインのミカタ 無限の「ひきだし」と「センス」を手に入れる (cht here). A book offers insights into foundational…

  • ??Book Review: Science of Martial Arts
    2024年5月4日

    ??Book Review: Science of Martial Arts

    ?? TL;DR This is a book review for Bujutsu no kagaku : Ruru ni shibararenai sentojutsu no himitsu (cht here). A book…

  • ??Book Review: The Burnout Society
    2024年4月20日

    ??Book Review: The Burnout Society

    ?? TL;DR This is a book review for The Burnout Society (cht here). A book shares concept of how the society leading us…

  • ??Book Review: How to be Productive with Calm?
    2024年2月18日

    ??Book Review: How to be Productive with Calm?

    ?? TL;DR This is a book review for How to Calm Your Mind: Finding Presence and Productivity in Anxious Times (cht…

    1 条评论
  • ??Book Review: How to Negotiate like a FBI?
    2024年1月28日

    ??Book Review: How to Negotiate like a FBI?

    ?? TL;DR This is a book review for Never Split the Difference: Negotiating As If Your Life Depended On It (cht here). A…

    1 条评论
  • ??Book Review: How to SEO as a Beginner?
    2024年1月28日

    ??Book Review: How to SEO as a Beginner?

    ?? TL;DR This is a book review for SEO白話文：贏得免費流量，創造長期營收的「SEO行銷指南」. A book share concepts and how to set up SEO for your…

    1 条评论
  • 你有出國留學過嗎? 你的英文為什麼說得不錯? - 我的英文學習方法分享
    2023年2月11日

    你有出國留學過嗎? 你的英文為什麼說得不錯? - 我的英文學習方法分享

    因為過去半年，已經有不少朋友問我說，為什麼我英文說得不錯? 所以我想試著將我的經驗整理分享出來。 ?重點摘要? 目標在於敢講，但不在於講的好??。 目標在於如何持續建立習慣獎勵機制，持續輸入與輸出英文溝通。…

  • 寫給我想經營 LinkedIn 的朋友 - 過去 3 年的經營心得
    2022年4月25日

    寫給我想經營 LinkedIn 的朋友 - 過去 3 年的經營心得

    為什麼有這篇文章? 週末和朋友騎車，朋友發現我在經營Linkedin，也想開始經營。因此想寫這篇文章分享給他。 經營 LinkedIn 的重點 : 溝通! LinkedIn…

    3 条评论

社区洞察

其他会员也浏览了