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,798 views ‧ 1,752 reads ‧ 36.52%

  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,235 views ‧ 464 reads ‧ 37.57%

  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,619 views ‧ 1,370 reads ‧ 37.86%

  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,649 views ‧ 1,694 reads ‧ 46.42%

  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,539 views ‧ 2,047 reads ‧ 45.1%

  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,225 views ‧ 946 reads ‧ 42.52%

  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,712 views ‧ 1,454 reads ‧ 53.61%

  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,890 views ‧ 3,151 reads ‧ 45.73%

  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,716 views ‧ 1,336 reads ‧ 49.19%

  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,977 views ‧ 1,012 reads ‧ 51.19%

  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,733 views ‧ 1,288 reads ‧ 47.13%

  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,959 views ‧ 1,059 reads ‧ 54.06%

  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,745 views ‧ 2,950 reads ‧ 33.73%

  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,934 views ‧ 3,532 reads ‧ 50.94%

  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,309 views ‧ 1,365 reads ‧ 41.25%

  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.

  4,175 views ‧ 1,753 reads ‧ 41.99%

  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,141 views ‧ 1,241 reads ‧ 57.96%

  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.

  2,011 views ‧ 878 reads ‧ 43.66%

  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,500 views ‧ 1,221 reads ‧ 48.84%

  programming

  Jun 15, 2023

  Jun 15, 2023

• Remote Work Is Better For Everything — Except Your Anxiety

  Isolation + self-doubt = panic.

  299 views ‧ 130 reads ‧ 43.48%

  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,770 views ‧ 1,418 reads ‧ 37.61%

  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,797 views ‧ 4,394 reads ‧ 44.85%

  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,583 views ‧ 1,224 reads ‧ 47.39%

  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.

  2,007 views ‧ 843 reads ‧ 42.0%

  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,295 views ‧ 617 reads ‧ 47.64%

  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.

  200,623 views ‧ 77,368 reads ‧ 38.56%

  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,562 views ‧ 469 reads ‧ 30.03%

  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.

  991 views ‧ 305 reads ‧ 30.78%

  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.

  9,031 views ‧ 2,777 reads ‧ 30.75%

  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.

  332,540 views ‧ 124,538 reads ‧ 37.45%

  data-science

  Aug 29, 2022

  Dec 15, 2022