New hands‑on project resources

A new wave of project guides is giving aspiring data analysts a more concrete path from spreadsheets to code, with recent posts bundling Excel, SQL, Python, A/B testing, and data-warehouse builds into portfolio-ready exercises. (yourclouddude.gumroad.com) One of the clearest examples came from Yourclouddude, whose Python Bundle says it includes “75+ Python, SQL & automation projects,” a “structured path from beginner → advanced,” and a SQL guide built around a real-world database. (yourclouddude.gumroad.com) Another strand of the push centers on experimentation work: Coursera’s “Machine Learning with Python & Statistics” course lists hypothesis testing, probability, sampling, and model validation among its core skills, the same building blocks used in A/B testing projects. (coursera.org) A/B testing is the standard method for comparing two versions of a product or message by splitting users into groups and measuring which version performs better. Coursera’s course description says learners practice hypothesis testing and statistical inference in Python, which turns that concept into code and evaluation steps employers can inspect. (coursera.org) The SQL data-warehouse material fills a different gap: it shows how raw files become analysis-ready tables. In one March 12, 2025 tutorial, David Onwe lays out a three-layer warehouse structure — Bronze for raw ingestion, Silver for cleaned data, and Gold for business-facing tables and views. (medium.com) That architecture mirrors the kind of end-to-end work many hiring managers ask candidates to demonstrate: ingest data, clean it, model it, and present something usable. Onwe’s example uses SQL schemas, CSV loading with `BULK INSERT`, and dimensional tables for analytics rather than stopping at isolated query practice. (medium.com) The broader market for these materials is crowded, but the common pitch is consistent: employers want proof of applied work, not only course completion. Yourclouddude’s sales page says the bundle is designed for “projects you can publish on GitHub or include in your portfolio” and for explaining that work in interviews. (yourclouddude.gumroad.com) Datafrik, which describes itself as a data education platform, makes a similar portfolio argument on its training site, promising learners real-world projects, virtual internships, GitHub uploads, a portfolio website, and LinkedIn and résumé optimization. (datafrik.trainercentralsite.com) The result is a more stitched-together learning path: start with Excel or SQL for extraction and cleaning, move into Python for analysis and automation, then use statistics to test whether the result holds up. That is the same sequence these new resources are packaging into smaller, publishable projects instead of one long course with little to show at the end. (yourclouddude.gumroad.com)