In this video we will discuss commonly asked power bi interview question and answers.
employees dataset :
emp_id emp_name dept_id salary manager_id emp_age dept_name age_group
1 Ankit 100 11000 4 39 Analytics 31-50
2 Mohit 100 16500 5 48 Analytics 31-50
3 Vikas 100 11000 4 37 Analytics 31-50
4 Rohit 100 5500 2 16 Analytics under 18
5 Mudit 200 12000 6 55 IT above 50
6 Agam 200 11000 2 14 IT under 18
7 Sanjay 200 9000 2 13 IT under 18
8 Ashish 200 5000 2 12 IT under 18
9 Mukesh 300 6000 6 51 HR above 50
10 Roshan 300 5000 5 25 HR 18-30
orders dataset : dataset link :
https://docs.google.com/spreadsheets/d/1ZZic0aQJZL-bRSKu7eNDGHOFggBugdVR/edit?gid=199463507#gid=199463507
Zero to hero(Advance) SQL Aggregation:
https://youtu.be/5Ighj_2PGV0
Most Asked Join Based Interview Question:
https://youtu.be/xR87ctOgpAE
Solving 4 Trick SQL problems:
https://youtu.be/Ck1gQrlS5pQ
Data Analyst Spotify Case Study:
https://youtu.be/-YdAIMjHZrM
Top 10 SQL interview Questions:
https://youtu.be/Iv9qBz-cyVA
Interview Question based on FULL OUTER JOIN:
https://youtu.be/KQfWd6V3IB8
Playlist to master SQL :
https://youtube.com/playlist?list=PLBTZqjSKn0IeKBQDjLmzisazhqQy4iGkb
Rank, Dense_Rank and Row_Number:
https://youtu.be/xMWEVFC4FOk
#powerbi #daxfunctions #interviewquestions