Zach Quinn

~ Boosted Medium Articles ~

Overall Stats

• Coding An End-To-End Credit Card Spend Pipeline In 1 Weekend

  Visualizing 48 Months Of Credit Card Spending With PyPDF, SQL & Looker (Part II).

  4,331 views ‧ 1,598 reads ‧ 36.9%

  data-science

  programming

  Jan 20, 2025

  Jan 20, 2025

• I Lost 3 Days Of Data By Not Taking 10 Min. For These Deprecation Steps

  How data engineers can anticipate, adapt to and recover from inevitable data downtimes and API outages.

  1,220 views ‧ 463 reads ‧ 37.95%

  data-science

  programming

  Apr 24, 2024

  Apr 25, 2024

• How I Used Python & SQL To Build A Looker Dash During A Baseball Game

  The 35 line SQL Query That Powers A Top 3 SQL Publication's Analytics (Part II).

  3,454 views ‧ 1,338 reads ‧ 38.74%

  programming

  Apr 23, 2024

  Apr 24, 2024

• Not Getting Data Science Job Interviews? You Have A Visibility Problem

  Data science job applicants are facing more competition than ever; how to create compelling work to stand out — the right way.

  3,358 views ‧ 1,599 reads ‧ 47.62%

  data-science

  Apr 10, 2024

  Apr 11, 2024

• Why Your Data Pipelines Will Fail On These 10 Days Every Year — And What To Do About It

  When the clock strikes midnight on certain days of the year (or decade) your pipelines will transform into functionless code.

  4,467 views ‧ 2,022 reads ‧ 45.27%

  data-science

  programming

  Apr 02, 2024

  Apr 03, 2024

• If You Missed This BigQuery Email You Could Lose Your SQL Queries

  What you need to do to avoid losing your work in the fast-approaching Google Cloud BigQuery Studio migration.

  2,039 views ‧ 878 reads ‧ 43.06%

  programming

  Feb 19, 2024

  Feb 20, 2024

• How Not To Annoy Senior Developers — Sincerely, A Senior Data Engineer

  Proactive strategies covering how not to annoy your senior data scientists, engineers or developers from a senior's perspective.

  2,660 views ‧ 1,443 reads ‧ 54.25%

  work

  programming

  Jan 17, 2024

  Jan 18, 2024

• Pandas' 2.0 Release Deprecated Your Favorite Method. What Now?

  Pandas' 2.0 update deprecates a function so popular it's in the top 10 docs searches. How to adjust your data transformations.

  6,551 views ‧ 3,084 reads ‧ 47.08%

  data-science

  programming

  Jan 10, 2024

  Jan 11, 2024

• 2023 In 12 Data Engineering Errors That Ultimately Advanced My Skills

  What new data engineers can learn from my struggles and discoveries troubleshooting Python, SQL and Airflow errors.

  2,654 views ‧ 1,319 reads ‧ 49.7%

  programming

  Jan 02, 2024

  Jan 03, 2024

• For Data Engineers The Real Y2K Happens Twice A Year

  The bi-annual problem data engineers ignore year after year — sometimes to disastrous effect.

  1,936 views ‧ 995 reads ‧ 51.39%

  data-science

  programming

  Nov 15, 2023

  Nov 16, 2023

• The Simple Reason Your Data Pipelines Will Never Be 100% Automated

  Even AI solutions can't fix gaps in vendor infrastructure and the ultimate data engineering constraint — time.

  2,686 views ‧ 1,277 reads ‧ 47.54%

  data-science

  programming

  Nov 09, 2023

  Nov 10, 2023

• Am I Doing A Data Science Certificate For The Wrong Reason?

  Your LinkedIn might show a lot of data science certificates, but are you actually learning? And will those skills get you a job?

  1,945 views ‧ 1,057 reads ‧ 54.34%

  data-science

  programming

  Nov 01, 2023

  Nov 02, 2023

• Create Your ETL Pipeline In 90 Min. (A Best Case Scenario)

  Creating a data engineering pipeline using Python, SQL and Google Cloud in less than 2 hours.

  8,075 views ‧ 2,729 reads ‧ 33.8%

  programming

  Oct 18, 2023

  Oct 19, 2023

• Why Don't I Feel Prepared In Data Science Interviews?

  Most data science candidates are unprepared for the most important — and basic —  job interview question of all.

  6,754 views ‧ 3,465 reads ‧ 51.3%

  data-science

  work

  Oct 09, 2023

  Oct 10, 2023

