Accenture- 9 Interview Questions you must know | Power BI 😲

[@SameerThakur-mn5nn]

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

[@TheKumarAshwin]

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.

[@raahinakeethadath9725]

For 7th one i interpret as usage of all(). Creating measure =calculate(totalsales, all(table))

[@krishanukundu4565]

It would be really helpful if you provided the questions in the caption or in a document and dataset for the DAX question answers.

[@surabhijagadish5210]

I attended an Accenture interview two months ago and noticed four of the above-mentioned questions.

[@learnwidgiggs]

Thanks for informing!

[@rajashekharkh5829]

Hello ...have a question for u ...how could able to get the call from accenture?

[@venkatgunda7182]

One of the best youtube channel for learners and who is preparing for the interviews

[@learnwidgiggs]

Thanks for appreciating🙏

[@naveen_maddela]

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.

[@gangakhatiwada1168]

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!!

[@SSRealEstates83]

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.

[@abdulfiroz9]

For Q7 use ALL dax function, For Q9 use switch function

[@naveenshindhe2893]

Whats the use of Test column for 9th question, can you please reply..

[@mangeshdupare7797]

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.

[@learnwidgiggs]

I have already done a video on this topic titled- 'Scenario based question asked in TCS'. Plz check that out.

[@kishanbhise4733]

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

[@gyankibatein_11]

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 ?

[@learnwidgiggs]

Graduation will be required.

[@FunFactHub3]

For the 9th question, Can't we use "switch" DAX based on the category to sort ???

[@RGDataJourney]

switch is best option takes multiple arguments. if you have to pass nested if and if takes three arguments only.

[@learnwidgiggs]

Yes, you can utilize Switch function also. Here it was not working for me so I made use of If.

[@ps709]

What was the role he applied for​@@learnwidgiggs

[@Jai_Radhe_Radhe]

​@@learnwidgiggs Yeah but we should use category column instead of sales column because sales may change

[@prathameshmunj4768]

@@Jai_Radhe_Radhe he said in the video it will create circular dependency if we use same column

[@MaDmAxLoCaL]

Think before joining to accentuate, be ready for heavy work pressure.

[@nitindhamal6756]

Then only you will be an expert

[@gowardhanreddi5288]

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.

[@pratikjugantmohapatra18]

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 .

[@learnwidgiggs]

It was for 2+ yrs

[@Sonusohan2406]

Explanation good.. But screen is not clear

[@SravaniReddy-f6b]

can you create a detailed vedio! about the projects which ,I need to do ,to get job as a fresher data analyst

[@RGDataJourney]

5. Data modelling is the biggest challenge every project...

[@learnwidgiggs]

True!

[@vandanapatil1949]

Please Prepare video for 5+ years of experience in power BI

[@aditjain6580]

Thank you so much for making this very useful video sir. This video has really helped me very much.

[@learnwidgiggs]

You are most welcome!

[@VijayKumar-wv1lb]

Straight away Like without seeing video because I know your videos will be meaningful...

[@meghalohar2367]

very helpful

[@HarshithaKumar-i5f]

Sir thank you for answering all questions, was this interview for fresher or experienced professional?

[@learnwidgiggs]

Experienced.

[@prasadmekala258]

How much experience they have ?

[@shynib-uo9nq]

This interview related to freshers or experienced candiates ?

[@learnwidgiggs]

Experience

[@shubhpaulbudhe8203]

It was really helpful thank you for Sharing 🎉🎉

[@learnwidgiggs]

Glad it was helpful!

[@srinathpeddapalli2083]

you got Subscriber brother👍

[@The_Nick1999]

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

[@LaxmiChinta-q1z]

Sir, How We can perform rollback after commit smt in sql? After rollback immediately we can perform commit? In my interview asked me.

[@subbaraoballipale890]

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.

[@G-funclips4985]

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")))

[@divyaprasad9814]

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?

[@sam80166]

Can we do it in edit interaction? Highlight

[@namitaverma795]

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?

[@parthmm]

Sir how to actually get a job interview as i am mech 2021 passout with 2 years of gap what should i do sir?

[@bipulkumar1542]

Start with 3:18. Before that only advertisement

[@rishikesh445]

Thanks❤

[@Sirigineedi_Navann]

Nice one bhai 🎉

[@learnwidgiggs]

Thank you!

[@Chamanthiburusu]

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

[@sudeepmac123]

Can anyone please help me how to install power bi on macbook

[@learnwidgiggs]

There is no way..as of now..to install Power BI desktop on Mac.

[@nabeelamjad1129]

What about Pawan lalwani

[@learnwidgiggs]

No idea.

[@nabeelamjad1129]

@@learnwidgiggs sir he is a great youtuber of power bi

[@neetipandey9035]

👍👍

[@Grow-spher]

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

[@learnwidgiggs]

You can get but the competition is really increasing as a fresher. So more efforts would be required.

[@ramadevigarnepudi-xh8iu]

​@@learnwidgiggsk bro

[@019swapna8]

Hi anna any hiring in Accenture

[@learnwidgiggs]

Yeah..its going on currently

[@ashfaquesayyed9229]

@@learnwidgiggs for freshers ? any openings in any startups?

[@rashuraj8892]

​@@learnwidgiggsbro plz let us know is there any job fr freshers

[@shareknowledge951]

These are not asked in the interview.....you just copied the question as well as the solution from other youtubers LOL

[@learnwidgiggs]

Achaa😂

[@shareknowledge951]

@@learnwidgiggs actually I have also saw these type of vdos on other KZbin channels

[@learnwidgiggs]

@@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.

[@RiwayatYt]

Sir you are doing good . Don't listen to others. I appreciating your work.

[@UmaMukherjee-y4l]

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!

[@digvijaygore7203]

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 😅

[@trendzya2z558]

Frst comment

[@rambabu12345able]

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

[@learnwidgiggs]

Avg package between 9.5-14 LpA Career growth - Power BI