This video shows a Power BI mock interview which is very close to an actual interview , It contains Questions related to Power BI Desktop , DAX , POWER QUERY , Power Bi sevice , Custom Visuals , Data flows and Power Platform.
Can you please give me a little background about yourself and the work experience you have in powerbi
What is Powerbi Desktop and Powerbi Service
What are the 3 views in POwerbi
What are the different types of filters
What is row level Security and what functions are used to implement it
How would you optimize the performance of a report in POwerbi
Can you please specify the types of relationships we have in powerbi
How can we handle many to many relationships
Can we have 2 active relationships between 2 tables , Which Dax would you use if you want to access both of the relationships
DAX
What is the difference between calendar and calendar auto ?
What is the difference between SUM and SUMX ?
What is an iterator function ?
Can you give me another example of iterator function ?
Can you mention 10 dax functions that you have used in the past ?
What is the difference between measures and Calculated column ?
What is the difference between calculate and calculate table ?
Can you please explain the purpose of cross filter ?
Powerquery
You Receive 100 different sales files with the same structure every month , How will you use them in Powerbi ?
What is the different types of data import modes in PowerBi and which mode will you use when ?
What is the difference between Append and Merge ?
What are different data sources have you connected to using POwerbi ?
What are the usual steps that you perform with your dataset to make it usuable ?
POwer Service
What is a workspace ?
What is the difference between APP and a workspace ?
Which powerbi license did you work on your project and what types of license are there ?
Can I refresh my dataset every hour with Pro license ?
Can we send an automatic email to the user in case if a particular event happens , Like if the sales for the day is greater than 5 million ?
How would you update your report every 6 hours ?
Do you need anything specific for Schedule Refresh ?
What are dataflows in Powerbi ?
What is the difference between star schema and snowflake schema
Can you mention 2 fact tables and 5 dimension tables that you have used in your project
What is the most challenging Project you have worked on
Do you have any questions for me ?
#PowerBIInterview #PowerBIInterviewquestions #Techcoach
22 май 2022
