All you need to know to become a data analyst.
SQL : SQL stands for Structured Query Language and it is used to communicate with databases. As a data analyst, you would need SQL to pull data from numerous sources so as to be able to perform your analysis. Functions such as max, min, count, average , group by, where clauses, in, not, if, loops, user defined functions, window functions, views and stored procedures are necessary for a data analyst to know. You can practice SQL here; hackerank, datalemur,w3shool
Data visualization: the act of building screens to accurately convey analysis and findings is very key in a data analyst role and knowledge of one or two data visualization tool(s) will be vey helpful in your data journey as a data analyst, business analyst or data scientist. In the space of data visualization today, the following are some if the top visualization tools you can choose from depending on personal preference, power bi, tableau, QlikView, Alteryx etc. All these are industry standard applications that can be used/are built to generate visualization. Practice visualizations here.
Python/R programming: In the world of data today, knowing one/two programming languages is a plus. Programming languages such as python and R are the leading programming languages that you can pick from and both are great, although python is more beginner friendly. One intriguing thing about programming languages is that, they can generate powerful visualization on their own just as you could do with the use a visualization tool. So in learning python or R you’ll also get exposed to the world of visualization without having to learn a specific industry standard visualization tool. Both languages have also gotten the luxury of being able to perform advanced data cleansing and wrangling which is a very crucial part of a data analyst’s job. Here are resources to help you learn/practice python or R. Learn python for free here.
Statistics and probability: starting your data analyst journey by learning statistics and probability could feel like a daunting task especially for people coming from a non STEM background. But there is no doubt that learning statistics and probability should be the first steps in transitioning into data analytics since these two areas of study will enable you to properly access, wrangle and clean datasets. In studying statistics and probability, there are certain areas that you need to grasp as a data professional and they are descriptive statistics, inferential statistics and prescriptive statistics. Statistics and probability will go a long way to helping you understand the various data types, outliers, central tendency, distributions and so on and this will help you move from one data role to another as majority of data jobs require you to know a bit of statistics and probability. You should click here to learn and apply statistics and probability here.
It is also important to note that knowing the aforementioned technical stuffs can be of great help to you when starting out as a junior in the data industry but you can not downplay the impact of the following soft skillsets for a successful data analyst career, good communication skills, interpersonal relationship and being a good team player will do you a lot of good in the data industry.