What are the best free resources to learn Python and SQL for Business Analysis roles?

All answers to this question.

For a Business Analyst, I highly recommend starting with Mode Analytics for SQL; their tutorials are built into an interactive SQL editor using real data. For Python, "Automate the Boring Stuff with Python" is a classic for a reason—it focuses on practical tasks like reading spreadsheets and PDFs which is very relevant for BA work. I transitioned from Excel about two years ago, and these resources were lifesavers. Also, check out Kaggle's micro-courses. They are short, free, and get you coding in your browser immediately without needing to install complicated software environments on your laptop.

   Answered 2025-11-19 by Sharon Day

Since you are coming from an Excel background, have you tried using the "Pandas" library in Python yet? It feels very similar to Pivot Tables once you get the hang of it.

   Answered 2025-11-21 by Scott Mitchell

• Scott, I haven't tried Pandas yet, but I've heard it's the gold standard. Does it handle large CSV files better than Excel does? Because Excel always crashes on me when I exceed 100k rows. Python can handle millions of rows with ease, provided you have enough RAM. It’s the perfect logical step for any BA who has outgrown the limitations of traditional spreadsheet software.

     Commented 2025-11-24 by Larry Moreno

W3Schools is great for quick SQL syntax checks, and YouTube has amazing full-length crash courses for Python that are completely free.

   Answered 2025-11-25 by Deborah Ruiz

• I agree, Deborah. W3Schools is my go-to for a quick refresher on JOIN syntax whenever I get stuck. It's simple and straight to the point!

     Commented 2025-11-27 by Justin Gray