Real-Time Power BI Interview Questions with Answers | My Interview for CPM Consulting, Singapore |4K

Join this channel to get access to perks:
/ @biconsultingpro
Real-Time Power BI Interview Questions with Answers | My Interview for CPM Consulting, Singapore |4K
In this video, I have shared my Power BI Interview for the Consultant Position with CPM Consulting, Singapore. This interview includes all types of questions such as theoretical, practical, and scenario-based.
*****************Free Video Tutorials*************
* PL-300 Sample Questions Answers: onedrive.live.com/edit.aspx?r...
* Exam DP-203: Data Engineering on Microsoft Azure Tutorial - • DP-203: Data Engineeri...
* AZ-900 Exam Practice Papers: www.biconsultingpro.com/courses
* Power BI Interview Questions: • Power BI Interview Que...
* Power Query Tutorial: • What is Power Query? H...
* Free Power BI Admin Tutorial: • How to use Power BI ad...
* Free Azure Data Factory Tutorial: • Azure Data Factory | A...
* Free Azure Databricks Tutorial: • Data Engineering with ...
* Free Power BI Synapse Analytics Tutorial: • Microsoft Azure Synaps...
* Data Modeling Tutorial: • What is Data Modeling?...
* Azure Analysis Services Tutorial: • What is Azure Analysis...
* Power BI Service Tutorial: • What is Power BI Servi...
* Free DAX tutorial: • Complete DAX Course - ...
* Power BI Crash Course: • How to get started wit... ​
* Field Parameters in Power BI: • May 2022 Power BI Upda...
* Optimize Power BI Performance: • How to optimise Power ...
* Send an e-mail alert to anyone: • How to send an Alert E...
*********************Important Links ***********************
* PL-300 Exam Tutorial: • PL- 300 Exam Tutorial
* How to make a career in Power BI? : • How to make a career i...
* Row-Level Security in Power BI Tutorial: • RLS in Power BI
* Power Query Tutorial for the beginners: • Power Query - Basic
* For the DP-203 Exam Tutorial: • DP-203: Data Engineeri...
* Power BI Admin Tutorials Series: • Power BI Admin Tutorial
* For more DAX Videos: • DAX Sundays
* For more Weekly Videos: • Power BI Weekly Videos
* Power BI in Hindi: • पावर बीआई हिंदी में
* Power BI Free Data Sources: • Where to get free data...
* Data Modelling in Power BI: • Data Modelling
* Power BI Audit Log: • How to get Power BI Au...
* Real-Time Data Analytics using Power BI: • Real-Time Data Analyti...
**********************************Most Popular Videos on Our Channel******************************
* How to pass DA-100/PL-300 Exam: • How to pass DA-100/PL-...
* Data Classification in Power BI: • Should you go for Powe... ​
* Sensitivity Labels in Power B: • What are Sensitivity L...
* Create and manage Sensitivity Labels in Power BI: • How to create and mana...
* What is Power BI Service? • What is Power BI Service? ​
* Power BI Data Model Analysis: • How to do data analysi...
* Filter Propagation Concept: • What is Filter Propaga...
* Dynamic Page Navigation with RLS Video: • How to Navigate Pages ...
* Incremental Refresh in Power BI: • What is Incremental Re...
* Create Date Table in Power BI: • 2 Ways to Create Simpl... ​
* Deployment Pipelines in Power BI: • What are the deploymen...
* XMLA EndPoint Connectivity in Power BI: • What is Dataset connec...
* RLS Vs OLS in Power BI: • What is Object-Level S...
* Power BI Data Gateway: • What is a Power BI Dat...
* Anomaly Detection in Power BI: • Anomaly Detection In P...
* Smart Narrative Visual in Power BI: • Video
* Free Datasources for Power BI: • Where to get free data...
* Free Data Sources to Practice Power BI: • Where to get free data...
************************************************************************
☎️ LET'S CONNECT!
************************************************************************
KZbin: / @biconsultingpro
🐥 Twitter: / biconsultingpr1​
☞ Instagram: / biconsultingpro
➥ Facebook: / biconsultingpro
🧑‍💻 Website: www.biconsultingpro.com
#powerbiinterviewquestions #biconsultingpro #powerbitraining
~-~~-~~~-~~-~
Please watch: "Microsoft Azure Synapse Analytics Tutorial | Azure Synapse Studio |BI Consulting Pro |Azure Tutorial"
• Microsoft Azure Synaps...
~-~~-~~~-~~-~

[@siddharth5355]

thanks alot💯

[@j_arjunrao]

Really it is a great video. Very valuable info. Thanks bro

[@BIConsultingPro]

Glad you liked it

[@trivikramrathod9233]

Please make more videos like this

