Microsoft PowerBI Interview | Power BI Interview Questions | Power BI Mock Interview
Vložit
- čas přidán 22. 05. 2022
- 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
It's really very helpful, you all most covered all questions
I will surely practice and hopefully I will also select soon
I am glad I could help . All the very best :)
@@TechCoach 🙏
First 2 minutes into video 👌...Humble request to create more advance level videos, although I haven't looked at all your videos...which I will....
Your guest clearly explains and the quality of content is amazing.
Thank you
Great content...loved it!! Thank you so much!!
Honestly Very informative , thankyou !
Please make another mock interviews for latest questions like custom visuals,Q&A,more dax questions and some scenario based questions along with sql, Python, excel and statistical analysis
Please please please make
I really needed guided videos like this to prepare well.
I am preparing now interviews for data analyst and power bi developer
superb content, very clear on all the concepts. thanks
Looking forward more bi interview series
Sure Sakshi, I will upload more videos soon :)
very good interview
Thank you
Thanks a lot Surabhi
Can you sir please make more video on informatica .
Waiting for a video on interview preparation, how to explain real time project from scratch.
Please make video on oracle more .
Looking up for more dax scenarios,
Thank u
Sure shailendra will upload it soon
Nice
@@TechCoach nice
SHAILENDAR DID YOU GOT A JOUB ON POWER BI
Almost all same questions I faced In my interview
Could you please make python videos
Sure , will work on it soon
Sir where are you 😢😢 ?
Now why you stop posting videos on SQL and Informatica . I switching my career and i found your video it really helping me since first day . But now you don't making video . ? Please reply if you have any issues so that i could know .
Hello buddy thanks for the concern I am doing good I wish you all the very best for your career
@@TechCoach happy to hear from you sir . Can you please make more video on real time project work in SQL .
I really waiting for more informatica video by you real time project, incremental loading like all those important in real time project .
Just a correction, Its Use relationship function, not User
the function is USERELATIONSHIP, not USERRELATIONSHIP
Thats correct Boris, it's userelationship.
What is the diff betn content and app in bi?
Drill down not drillthrough
Drill Through Answer is wrong
She gives drill down answer instead of drill through
right