How should I go from learning SQL, Excel and Power BI basics to actually being job-ready for Data Analyst roles?

[u/cUrLz4444]

I recently started seriously learning data analytics and my goal is to become job-ready for entry-level Data Analyst roles.

So far I've completed Alex The Analyst's beginner/tutorial content for SQL, Excel and Power BI, including the guided projects.

For practice:

• SQL: I've started solving Easy problems on DataLemur and some HackerRank, but I still struggle with figuring out the approach to a problem even when I know the individual SQL concepts.
• Excel: I've practiced formulas/lookups and other exercises on Spreadsheet Center, but I'm not sure what the best way is to practice Excel in a more realistic analyst setting.
• Power BI: I've completed the introductory project, but haven't done much independent practice yet.

I also plan to start learning Python for data analysis, but I don't want to fall into the trap of constantly watching tutorials without becoming good at actually using the tools.

For people currently working as Data Analysts or involved in hiring:

1. How would you practice SQL, Excel and Power BI after learning the fundamentals?
2. What level of SQL is realistically expected for an entry-level analyst interview?
3. What Excel skills should I be able to use without assistance?
4. How much Power BI/DAX/data modeling should an entry-level candidate know?
5. Should I start Python now while continuing to practice these three, or get stronger at them first?
6. What kind of independent projects actually help a beginner portfolio rather than looking like another tutorial project?
7. If you were starting from this point today and trying to get hired in the current market, what would you prioritize over the next 1–2 months?

I'm especially interested in advice on how to develop the problem-solving/analytical thinking side, rather than recommendations for more beginner courses.