Almost all data analysts and data scientists interviews involved in SQL!!!!
. check 1point3acres for more.
All companies test JOINs, group by!!!!
..
1a: This is more like a SQL syntax lookup page, but it’s tutorial is quite helpful for beginners. All companies test JOINs, group by!!!!
I highly recommend to practice all the SQL questions on leetcode (30ish questions-take about 5-15 hours each round) at least twice. Those are very common interview questions such as self join, ranking, subqueries, etc. . .и
. 1point 3acres
1d: Hacker rank SQL questions are quite good https://www.hackerrank.com/
Leetcode’s twin. If your company tests live coding questions here, be sure to familiarize yourself with the hacker rank platforms. There are a lot of SQL questions here to practice.
. From 1point 3acres bbs
2. A/B testing
If the company is a social media firm or a firm with front end products, AB test can be used by their team A LOT.
This is the best A/B test course ever. Please budget a month for the course
3. Machine Learning (ML):
.
Not all data scientist jobs require deep knowledge in machine learning. Usually machine learning engineer might require deep knowledge in ML, but it all depends on the company you joined. My experience is that most jobs only required basic knowledge of some machine learning algos you listed on your resume, or basic ones like k-mean clustering, logistic regression, linear regression, PCA, random forests, supervised vs non-supervised machine learning.
A lot of people recommended this ML course. i find that the course goes very deep into the principals of neural networks, but it doesn't really help most of my interviews.
Also, companies usually test how to build a machine learning model orally or by doing a take home project. Machine learning is the easy part. Data cleaning, feature engineering, and data sampling are usually the difficult parts. In the feature engineering part, companies often time want you to be able to come out some unique features or features that have business contexts. Also for the machine learning results, AUC under the ROC curve, F1 score, precision and recall are very often asked, actually way more often than the ML algos listed above.
4. Python/ R:
Python has more advantages in connecting with software engineering projects , APIs, plus it can do a lot of data science/ ML projects. So it has been favored by a lot of tech companies especially in the US west coast. R is more used in academic and some financial/ biotech companies in the East coast where more advanced/ rare statistic methods are required. Both python (a library called 'pandas') and R have the concept of data frame, which is crucial for data processing. That is important to learn.
.1point3acresAlso, it is good to pick up Python from any of the online courses and then learning by doing small (data science) projects. By doing a project, you will learn the following key parts of python in data processing:
Basic concept: functions, libraries, data type transformation, object oriented.
Python packages: scikit learn (for ML), pandas, jupyter notebook, numpy, scipy, dependency/library controls such as miniconda etc. . 1point 3 acres
version control: github
also i highly recommend to use (free version of) pycharm for python code development. For data science projects, a lot of people use juypter notebook to share graphs.
. .и
5. Take home challenges:
the world of data science is way too broad. The following keywords are good to have and good to know, depending on which companies/ which teams you are going to work with. They are good to have especially if you are in the mid career , but not must have if you are a new grad.
. 1point 3 acres
Software engineering: CI/CD, QA (unit test, integration test), amazon web service (S3 bucket, EC2 instance, etc.), configuration management, API. From 1point 3acres bbs
Data engineering: data warehouse, ETL, NoSQL, Spark, scala, graph database .
Machine learning: tensorflow, pytorch, amazon flink
..
Front end: javascript, react
.--
7. 地里有一些好帖子也可以获得很多宝贵的资讯:
. .и
【最终版回报社会贴】new grads湾区DA/DS找工作超细致回顾+面经+资料总结!!!https://www.1point3acres.com/bbs/thread-469408-1-1.html