What real Data Analysis is?

Hello big sirs! i have been playing with data analysis for quite a long. i made some charts, little insights from csv or excel files. sometimes end output were images(plots) or excel files with cleansed data.

I have multiple questions.

one is about workflow is it really like this

• get data from csv, excel or SQL.
• clean the data and filter noise or useless columns.
• apply rules to obtain insights.
• generate outputs.

another question is choosing right tool

• every time i used python. is it okay? like if a simple task can be done with excel why would you use R or python for it?

• for data cleaning i prefer excel and do it beforehand.

• I don't use any other tool like powerBI, tableau.

give any reason to use these tools. one would be the scale of project?

i know these steps depends on what your end goals is. there are multiple ways to achieve one thing.