Totally feel you on this. It's rough out there when every job listing wants 3+ years of experience with tools you've only touched in a course. What worked for me was basically turning my day job into a data playground.
In paid social, you've got a goldmine of performance data - CTRs, ROAS, frequency, all that. Started tracking my own campaign metrics manually, cleaning up export messes in Sheets, building little dashboards for fun. Showed my manager and asked what KPIs they actually cared about. Half the time they didn't even know what was possible, so you end up defining the metrics yourself.
If your company has a data warehouse and offers BI tool licenses, grab that. Even if it's just non-sensitive audience data or revenue numbers. Chat up the analytics team - most of them love talking shop if you come with genuine curiosity. Offered to take some of their grunt work off their hands for real experience.
Courses? Meh. Projects and real-world stuff always wins. Use AI like a tutor - ask it to explain concepts, then go dig into the actual logic. Don't let it do the thinking for you.
Fundamentals matter more than ever. Too many people jump straight into automation without understanding why a join works or how aggregation affects numbers. Be the person who nails the basics and builds up from there. You'll stand out.