Power BI Interview: Live recorded Power BI interview

#achieversdataengineering #powerbi #dataanalyst #powerbideveloper #powerbiinterview #powerbitutorial
Hi,
This is a live recorded interview on Power Bi. please refer to the below timings and list of questions asked in the interview.
Please do me know in the comments if you have any questions or confusion about any question asked in the interview.
Thank you for watching!
Keep Learning!
00:00 Intro
01:40 Tableau vs Power Bi.
02:41 Which part you are good at in power Bi?
03:15 Difference between Power Bi and Premium?
04:35 What is the difference between measures and calculated columns?
06:12 Can we create slicers using measures?
06:20 Have you used the date table in the model?
06:50 What difference does it make to mark a table as a date table?
08:00 Limitations in direct query mode?
09:15 Best practices to follow while setting up a data model.
10:00 How to create a swipe effect in visuals?
11:50 Power Bi scenario based question.
15:00 What are sync slicers.
17:45 How to show a message box when there is no data to be displayed in the table visual?
21:00 Power Bi scenario based question.
22:38 Have you created views in sql.
23:40 Can we use a parameterized view or Proc in Power Bi.
24:10 Difference between where and having clauses in sql.
26:00 Group by query in Sql

[@malaydubey3584]

can you share the DAX query for where you needed sales by jan by product by agent

[@bhageshpatil8759]

Hii sir, As u asked question like for date slicer In that by using calender table date column in slicer, it filter accordingly all dates Is it true

[@AchieversDataEngineering]

Hi @Bhagesh, There are a couple of ways to handle this. For example you can use "Userelationship" DAX. Or there are ways to achieve it using edit interaction. You can this video. It will be helpful to get the answer - kzbin.info/www/bejne/bYTHmK2VaLaWaLM Thank you for watching! Keep Learning!

[@sakshinaik05]

Could you plz provide proper ans for above questions

[@AchieversDataEngineering]

Hi @Sakshi, It would be too long to provide all the answers here. Please feel free to ask if you have any specific question. Mean while I'm working on to create another video having answers of all questions asked in the interview. Thank you for watching! I'll share the link to video ASAP it is published. :)

[@bhangura3026]

Sir Can you Please Provide All Answers

[@AchieversDataEngineering]

Hi Bhangura, I have updated the description with questions asked and their timings. Thank you for watching!