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!!
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 ?
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 .
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 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?
Hey Hi. I am switching to data Analyst job. I am a fresher for this sector. Please help in providing the important topics and questions which I can face as a fresher.
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
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, 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, 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?
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
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
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.
For 7th one i interpret as usage of all(). Creating measure =calculate(totalsales, all(table))
One of the best youtube channel for learners and who is preparing for the interviews
Thanks for appreciating🙏
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?
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.
Great Video as Always
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.
It would be really helpful if you provided the questions in the caption or in a document and dataset for the DAX question answers.
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!!
sir in 1st question why we made another variables to optimize that query can we also use calculate and sum function to optimize
Thank you so much for making this very useful video sir.
This video has really helped me very much.
You are most welcome!
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
We can use switch in 9 th question know
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.
Whats the use of Test column for 9th question, can you please reply..
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
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.
For Q7 use ALL dax function,
For Q9 use switch function
Hey, I think the 1st question answer is wrong
The right answer should be like
Var Mult = a*b*d
Var div = c
Return Divide ( Mult, div)
very helpful
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.
It was really helpful thank you for Sharing 🎉🎉
Glad it was helpful!
you got Subscriber brother👍
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
This interview related to freshers or experienced candiates ?
Experience
Sir thank you for answering all questions, was this interview for fresher or experienced professional?
Experienced.
Straight away Like without seeing video because I know your videos will be meaningful...
How much experience they have ?
Please Prepare video for 5+ years of experience in power BI
Think before joining to accentuate, be ready for heavy work pressure.
Then only you will be an expert
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
Hey Hi. I am switching to data Analyst job. I am a fresher for this sector. Please help in providing the important topics and questions which I can face as a fresher.
Thanks❤
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
Nice one bhai 🎉
Thank you!
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.
Explanation good.. But screen is not clear
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,
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, 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?
Sir how to actually get a job interview as i am mech 2021 passout with 2 years of gap what should i do sir?
Start with 3:18. Before that only advertisement
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
5. Data modelling is the biggest challenge every project...
True!
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
What about Pawan lalwani
No idea.
@@learnwidgiggs sir he is a great youtuber of power bi
👍👍
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