My friend is trying to find a job as data analyst. Can anybody suggest how to find a job as a data analyst and what skills are needed. I know for SDE, leetcode is the best playground to practice. Is there a similar website for data analyst?
Depends on what kind of data analyst. The ones at FAANG, SQL, know A/B test, Python (do some leetcode easy), product knowledge
How do you prepare for product knowledge?
You can only do research, try to use the products yourself if you can, and talk to people who work there to get insights about their products.
I would add data viz to that.... Power Bi, QuickSight, Tableau....
Wouldn't leetcode still be good? Practice Python doing leetcode easy + medium, and use their SQL section. The only thing leetcode wouldn't cover is Excel.
Apart from sql is there someother concepts data analysts need to prepare?
No idea, not a data analyst but worked with enough of them to know common key skills are Python (typically using libraries like pandas or matplotlib, or another language altogether like R), SQL, and Excel.