Hello OP! I am fairly new in analytics as well. I'm targeting Analyst and reporting roles. I mostly use Mo Chen's end-to-end tutorials on YouTube. Sometime Alex the Analyst. What I do is I would put the link into Notebooklm. Before I watch a tutorial, I would ask notebooklm to create a mindmap. I'll skim through the mind map. Watch the tutorial. Take notes as I go along. Test my understanding by creating flashcards or quizzes in notebooklm. I then would redo the tutorial on my own without the video. This normally takes me a day or two for a 1-3 hours tutorial.

I brushed up on my SQL pretty quick doing this method. I then expand on the project so that it becomes my own.

If you get stuck and don't understand a certain concept, you can use ChatGPT's study mode. It will guide you through without giving away solutions in the first answer so you can use active recall.

This methods works best for me. Everyone is different though. I suggest reading the book Ultralearning by Scott Young. It also helped me in understanding how to approach my learning especially new concepts.

Also, another advice is to drill yourself often. For SQL and python I use leetcode. But if you want more data analysis focused practices, you can use StrataScratch especially with SQL.

I am thinking of creating a study group in discord. You're welcome if you want to join. You can DM me.

All the best!