[@UdayKumar-cw3nn]

Good stuff

[@arungupta8444]

Hi Sir, if there is a set of different Excel files and there are steps applied to them, like merge, combine and group, and there is an update in one/many Excel files in terms of values and it is not possible to update each and every column value, in this case how can we replace the Excel file/files (keeping the same file name) so that the all the steps can/will be applied as it is after file replacement

[@dipakghule1338]

Please upload real time scenarios with case studies for end to end report creation

[@BIConsultingPro]

Hi, thanks for your feedback. We will surely do it.

[@j_arjunrao]

@@BIConsultingPro ❤

[@prajaktak6475]

Hello sir How to Implement RLS in DQ mode or mixed storage mode. How to answer this question in interview As per my study it cannot be implemented in DQ mode

[@BIConsultingPro]

Yes, it's a limitation with Power BI. However, there are some alternate ways to do it. I'll create a video on this topic. For the time being, please read here: radacad.com/row-level-security-on-a-directquery-to-power-bi-dataset-composite-model-my-findings

[@onkarmane7360]

Sir upload video real time senario base questions in power bi

[@BIConsultingPro]

Please check all the videos of this series. I have uploaded all.

[@user-so1qt9vn1j]

Why filters are better option than slicers though they are static?

[@BIConsultingPro]

Because of performance. Also, there are some functionality differences like advanced options in filter pane

[@mohamedmubeen2913]

Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '. I got this error while loading data, what can I do?

[@BIConsultingPro]

Please installed Power Bi Desktop version after downloading from Website NoT from App Store. Also, may I ask you to at least try find answers using google search before asking? This way, you’ll learn and you won’t need any body’s help

[@mohamedmubeen2913]

@@BIConsultingPro Thank you for helping me out

[@padduslifestyle]

Hi bro. I faced one interview quen can you please give me answer for this.. i have dept table in that i need to find dept wise 3 rd highest salary if 3 rd highest salary not there then need to print 2 nd highest salary if 2 nd also not then need to print 1 St highest salary

[@BIConsultingPro]

Hi there, You need to create a measure to solve this problem as follows: Step 1: Distinct Count = DISTINCTCOUNT('dept'[Salary]) Step 2: 3rd Highest Salary = VAR RankLimit = IF([Distinct Count] >= 3, 3, IF([Distinct Count] >= 2, 2, 1)) RETURN CALCULATE(MAX('dept'[Salary]), FILTER(ALL('dept'), 'dept'[Dept] = EARLIER('dept'[Dept]) && RANKX(ALL('dept'[Salary]), 'dept'[Salary], , DESC) = RankLimit))

[@padduslifestyle]

@@BIConsultingPro hi. In SQL I want to write query

[@padduslifestyle]

See 1 have 3 dept (it,admin, sales) in it dept 3 records are there in that i want to get 3 rd highest salary. In admin dept I have 2 records are there so here need to pick 2 nd highest salary. In sales dept I have only one record there need to get that salary (means 1st highest salary)

[@BIConsultingPro]

@@padduslifestyle you can try this: SELECT dept_name, CASE WHEN COUNT(DISTINCT salary) >= 3 THEN (SELECT MAX(salary) FROM dept d2 WHERE d1.dept_name = d2.dept_name AND salary NOT IN (SELECT MAX(salary) FROM dept d3 WHERE d1.dept_name = d3.dept_name OR d3.salary = (SELECT MAX(salary) FROM dept d4 WHERE d1.dept_name = d4.dept_name AND d3.salary = d4.salary) ) ) WHEN COUNT(DISTINCT salary) = 2 THEN (SELECT MAX(salary) FROM dept d2 WHERE d1.dept_name = d2.dept_name AND salary != (SELECT MAX(salary) FROM dept d3 WHERE d1.dept_name = d3.dept_name)) ELSE MAX(salary) END AS '3rd_Highest_Salary' FROM dept d1 GROUP BY dept_name

[@vishalsonawane.8905]

​@@padduslifestyle select * from department order by salary Desc limit 2,1;

[@anushaaprakash6119]

Hi there .. i didn't get the point ..* Ensure reports and data sources are in the same region ? ... What does it mean ..

[@BIConsultingPro]

If you have reports and data sources in the same region than there will be very low latency. For example, you are working in India but your Data Source lies in US Region, than it would take a lot of time to load report compared to if you have your data source somewhere in India. That's why we should alway try to keep Data Source and Reports in the same region. I hope this will answer your question.

[@anushaaprakash6119]

@@BIConsultingPro Thank you .. very helpful

[@kanwardeep9576]

Rate of speech is very fast in between if we wish to understand words run away... It's my opinion

[@BIConsultingPro]

May I ask you to please change the speed under KZbin video settings