Affine Interview Experience | Business Analyst Interview Questions & Answer| 3-6 Years

1. No of output from joins - By ‪@techTFQ‬
• SQL JOINS Interview Qu...
2. Assign Rank, Dense Rank, row Number to values - By ‪@ankitbansal6‬
• RANK, DENSE_RANK, ROW_...
3. Find Employees who is working more than a year in company
stackoverflow....
4. find second highest salary - By ‪@crackconcepts‬
• How to find second hig...
5. Find Duplicate records in SQL
learnsql.com/b...
6. Find customers who ordered 2 consective days
stackoverflow....
7. Find Oldest employee per department
stackoverflow....
Tableau Scenario based questions series: -
• Tableau Scenario Based...
Tableau interview question series: -
• Tableau Interview Ques...
Tableau Advance Course:
• Tableau Advance Course
Tableau Crash Course: - Beginners-
• Tableau Crash Course -...
If you like the video, please do Like, share & subscribe.
#allaboutdata #tableau #businessintelligence #tableaututorial #tableaututorial #tableautips #bideveloper #tableaucertification #tableaudesktopCertification #certified #certification #tableaucertificate
#datascience #tableauclasses #tableauvisualization #tableaufullcourse
#interviewexperience #deloitte #consultant

[@yashshrivastava280]

dude you are doing better best wishes

[@AllAboutDATA100]

Thank you so much for your wishes 🙏

[@AltafAlandwale]

Also for relationship vs blending- we can also that blending works on worksheet level while relationship can be worked at a data source level. Isn't it?

[@AllAboutDATA100]

You are right 👍

[@yashshrivastava280]

did they ask you to from the table for excel or just simply checking theory knowledge?

[@AllAboutDATA100]

They ask you to share your screen and create tables in excel and solve the problem

[@yashshrivastava280]

@@AllAboutDATA100 I hope could have seen that day now I have been rejected haha they did not even ask a single question from tableau!

[@AllAboutDATA100]

Sorry to hear that brother. Best wishes to you for other opportunities 🙏

[@_es284]

@@yashshrivastava280 What did they ask you then ? I mean related to SQL and PowerBi I have interview today 1st round

[@_es284]

Bro I tried reaching you out on Linkedin But too many Yash Shrivastava

[@ashutoshsharma7119]

Round 1, SQL Question 6:-
These type of solutions generally have two approaches:-
1. Using Lead/Lag Analytical Functions
2. Using Self Join with conditions

[@AllAboutDATA100]

Good to see that you know multiple approaches to solve these problems

[@AltafAlandwale]

Bro, how are you getting all the job calls and we are not getting them?
Can you please help us with that? I really appreciate any help you can provide.

[@AllAboutDATA100]

Hi Altaf, i gave interviews 4 months back and i got most of the calls when i was on my notice period.
I always say in my video to ask for a referral and create a resume accordingly.
Now the job openings are less and candidates are more but if your resume is the best fit, most probably you will get a call

[@_es284]

Hi Kapil, I have an interview tomorrow with Affine(1st round) for Sr. Business Analyst But required skills are SQL and PowerBI. What should I prepare for PowerBI

[@AllAboutDATA100]

Hi, all the best your interviews.
You can expect 4-6 SQL questions. You can check the video for reference. You need to share your screen and solve it.
For Power Bi, stick with your fundamentals and you can expect some questions like how to handle large data and some other fundamental questions as well as some functions of power bi. Best wishes

[@_es284]

@@AllAboutDATA100 Thankyou so much

[@_es284]

@@AllAboutDATA100 interview is done they asked me 1. second highest salary based on department 2. What is the date on second Monday of current month and 3. Each character of your name in single line
power bi related theory questions were there

[@AllAboutDATA100]

I hope you have answered all the questions. 😁

[@_es284]

@@AllAboutDATA100 powerbi I couldn’t sql I did all

[@Ankit-rv2my]

Hello bhai in one of the interviews for fresher I was asked what dashboard versioning in tableau is? can you tell me what exactly it is, I searched on google but not found.

[@AllAboutDATA100]

Hi Ankit, Latest version of tableau is 2024.1 and also you can check all versions here www.tableau.com/support/releases

[@Ankit-rv2my]

@@AllAboutDATA100 Thanks bhai

[@vuttiprasad389]

Hi Kapil Sharma , while explaining anything Could you Please explain in English

[@AllAboutDATA100]

Hi, i will take care in future

[@Rkbullet_2000]

Bhai face to face huaa tha ya koi link aaya tha

[@AllAboutDATA100]

Online hua tha bhai

[@ShaikJaheer-yh3bs]

Hii, can you share the job posting

[@AllAboutDATA100]

Hi, sure i will update on youtube very soon