Preparing for data analyst

I am fresher. I am preparing for the data analyst role. I stumbled upon one video on YouTube and he was saying you have to do 1.SQL 2.EXCEL 3.PYTHON 4.RCA(root cause analysis) 5.CASE STUDY 6.GUESSTIMATE

Like I have to prepare for 6 skills(data analyst)