BECOME A DATA ANALYST at 2023

What is Data Analysis ?

Data analysis helps to determine deep insights your data, forecasting in future what will you do, make helps to right decision on your business. Many company hiring data analyst role. It is not necessary but our world has variety of data so data analyst role has critical position on this companies.

What is need to be Data Analyst?

When data analyst works on data, uses SQL(Database system), Excel, maybe Python or R ( I said ‘maybe’ because sometimes companies don’t require has Python/R knowledge on Data Analyst role), Power BI or Tableau for data visualization, (I prefered Power BI. You can read my other articles about Power BI) and stats.

SQL : SQL (Structured Query Language) is language of database systems such as MSSQL,PostgreSQL,MySQL etc. Firstly, we need to choice what kind of use database systems on beginner levels. We can buy courses(Udemy,Coursera etc) or free tutorials on Youtube.

Excel : I heard from somewhere but I loved it. “Excel manage of world’s data.” If you want to be a data analyst, you need to have at least very little knowledge of Excel.We can buy courses(Udemy,Coursera etc) or free tutorials on Youtube.

Power BI : Power BI is Microsoft’s product. It provides easily visualization our data. It has easy method to use Drag-Drop. I prefer Power BI because it easy to use tool and it is supported extract data from many sources also free tool.

Python/R :I prefer Python. I haven’t used R yet. A little advice from me, if you’re just starting out on this journey, you don’t have to know Python/R right now.

What do Data Analyst do on day?

Firstly, Data analyst have to know business in sector. Someone who of data analyst shouldn’t into deep into the task. S/he must learn why did you do this? Why do we need this analysis? What is my motivations on this task ? After that S/he need to communicate with stakeholders about data or taskS/he writes notes also S/he needs to determine blockers while S/he will working data or task.

Now, we determined blockers,get information about data or task from stakeholders so we can start with data. Lets open SQL editor such as DBeaver. Check tables what you need. Check data quality. We are going into Power BI after Wrote right the SQL query

And finally, If you want to create dashboard , you can read this my article.