Accenture- 9 Interview Questions you must know | Power BI 😲
Vložit
- čas přidán 1. 07. 2024
- 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
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.
One of the best youtube channel for learners and who is preparing for the interviews
Thanks for appreciating🙏
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
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
Thank you so much for making this very useful video sir.
This video has really helped me very much.
You are most welcome!
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.
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?
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.
can you create a detailed vedio! about the projects which ,I need to do ,to get job as a fresher data analyst
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.
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?
It was really helpful thank you for Sharing 🎉🎉
Glad it was helpful!
How much experience they have ?
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")))
you got Subscriber brother👍
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.
Thanks❤
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?
Sir how to actually get a job interview as i am mech 2021 passout with 2 years of gap what should i do sir?
For Q7 use ALL dax function,
For Q9 use switch function
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
Veri useful video
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
Straight away Like without seeing video because I know your videos will be meaningful...
5. Data modelling is the biggest challenge every project...
True!
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.
Sir thank you for answering all questions, was this interview for fresher or experienced professional?
Experienced.
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.
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
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
👍👍
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.
This interview related to freshers or experienced candiates ?
Experience
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
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
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
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 CZcams 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!
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