9th question: in power query use if statement and give c = 1 , d= 2 , a = 3 and b =4, once this is done, come on power bi desktop and sort the category column using the test column which we created in query editor. if you create same in the Power bi desktop it will create circular dependency
Hey, thanks for the video! I have a suggestion for you: could you please mention the level at which these interview questions are typically asked? It would be really helpful.
Informative and good video. 9th answer will be useful when categories are less, but if categories are more then 100 how we can achieve??? ( we can't write if condition all the time right?) Please make this as a scenario and make a video.
I think we can create a conditional column for the last question and it is very easy to create a conditional column. It's my point of you...sorry if iam wrong.
Hi @learnwidgiggs, how to handle questions like, how frequently do you create reports/dashboards?? or how many requests you get to create reports/dashboards and what is the estimation you provide to create them? Please Answer!!
Hi bhaiya .......May we know what is the actual position with CTC for which he was applying for the job . In that way we can actualllly know what is the level of questions asked to different candidate based on experience and CTC .
We have used total sales column to create a sort column,what if the data changes in future and sales for all categories becomes 300 how will the sort column we created will handle the scenario.. Wouldnt it be better if we create a sort column using category column in power query to avoid circular dependency as well
Hi Sir. My Name is Akash Hivare. Im from Nanded, Maharashtra. I have completed 12th from Science in 2014. I have worked in multiple domains such as Health Insurance, Call Center, Digital Marketing, but my portfolio is not good when I see or because I have a lots of carreer gap. Will you pls guide me about Career ? My question is, can I learn power bi and get a job on 12th basis ?
Hey thanks for sharing, it's really amazing. Can you share answer for below question. If we have several flat files in a folder and want to fetch data from each file in power bi. No. Of file may increase with time.
hi, Recently i faced this question in interview like manager wants to see all data lead wants to see lower level data and least person wants to see their data only. i explained this scenario is it correct ? or any suggestions. ShowDataBasedOnRole = SWITCH(SELECTEDVALUE('Table (2)'[team]), "manager",[sample sum] ,"teamlead",CALCULATE([sample sum],FILTER('sample team',('sample team'[team]) "manager")) ,"member",CALCULATE([sample sum],FILTER('sample team',('sample team'[team])= "member")))
Hi brother, Im currently working in Wipro from 2 years But i'm in support project I want to switch my domain to Data analytics Will this bootcamp help me to switch to another company with no prior experience in Data analytics
Hi, interviewer ask about if I have worked on any real time project, I have created reports and dashboards in my organisation, what does working on real time project means ? Can you help?
I have also attended the Accenture interview and unable to answer below question. Can you please help: There is one bar visual and few slicers so if we change the slicers then only one bar in bar visual should change. How to achieve this?
Hi bro i am completed bachelor of degree and i am coaching in power platform tools so how to crack the interview which type of questions will be ask please tell me bro
In SQL, once a transaction is committed, it is considered final, and you cannot directly perform a rollback to undo the changes. The purpose of a commit is to make the changes permanent in the database. However, you can use a combination of features to achieve a similar effect. One approach is to use a savepoint within a transaction. A savepoint allows you to set a point within the transaction to which you can later roll back.
Hi Bro am hope u doing good..this is saikiran am completed Post graduate MBA 2017 after some doing sales job ..coming in to it side my essential skilll set sql server and Tsql and power bi can I elgible can I get a job Data analyst job as a fresher pls tell mee
@@shareknowledge951 I have been uploading interview videos for the past 2.5 yrs and I'm the one who started these type of videos..and for your information - Other youtube channels copy my content and if you would have followed the channel from the past then you would not have wrote this comment.
Hello don't tell like this Shashank is working in pwc for many years in powerbi data analytics field sql and alteryx. He has core knowledge on all these!
Without giving proper answer's of the all questions ? How can you make video on just telling the question list ? We can get question list from Google itself 😅
9th question: in power query use if statement and give c = 1 , d= 2 , a = 3 and b =4, once this is done, come on power bi desktop and sort the category column using the test column which we created in query editor. if you create same in the Power bi desktop it will create circular dependency
For 7th one i interpret as usage of all(). Creating measure =calculate(totalsales, all(table))
Hey, thanks for the video! I have a suggestion for you: could you please mention the level at which these interview questions are typically asked? It would be really helpful.
I attended an Accenture interview two months ago and noticed four of the above-mentioned questions.
Thanks for informing!
Hello ...have a question for u ...how could able to get the call from accenture?
It would be really helpful if you provided the questions in the caption or in a document and dataset for the DAX question answers.
One of the best youtube channel for learners and who is preparing for the interviews
Thanks for appreciating🙏
Informative and good video.
9th answer will be useful when categories are less, but if categories are more then 100 how we can achieve??? ( we can't write if condition all the time right?)
Please make this as a scenario and make a video.
I think we can create a conditional column for the last question and it is very easy to create a conditional column. It's my point of you...sorry if iam wrong.
Hi @learnwidgiggs, how to handle questions like, how frequently do you create reports/dashboards?? or how many requests you get to create reports/dashboards and what is the estimation you provide to create them?
Please Answer!!
Hi bhaiya .......May we know what is the actual position with CTC for which he was applying for the job . In that way we can actualllly know what is the level of questions asked to different candidate based on experience and CTC .
It was for 2+ yrs
We have used total sales column to create a sort column,what if the data changes in future and sales for all categories becomes 300 how will the sort column we created will handle the scenario..
Wouldnt it be better if we create a sort column using category column in power query to avoid circular dependency as well
For Q7 use ALL dax function,
For Q9 use switch function
Whats the use of Test column for 9th question, can you please reply..
Hi bro, In that last scenario of this video if column values are consistent then only this will work right so what if values keep changing.
Hi Sir.
My Name is Akash Hivare.
Im from Nanded, Maharashtra.
I have completed 12th from Science in 2014.
I have worked in multiple domains such as Health Insurance, Call Center, Digital Marketing, but my portfolio is not good when I see or because I have a lots of carreer gap. Will you pls guide me about Career ?
My question is, can I learn power bi and get a job on 12th basis ?
Graduation will be required.
can you create a detailed vedio! about the projects which ,I need to do ,to get job as a fresher data analyst
Hey thanks for sharing, it's really amazing.
Can you share answer for below question.
If we have several flat files in a folder and want to fetch data from each file in power bi. No. Of file may increase with time.
I have already done a video on this topic titled- 'Scenario based question asked in TCS'. Plz check that out.
Straight away Like without seeing video because I know your videos will be meaningful...
For the 9th question, Can't we use "switch" DAX based on the category to sort ???
switch is best option takes multiple arguments. if you have to pass nested if and if takes three arguments only.
Yes, you can utilize Switch function also. Here it was not working for me so I made use of If.
What was the role he applied for@@learnwidgiggs
@@learnwidgiggs
Yeah but we should use category column instead of sales column because sales may change
@@Jai_Radhe_Radhe he said in the video it will create circular dependency if we use same column
Thank you so much for making this very useful video sir.
This video has really helped me very much.
You are most welcome!
hi,
Recently i faced this question in interview like manager wants to see all data lead wants to see lower level data and least person wants to see their data only. i explained this scenario is it correct ? or any suggestions.
ShowDataBasedOnRole = SWITCH(SELECTEDVALUE('Table (2)'[team]),
"manager",[sample sum]
,"teamlead",CALCULATE([sample sum],FILTER('sample team',('sample team'[team]) "manager"))
,"member",CALCULATE([sample sum],FILTER('sample team',('sample team'[team])= "member")))
Please Prepare video for 5+ years of experience in power BI
Explanation good.. But screen is not clear
Hi brother,
Im currently working in Wipro from 2 years
But i'm in support project
I want to switch my domain to Data analytics
Will this bootcamp help me to switch to another company with no prior experience in Data analytics
Sir thank you for answering all questions, was this interview for fresher or experienced professional?
Experienced.
Sir how to actually get a job interview as i am mech 2021 passout with 2 years of gap what should i do sir?
It was really helpful thank you for Sharing 🎉🎉
Glad it was helpful!
Hi, interviewer ask about if I have worked on any real time project, I have created reports and dashboards in my organisation, what does working on real time project means ? Can you help?
I have also attended the Accenture interview and unable to answer below question. Can you please help:
There is one bar visual and few slicers so if we change the slicers then only one bar in bar visual should change.
How to achieve this?
Can we do it in edit interaction? Highlight
Hi bro i am completed bachelor of degree and i am coaching in power platform tools so how to crack the interview which type of questions will be ask please tell me bro
Think before joining to accentuate, be ready for heavy work pressure.
Then only you will be an expert
5. Data modelling is the biggest challenge every project...
True!
This interview related to freshers or experienced candiates ?
Experience
How much experience they have ?
Sir, How We can perform rollback after commit smt in sql?
After rollback immediately we can perform commit?
In my interview asked me.
In SQL, once a transaction is committed, it is considered final, and you cannot directly perform a rollback to undo the changes. The purpose of a commit is to make the changes permanent in the database. However, you can use a combination of features to achieve a similar effect.
One approach is to use a savepoint within a transaction. A savepoint allows you to set a point within the transaction to which you can later roll back.
very helpful
you got Subscriber brother👍
Can anyone please help me how to install power bi on macbook
There is no way..as of now..to install Power BI desktop on Mac.
Hi Bro am hope u doing good..this is saikiran am completed Post graduate MBA 2017 after some doing sales job ..coming in to it side my essential skilll set sql server and Tsql and power bi can I elgible can I get a job Data analyst job as a fresher pls tell mee
You can get but the competition is really increasing as a fresher. So more efforts would be required.
@@learnwidgiggsk bro
Nice one bhai 🎉
Thank you!
What about Pawan lalwani
No idea.
@@learnwidgiggs sir he is a great youtuber of power bi
Thanks❤
Start with 3:18. Before that only advertisement
These are not asked in the interview.....you just copied the question as well as the solution from other youtubers LOL
Achaa😂
@@learnwidgiggs actually I have also saw these type of vdos on other TH-cam channels
@@shareknowledge951 I have been uploading interview videos for the past 2.5 yrs and I'm the one who started these type of videos..and for your information - Other youtube channels copy my content and if you would have followed the channel from the past then you would not have wrote this comment.
Sir you are doing good . Don't listen to others. I appreciating your work.
Hello don't tell like this Shashank is working in pwc for many years in powerbi data analytics field sql and alteryx. He has core knowledge on all these!
Hi anna any hiring in Accenture
Yeah..its going on currently
@@learnwidgiggs for freshers ? any openings in any startups?
@@learnwidgiggsbro plz let us know is there any job fr freshers
👍👍
Without giving proper answer's of the all questions ? How can you make video on just telling the question list ?
We can get question list from Google itself 😅
Frst comment
hi brother... with 4 years of Exp how much package can we expect? tableau and power BI which is most career growth job? plz suggest
Avg package between 9.5-14 LpA
Career growth - Power BI