Power BI Interview questions in 2022

Here you will find the correct answers to the most common Power BI Interview questions (updated in 2022)
Chapters:
00:36 What is SSBI?
00:53 What is Power BI?
01:20 What are Power BI major components?
02:15 What is Power BI designer?
02:26 Is Power BI hard to use for a beginner?
03:07 Is Power BI available on-prem?
03:14 What are the different stages when working with Power BI?
04:06 What is Power Query?
04:25 What is Query Folding?
04:49 How do your reshape your data in Power BI?
05:19 What is the difference between Power Query and Power Pivot?
05:40 What is DAX?
05:58 What is the purpuse and benefit of using DAX?
06:33 What is bidirectional cross-filtering in Power BI?
06:58 Where is data stored in Power BI?
07:56 What are the different views in Power BI Desktop?
09:06 Power BI Limitations
11:08 What is Power BI Q&A?
11:30 What happens when you click on a single data point in one of the visuals in Power BI?
11:58 What are the main source types you can get data from?
12:10 What are content packs?
12:40 What is Power BI embed?
13:16 How can you depict a story in Power Bi?
To get the file go to curbal.com/donwload-center and on the community center, grab download #74
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
************
MY GEAR: You often ask me what software I use to edit my videos, so I thought I let you know in the description and give you a discount code so you can get it too!
COUPON: CURBAL10
Note, if you purchase the software using the link or code, I will receive a small commission and you will indirectly support my channel. Thanks in advance!
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

[@tukaramjogdand7023]

Awesome 👍. Folks will save alot of time on searching correct answers on internet and can focus on practice 👏.

[@CurbalEN]

Exactly!!!

[@joshhonken]

Really helpful video! Thank you.

[@Juan-Hdez]

Useful. Thank you.

[@Konrad-nr9ks]

Hey, great video :) Couple of those I got during some interviews. To add - couple from my side: once interviewer asked me about star schema and other types just to tell briefly + generally about relationships and how can I check/ use diagnostics in PBI

[@CurbalEN]

Noted!

[@thatdataguy3429]

Awesome content ma’am, thanks for sharing

[@robertalavezzari6970]

from today I ma going to watch alla your dax fridays to complete my self training, I feel I am ready and u are a very good teacher!!!!

[@CurbalEN]

Good luck!! You are going to learn a lot !!

[@dammyadeniji8214]

Thank you!

[@williamrhopkins]

On the data story question you should mention bookmarks and powerpoint integration as these are useful tools for telling data stories.

[@kahhengyeong7947]

Is Power BI hard? Well, I learnt 100% of it online, via KZbin (yes your channel is the major help :) ) and Google. But it needs not a genius with programming knowledge, though a strong interest in statistics and some good knowledge in Excel does help.

[@CurbalEN]

Agree, it requires time and interest :)

[@shashipaul6279]

Adding on to this, I was asked about DAX in details, like time intelligent functions, variables, implicit n explicit measures, then service part, data gathering etc .. depends on the level which candidate is applying for ... I really appreciate you for answering honestly the question about the power bi for beginners ..easy or not .. it requires time n practice ..

[@CurbalEN]

Thank you! If you remember any of the questions let me know and I will do a part 2

[@gulhermepereira249]

3:15 Ruth, I'd add as first step get a use case that brings value to the business, otherwise you could end up creating an awesome and good looking report that won't be used.

[@CurbalEN]

Definitely!!

[@oluogidan5728]

A question I was asked recently was, "What's the difference between a measure and a calculated column." It was a little tricky, but would love to hear your explanation!

[@CurbalEN]

Hi Olu, Measures are calculated only when used , calculated columns are stored in RAM forcing you to be careful about it. Here is a longer explanation: m.kzbin.info/www/bejne/iZ67fZp7fb2GfcU

[@user-vw9ui4ln9q]

Good

[@sarajvo2010]

Great! Any quize/ test in future based on collection of questions?

[@CurbalEN]

Sure! :)

[@williamrhopkins]

On the data storage questions I would give good marks to a candidate who could describe Sql Server Analysis Services and ite column oriented compression techniques and knew that PBI uses the same technology to store and query data. More marks on this point if someone knew that you can connect to this internal instance in desktop with tools like Dax studio. Even more marks for a description of import, live and direct query.

[@CurbalEN]

If you are looking for an experienced power bi developer I agree, for other roles/levels it might not be needed/expected

[@abdulbasit6951]

hi, your videos are commendable, I am confuse in components if these are the components and what we call power pivot, power view, power query etc? i have seen in many web sites people consider these as a components please share this inf with me thanks.

[@Carmen-ol7qj]

Thanks a lot for your videos, they ve been very helpful, i recently saw your video in which explains the steps to became a Power BI expert and i would like to study modeling, but im not sure what it is, ¿power pivot and modeling are the same thing?

[@CurbalEN]

Start here: m.kzbin.info/www/bejne/jGPQcmdmj5KFaZI

[@Carmen-ol7qj]

@@CurbalEN Muchas gracias!!!!! Ready to start modeling learning 😊

[@michaeljansen2602]

Hey Ruth! I hope you see this message, I am currently a trainee and love watching your videos! I am working on a task for life expectancy and saw you have a video about it too. I tried to find the file in the community downloads but its not under 65 like it said in the description. could you please possibly point me in the right direction?

[@CurbalEN]

Hi! It is a report Microsoft did, you can get it from them :)

[@siddharth5355]

U the best☀

[@CurbalEN]

You too ☀️

[@5minuteartandrangoli648]

Hai mam, I recently learned powerbi but I didn't understand how to approach the interviews. Mam thanks for your valuable content.

[@CurbalEN]

My pleasure!!

[@ravitejak9414]

Please do a video on power bi services and power apps interview questions ❤

[@CurbalEN]

PowerApps is not my cup of tea, but I can do it on power bi service for sure

[@di44ito]

Hi I'm looking for a way to combine min and sum. I have a big table.with sales amount for every day and for different products. I want to sum the amount of sales by product by date and to find the date with minimum amound sold. For example for product A for the last month i have sales every day and on 10.10.2022 i have the least amoun of sales which is 3. I want to show in a table the least amound sold by date by product for every month from the beggining of 2016 until now.

[@dinesha9152]

Mam, I have interview question in my recent one is.. Client wont give colour coding and u developed a report with default colour but the client didn't like it.... What is ur approach and what we need to decide the colour coding.... Can u please me regarding this????

[@CurbalEN]

Ask the marketing dept for the company’s branding colors and you should be fine with that!

[@GurpreetSingh-qz4no]

Quick question : can we have mandatory prompts in power bi desktop?

[@CurbalEN]

It that I am aware of, but check in the power bi community to see if anyone has done it!

[@GurpreetSingh-qz4no]

@@CurbalEN unable to find it over community

[@CurbalEN]

Then it is probably not possible

[@Phoenixspin]

Ruth probably changed someone's life for the better with this video.

[@CurbalEN]

Imagine if you someone nailed the interview questions because of this video! That would be amazing!

[@butcher6939]

no one have ever ask any one about this

[@CurbalEN]

Tell me, what have you been asked about?

[@massefromla2554]

Your answer to major components of power Bi is wrong answer .

[@CurbalEN]

Possibly, what is the right answer for you ?

[@Ahmad_Askar]

new sound system? sound is not great as always !!!

[@CurbalEN]

New mic!

[@Ahmad_Askar]

@@CurbalEN may be it needs some tweaking ... congrats ... great video as usual ... thanks a ton

[@CurbalEN]

Probably 😂

[@deepakr8794]

very basics.. No use

[@CurbalEN]

So tell me, which questions do you want answered?