Accenture- 9 Interview Questions you must know

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

Рет қаралды 55,044

Күн бұрын

Codebasics Data Analyst Bootcamp Link:
codebasics.io/bootcamps/data-...
-------------------------------------
Topmate Link to book call 1:1 - topmate.io/learnwidgiggs
-------------------------------------
Link for the Scenario based QnA in Power BI: • Scenario based QnA - P...
Link for the Power Bi Interview QnA playlist :
• Power BI Interview QnA
Link for the SQL QnA playlist :
• SQL Interview QnA for ...
Link for the Data Warehousing QnA playlist :
• DW Concepts Based QnA
☀ Connect with me Here on Social Media ☀
LinkedIn : / shashank-singh-🇮🇳-ba4b...
Instagram : / learnwidgiggs
Your queries:
power bi interview questions
power bi interview questions and answers
power bi interview
power bi interview questions for experienced professionals
power bi interview questions for freshers
deloitte power bi interview questions
power bi scenario based interview questions
power bi service interview questions
scenario based power bi interview questions
power bi practice scenarios
power bi real time scenarios
shashank singh power bi
power bi scenario based questions
sql and power bi interview questions
capgemini power bi interview questions
accenture power bi interview questions
power bi managerial round interview questions
how to explain project in power bi interview
power bi roadmap
power bi jobs for freshers
power bi project explanation in interview
power bi resume for freshers
power bi fresher jobs
power bi resume
power bi developer resume
power bi resume for 2 years experience india
power bi developer resume for experienced

Пікірлер: 80

@raahinakeethadath9725 5 ай бұрын

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

@TheKumarAshwin 2 ай бұрын

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.

@venkatgunda7182 4 ай бұрын

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

@learnwidgiggs 4 ай бұрын

Thanks for appreciating🙏

@SameerThakur-mn5nn 3 ай бұрын

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

@kishanbhise4733 5 ай бұрын

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

@SSRealEstates83 5 ай бұрын

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.

@aditjain6580 5 ай бұрын

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

@learnwidgiggs 5 ай бұрын

You are most welcome!

@user-sd1hf1kj3i 5 ай бұрын

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

@surabhijagadish5210 5 ай бұрын

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

@learnwidgiggs 5 ай бұрын

Thanks for informing!

@rajashekharkh5829 5 ай бұрын

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

@gowardhanreddi5288 4 ай бұрын

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.

@rishikesh445 5 ай бұрын

Thanks❤

@naveen_maddela 4 ай бұрын

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.

@shubhpaulbudhe8203 5 ай бұрын

It was really helpful thank you for Sharing 🎉🎉

@learnwidgiggs 5 ай бұрын

Glad it was helpful!

@srinathpeddapalli2083 5 ай бұрын

you got Subscriber brother👍

@namitaverma795 5 ай бұрын

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?

@abdulfiroz9 5 ай бұрын

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

@prasadmekala258 5 ай бұрын

How much experience they have ?

@mangeshdupare7797 5 ай бұрын

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 5 ай бұрын

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

@er.manishbansal 4 ай бұрын

Veri useful video

@VijayKumar-wv1lb 5 ай бұрын

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

@G-funclips4985 5 ай бұрын

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

@pratikjugantmohapatra18 5 ай бұрын

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 5 ай бұрын

It was for 2+ yrs

@RGDataJourney 5 ай бұрын

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

@learnwidgiggs 5 ай бұрын

True!

@Sirigineedi_Navann 5 ай бұрын

Nice one bhai 🎉

@learnwidgiggs 5 ай бұрын

Thank you!

@parthmadannn 5 ай бұрын

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

@neetipandey9035 5 ай бұрын

👍👍

@user-zp6go2tz2r 5 ай бұрын

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

@learnwidgiggs 5 ай бұрын

Experienced.

@divyaprasad9814 3 ай бұрын

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?

@Ayush_2_3_1_7 5 ай бұрын

Bhaiya experience ke base par jana hai to jo maine fek banwa rakha hai as a power bi developer aap ye bata sakte ho ki during 1 year experience jo projects kiye hai vo mai kya batau Riyal time projects kese hote hai Like bignner level mai hr desbord selas deshbord hote hai par vo experience mai show to nai karsakte na riyal time projects ke topics bata do mai vese bana luga

@user-qi8ez8cn2r 5 ай бұрын

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

@subbaraoballipale890 3 ай бұрын

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.

@FunFactHub3 5 ай бұрын

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

@RGDataJourney 5 ай бұрын

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

@learnwidgiggs 5 ай бұрын

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

@ps709 5 ай бұрын

What was the role he applied for@@learnwidgiggs

@Jai_Radhe_Radhe 4 ай бұрын

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

@prathameshmunj4768 4 ай бұрын

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

@gyankibatein_11 3 ай бұрын

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 3 ай бұрын

Graduation will be required.

@sudeepmac123 5 ай бұрын

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

@learnwidgiggs 5 ай бұрын

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

@The_Nick1999 3 ай бұрын

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

@user-bg4vx2pb7n 4 ай бұрын

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

@vandanapatil1949 4 ай бұрын

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

@shynib-uo9nq Ай бұрын

This interview related to freshers or experienced candiates ?

@learnwidgiggs Ай бұрын

Experience

@MaDmAxLoCaL 5 ай бұрын

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

@nitindhamal6756 4 ай бұрын

Then only you will be an expert

@nabeelamjad1129 5 ай бұрын

What about Pawan lalwani

@learnwidgiggs 5 ай бұрын

No idea.

@nabeelamjad1129 5 ай бұрын

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

@SaRa-kj9ff 5 ай бұрын

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 5 ай бұрын

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

@ramadevigarnepudi-xh8iu 5 ай бұрын

@@learnwidgiggsk bro

@019swapna8 5 ай бұрын

Hi anna any hiring in Accenture

@learnwidgiggs 5 ай бұрын

Yeah..its going on currently

@ashfaquesayyed9229 5 ай бұрын

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

@rashuraj8892 5 ай бұрын

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

@shareknowledge951 4 ай бұрын

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

@learnwidgiggs 4 ай бұрын

Achaa😂

@shareknowledge951 4 ай бұрын

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

@learnwidgiggs 4 ай бұрын

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

@user-bz1gq6bw4t 4 ай бұрын

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

@user-fd6yy8nx8r 3 ай бұрын

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!

@trendzya2z558 5 ай бұрын

Frst comment

@digvijaygore7203 2 ай бұрын

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 😅