Real-Time Power BI Interview Questions with Answers | My Interview for CPM Consulting, Singapore |4K
Вставка
- Опубліковано 11 вер 2024
- 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....
* 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!
************************************************************************
UA-cam: / @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...
~-~~-~~~-~~-~
Please upload real time scenarios with case studies for end to end report creation
Hi, thanks for your feedback. We will surely do it.
@@BIConsultingPro ❤
Please make more videos like this
thanks alot💯
Really it is a great video. Very valuable info. Thanks bro
Glad you liked it
Good stuff
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
Sir upload video real time senario base questions in power bi
Please check all the videos of this series. I have uploaded all.
Rate of speech is very fast in between if we wish to understand words run away... It's my opinion
May I ask you to please change the speed under UA-cam video settings
Hi there .. i didn't get the point ..* Ensure reports and data sources are in the same region ? ... What does it mean ..
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.
@@BIConsultingPro Thank you .. very helpful
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
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))
@@BIConsultingPro hi. In SQL I want to write query
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)
@@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
@@padduslifestyle select * from department order by salary Desc limit 2,1;
Why filters are better option than slicers though they are static?
Because of performance. Also, there are some functionality differences like advanced options in filter pane
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
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
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?
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
@@BIConsultingPro Thank you for helping me out