𝗝𝗮𝘃𝗮 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻𝘀 𝗔𝗻𝗱 𝗔𝗻𝘀𝘄𝗲𝗿𝘀 𝗶𝗻 𝟰𝟱 𝗽𝗮𝗴𝗲𝘀✍️ 🎯

6 Tips on Interview Communication

Frequently asked SQL interview questions for Data analyst role-

1 - Order of execution of SQL query?

2 - Order of writing SQL query?

3 - All types of joins and questions on their outputs?

4 - Explain all window functions and difference between them?

5 - What is stored procedure?

6 - Difference between stored procedure & Functions in SQL?

7 - What is trigger in SQL?

8 - Difference between where and having?

Important things to focus in Excel for interview(Data Analyst) -

Lookups - (Vlookup, Xlookup, Hlookup)

Pivot table

Conditional Formatting

Formulas like - index match, Sumifs, countifs, avg, minifs, maxifs, concatenate, len, left, right, Counta, countblank... etc. with multiple sheet references

Practice Custom formula creation

Data validation

Visualization with excel (not mandatory but prefered)

Macros and How to create macros in excel?

Tips to get interview scheduled as a fresher apart from resume strengthening - : 

- Never stop applying for suitable roles.

- Make your profile strong on different job platforms like linkedin, naukri, instahyre... etc. And keep updating your profiles on these platforms on daily basis and don't stop applying.

- Directly ask to managerial level people of that company where you are applying for referral in linked in.