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....
Layoffs
2d
39499
Google CFO confirms 'large-scale' layoffs (Apr 17)
Tech Industry
Yesterday
4876
Google doing more layoffs, restructuring including country moves
Tech Industry
Yesterday
970
So hard being a women in tech industry
Tech Industry
2d
51588
Goog Employees Arrested
Tech Industry
Yesterday
2718
Go woke, go broke: Google fires 28 employees involved in pro-Hamas protest
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.