• Python Logs Aren't Code. They're A Communication Tool.

  Embrace logs as communication plus 3 non-negotiables you must include for a functional, transparent data pipeline.

  3,240 views ‧ 1,360 reads ‧ 41.98%

  programming

  Aug 14, 2023

  Aug 14, 2023

• I Failed Calc But I Can Do Data Engineering Math And So Can You

  Learn the fundamental and surprisingly simple math concepts that form the basis for most analytics or data engineering jobs.

  3,943 views ‧ 1,682 reads ‧ 42.66%

  data-science

  programming

  Aug 02, 2023

  Aug 02, 2023

• After 2 Years Working From Home I Now Have A 6,000 Mile Commute

  After stumbling into an international commitment I've developed a borderline-superhuman tolerance for air travel, shrugging off a...

  2,125 views ‧ 1,236 reads ‧ 58.16%

  travel

  Jul 06, 2023

  Jul 06, 2023

• Overcoming The Final Hurdle of Data Automation With Fewer Failures

  Learn the components of data pipeline production to take your ETL build from code to cloud with automated, actionable results.

  1,997 views ‧ 877 reads ‧ 43.92%

  programming

  Jul 03, 2023

  Jul 03, 2023

• The Quiet Allies and Hidden Casualties In The Reddit War

  To a sub of only 100k members, the Reddit war is about a principle that hits close to home and could harm many of their own.

  2,489 views ‧ 1,218 reads ‧ 48.94%

  programming

  Jun 15, 2023

  Jun 15, 2023

• Remote Work Is Better For Everything — Except Your Anxiety

  Isolation + self-doubt = panic.

  284 views ‧ 124 reads ‧ 43.66%

  mental-health

  work

  Apr 13, 2023

  Apr 18, 2023

• Just Another Day Working At Pandemic-Era Disney World

  Face shields, layoffs and reservations for the pool.

  3,744 views ‧ 1,405 reads ‧ 37.53%

  coronavirus

  business

  work

  Mar 09, 2023

  Mar 11, 2023

• 4 BigQuery Metadata SQL Queries To Save You Time, Money & Sanity

  Never write another schema, save on storage costs and more.

  9,340 views ‧ 4,256 reads ‧ 45.57%

  software-engineering

  data-science

  programming

  Feb 27, 2023

  Mar 02, 2023

• Data Scientists: Answer 6 Questions to Summarize Your Insights In 1 Sentence

  A simplified writing technique to help you communicate complex data science problems, describe methods and share results.

  2,578 views ‧ 1,223 reads ‧ 47.44%

  data-science

  Feb 08, 2023

  Feb 08, 2023

• So, You Think A Company Misused Your Data. How To Write A DSAR.

  Learn how to audit a company for your user data, request data suppression or even request total deletion — all in one email.

  1,981 views ‧ 842 reads ‧ 42.5%

  privacy

  data-science

  cybersecurity

  programming

  Feb 03, 2023

  Feb 03, 2023

• How Not To Annoy Your Senior Data Scientists, Engineers Or Developers

  It's a senior's job to put up with you; make that an easy task.

  1,254 views ‧ 609 reads ‧ 48.56%

  software-engineering

  work

  programming

  Jan 03, 2023

  Jan 03, 2023

• Creating The Dashboard That Got Me A Data Analyst Job Offer

  A walkthrough of the Udemy dashboard that got me a job offer from one of the biggest names in academic publishing.

  194,435 views ‧ 75,460 reads ‧ 38.81%

  data-science

  Dec 05, 2022

  Jan 31, 2023

• The Crucial Voice Missing From The End of Remote Work Conversation

  And why we still might not hear from them.

  1,553 views ‧ 469 reads ‧ 30.2%

  remote-work

  work

  Dec 01, 2022

  Dec 01, 2022

• Why You Gave Up on SQL And 3 Resources to Get Out of Your Rut

  What to do when giving up on SQL is easier than learning it.

  984 views ‧ 304 reads ‧ 30.89%

  programming

  Sep 27, 2022

  Sep 27, 2022

• 5 Ways to Use Python to Boost Your SQL Operations

  Overcome SQL's limitations with these Python methods.

  8,867 views ‧ 2,724 reads ‧ 30.72%

  programming

  Sep 21, 2022

  Sep 21, 2022

• 3 Data Science Projects That Got Me 12 Interviews. And 1 That Got Me in Trouble.

  3 work samples that got my foot in the door, and 1 that almost got me tossed out.

  317,272 views ‧ 119,126 reads ‧ 37.55%

  data-science

  Aug 29, 2022

  Dec 15, 2022