For Excel, I would expect you to be quite proficient. You should know how to do v/hlookups and arrays well. There shouldn't be be anything that you can't do or couldn't find the answer to and do in Excel. SQL you should know all the basic functions from sub queries to joins. PowerBI you should know how to create a dashboard, be able to connect most data sources and have some basic knowledge of DAX.
Assalamu Alaikum Brother, I'm currently working as a Team Lead on Daraz & have 5+ years of experience in customer service & supply chain looking forward to land a role as a remote data analyst. I have completed a data analyst BootCamp & looking forward PL-300 certification to get an advantage to be a data analyst. Can you provide me a suggestion on this? Should I stick on this plan or do I need to restructure my plan?
Walay kum as Salaam Make you learn the basics, Excel, SQL and some visualisation, which it seems you are doing with PowerBI. Next you need a portfolio and some real world experience Check out this video th-cam.com/video/EDzA-MKkHCU/w-d-xo.html
That's good video to prepare ypourslef for a interview.
Thank you
@@Shorful Can you tell me how much we should learn Excel,SQL and Power for data analyst job.Because your have solid experience in these tools.
For Excel, I would expect you to be quite proficient. You should know how to do v/hlookups and arrays well. There shouldn't be be anything that you can't do or couldn't find the answer to and do in Excel.
SQL you should know all the basic functions from sub queries to joins.
PowerBI you should know how to create a dashboard, be able to connect most data sources and have some basic knowledge of DAX.
Can you tell me how we make a resume which help to land a data analyst job.
I actually have a video planned for this, just not had a chance to film it.
@@Shorful Your content about data is awesome.
@DanishAli-it3lv thank you
Assalamu Alaikum Brother,
I'm currently working as a Team Lead on Daraz & have 5+ years of experience in customer service & supply chain looking forward to land a role as a remote data analyst. I have completed a data analyst BootCamp & looking forward PL-300 certification to get an advantage to be a data analyst.
Can you provide me a suggestion on this? Should I stick on this plan or do I need to restructure my plan?
Walay kum as Salaam
Make you learn the basics, Excel, SQL and some visualisation, which it seems you are doing with PowerBI.
Next you need a portfolio and some real world experience
Check out this video
th-cam.com/video/EDzA-MKkHCU/w-d-xo.html