First, the company lists the job on LinkedIn, then you can apply. Your portfolio really matters. Your shortlisting really depends on it. After you will be invited for an interview. The main questions for this job are related to Excel basic to advance concepts, Advance concepts of Tableau, or powerBI whichever tool you prefer. SQL is essential and data modeling concepts. Python is a plus if you know about fetching data from API etc