Is Power BI hard? Well, I learnt 100% of it online, via UA-cam (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.
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
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.
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 ..
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!
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.ua-cam.com/video/SmXLgEHXSGc/v-deo.html
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.
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?
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.
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?
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????
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.
Awesome 👍. Folks will save alot of time on searching correct answers on internet and can focus on practice 👏.
Exactly!!!
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!!!!
Good luck!! You are going to learn a lot !!
Is Power BI hard? Well, I learnt 100% of it online, via UA-cam (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.
Agree, it requires time and interest :)
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
Noted!
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.
Definitely!!
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 ..
Thank you! If you remember any of the questions let me know and I will do a part 2
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!
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.ua-cam.com/video/SmXLgEHXSGc/v-deo.html
On the data story question you should mention bookmarks and powerpoint integration as these are useful tools for telling data stories.
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.
If you are looking for an experienced power bi developer I agree, for other roles/levels it might not be needed/expected
Hai mam, I recently learned powerbi but I didn't understand how to approach the interviews. Mam thanks for your valuable content.
My pleasure!!
Thank you!
Really helpful video! Thank you.
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?
Start here:
m.ua-cam.com/video/V2mA40Z-R30/v-deo.html
@@CurbalEN Muchas gracias!!!!! Ready to start modeling learning 😊
Please do a video on power bi services and power apps interview questions ❤
PowerApps is not my cup of tea, but I can do it on power bi service for sure
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.
Awesome content ma’am, thanks for sharing
Useful. Thank you.
Great! Any quize/ test in future based on collection of questions?
Sure! :)
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?
Hi! It is a report Microsoft did, you can get it from them :)
U the best☀
You too ☀️
Good
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????
Ask the marketing dept for the company’s branding colors and you should be fine with that!
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.
Quick question : can we have mandatory prompts in power bi desktop?
It that I am aware of, but check in the power bi community to see if anyone has done it!
@@CurbalEN unable to find it over community
Then it is probably not possible
Ruth probably changed someone's life for the better with this video.
Imagine if you someone nailed the interview questions because of this video! That would be amazing!
no one have ever ask any one about this
Tell me, what have you been asked about?
Your answer to major components of power Bi is wrong answer .
Possibly, what is the right answer for you ?
very basics.. No use
So tell me, which questions do you want answered?
new sound system? sound is not great as always !!!
New mic!
@@CurbalEN may be it needs some tweaking ... congrats ... great video as usual ... thanks a ton
Probably 😂