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,425 views ‧ 1,639 reads ‧ 37.04%

  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,223 views ‧ 463 reads ‧ 37.86%

  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,487 views ‧ 1,340 reads ‧ 38.43%

  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,480 views ‧ 1,660 reads ‧ 47.7%

  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,483 views ‧ 2,028 reads ‧ 45.24%

  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,137 views ‧ 922 reads ‧ 43.14%

  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,666 views ‧ 1,447 reads ‧ 54.28%

  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,596 views ‧ 3,105 reads ‧ 47.07%

  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,667 views ‧ 1,321 reads ‧ 49.53%

  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,940 views ‧ 997 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,694 views ‧ 1,281 reads ‧ 47.55%

  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,949 views ‧ 1,058 reads ‧ 54.28%

  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,413 views ‧ 2,851 reads ‧ 33.89%

  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,795 views ‧ 3,488 reads ‧ 51.33%

  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,247 views ‧ 1,360 reads ‧ 41.88%

  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,971 views ‧ 1,696 reads ‧ 42.71%

  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,128 views ‧ 1,238 reads ‧ 58.18%

  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,000 views ‧ 877 reads ‧ 43.85%

  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,491 views ‧ 1,218 reads ‧ 48.9%

  programming

  Jun 15, 2023

  Jun 15, 2023

• Remote Work Is Better For Everything — Except Your Anxiety

  Isolation + self-doubt = panic.

  288 views ‧ 125 reads ‧ 43.4%

  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,747 views ‧ 1,406 reads ‧ 37.52%

  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,483 views ‧ 4,309 reads ‧ 45.44%

  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,579 views ‧ 1,224 reads ‧ 47.46%

  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,984 views ‧ 842 reads ‧ 42.44%

  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.

  196,963 views ‧ 76,403 reads ‧ 38.79%

  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,554 views ‧ 469 reads ‧ 30.18%

  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.

  985 views ‧ 305 reads ‧ 30.96%

  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,906 views ‧ 2,742 reads ‧ 30.79%

  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.

  320,046 views ‧ 120,273 reads ‧ 37.58%

  data-science

  Aug 29, 2022

  Dec 15, 2022