Live Recorded Interview For Power Bi Developer [Experienced] || Mindtree-2023
Vložit
- čas přidán 1. 07. 2024
- Live Recorded Interview For Power Bi Developer [Experienced] || Mindtree-2023
------------------------------------------------------------------------------------------------------------------------------------
This video contains Interview Questions And Answers asked as part of the Mindtree Interview process
It's a real-time interview session that was faced by me and even I got selected in MindTree. so I would love to share my experience with all of you.
I hope it will be more helpful for the BI Developer both for Experienced as well as Freshers.
So basically from This video you will get to know how to prepare and clear Mindtree and the topics/areas on which you need to concentrate while attending the interview.
Thank You...
Channel Link:- / @milestonecreator2545
Please Don't Forget To Share Subscribe and Like Our Channel " Milestone Creator "
6:50 Most common DAX used? Aggregate, Time Intelligence.
9:50 : TopN, Dynamic TopN
10:42 : RankX function
11:15: Types of Relationship between Table
12:30 : How to create schemas?
12:58 : Created custom columns?
13:45 : Index Column? To make process faster
14:53 : Merge(Columnar level) vs Append(Row level) queries
16:04: Joins
17:00 : Incremental refresh, RLS, Alert messages, Exporting reports to client
17:37: Types of Context : Row, Query, Filter
In the end, Synchronization filter which wasn't answered by interviewee.
Your Last Question Ans is used the bookmarks and page navigator in actions usage.. Inside the bookmarks you toggle on your data's tab...Then you're page does not be change .... You're Answer also right deep Sir ❤️👍
12:08 we can create multiple relationships between two tables but there will be only one active relation
Suggestion to viewers:
Replace every instead of that with apart from that to make more sense, rest is fine.
WoW👏... I like the way you maintained your calmness throughout the interview and answer exactly what is being asked, i also appreciate how politely and confidently you informed if you're not sure of an answer, really good job 👍😊 .i hv enrolled for Power BI and it's been 15 days now, your interview has shared a lot of insights for me to work on. Thanks ☺️
🔥
Thank You So Much, Dear...
Is that easy to learn ???
Hi hav u got the job
A phenomenal video for any beginner. You will learn more here than the Power BI itself.
For sync slicers, select a slicer in one of your report page and start synching it accross another page is the answer
good job on the quality of this video...I know how much work it takes
last question answer is Sync slicer option so that all pages should be in sync when you select a particular value.
Exactly it is sync slicers
True
You are right. synchronisation filter.
Thanks for helping others as well as me please don't forget to share subscribe and like our channel ...
Hi sis can u guide me where I can learn this power BI
@@thenun963 you can learn your own from online there are so many online content bro
I think the answer to the last question is persistent filters in the Option and settings of Power BI so that the filters won't change. Also, sync slicers could be used so that the selections remain unchanged on all tabs with respective filter.
synchronisation filter.
Thanks for asking please don't forget to share subscribe and like our channel ...
Hi...where is the persistence filter
Sync slicer would be correct
we need to update... bookmark
Last question: Bookmarks with data unchecked can be a solution.
Thanks lot.... This vedio give me more understanding and confidence
For the last question you have to check out the data option from the bookmark option
Yeah, may Bookmark option will work for it i.e. to save the slicers, filters applied for that page. I have gone through that option after your comment. Thanks man!
synchronisation filter.
Thanks for asking please don't forget to share subscribe and like our channel ...
Thanks man this helping me in attending my upcoming interviews
You are always welcome brother.
Thanks for your valuable comment please don't forget to share subscribe and like our channel.
Hi Deep, Very Informative and well explained...last question answer is Synchronisation filters...Good Luck Dost 👍
You are right brother ...
Can any one provide proxy for power bi?
Thank u so much and Congratulations 👏👍
how do you rate a fresher with intermediate sills in PBI,SQL,EXCEL,PYTHON getting hired as a PBI dev ???????
upload more innterview videos it will be very useful for us
Pls upload somemore interview videos
Hi Deep,the last question answer should be simple copy the slicer part in every report and when you will copy same slicer in each report it will ask for sync slicer and you can click ok button.
Absolutely right .
synchronization filter is the answer for that.
Thanks for helping me a swell as other please don't forget to share subscribe and like our channel ...
@@milestonecreator2545 I need 1 help from you..
After submition of selection process form approximately how many days it will take to get the offer letter ?
Hi can you plz tell how many rounds of inteview were conducted.. is this the only round and then hr was there or before this any other round was there?
Persistent filter could be the answer of the last question.
Informational video
I think this is more of a 3-4 years experience interview questions if I am not wrong?
For senior levels, RLS, Incremental Refresh, Isinscope, Hasonevalue, AverageX,SumX should be starting questions..
However, very nicely given interview Deep. You were well poised and patient. Well done
No people are asking it
Bro, it totally depends upon the interviewer.
Bhai, I am from Odisha . Nice interview
Thank you so much sir
It's very helpful
Very genuine interview. Well bro
Sync the slicer would be the right answer in last question...
For bookmark que.. ans will be right click on bookmark you will get a data option to be checked..do unchecked and then you go
I mean for the last que..
After unchecked the data option in bookmark you have to sync the slicer on each page you will get this option in view tab.
Thank you so much I hope it will help us a lot
❤️
For last question given that we are talking about PowerBI Service, it is actually persistent filter... Reset to default button ...
The answer of the last question is while creating a bookmark please make sure to unchecked the data option of bookmark.
I guess for last question....answer should be Edit Interactions and then click the No change button so that it does not change the selection of filters already done
synchronisation filter.
Thanks for asking please don't forget to share subscribe and like our channel ...
Last question is you want to use sync slicer
Tq ❤️
Last qs answer will be to work with the interaction facility of pbi.
Live Recorded Power Bi Interview With TCS [2021] :- czcams.com/video/NTY_7Jxwvi4/video.html
bro...left outer join is left join itself....those are not 2 different join
How many technical round was there....or this is only the technical round???
Was this interview via video call or audio?
Hii, I have a 3year experience in accounts RTR but willing to change my domain. I m learning macro VBA please guide how to start learning power BI..
Last question answer is , we need to Keep Filters on in the first page..
Thanks bro , upload more videos
sure brother.
Thanks for commenting please don't forget to share subscribe and like our channel ...
Good Stuff Man
Thank you so much. Please don't forget to share subscribe and like our channel ...
For the last question, when slicers are synced this happen
Can you please share your resume if possible for reference?
what is the average salary of Power BI developer with 1-2 year experience
Hello sir,
I have 9+ experience in Reatail store concept manger..
I learned powerbi course online.. I got knowledge on it..i did some project from for self practice(Code basics & Kaggle data sets)..
But I have completed my MBA in 2010...
I don't want to go as a experienced person.. But is there any chance for me as a fresher with this huge gap...
Give me your valuable suggestion, in my case.. I'm in confusion mode...
Thanks brother
It os so easy question he was asking
'Sync slicers' for the last question answer
Nice
Thanks for this video ...
Where was the interview location ???
Pls upload more
Can you tell a salary range, how much salary you are geeting in mindtree, just give some range, not excat amount.
Do you know that dynamic top N part ?
What is average salary offered to 4 year experience
What is the answer for last question?
hello mr deep..... can you organize the answer of the question pls....???
"Tell me your last project on HR Data using Power BI....."
May i know whats your total experience and how much package you got from this
2 years of experience I have.
The salary range is between 6-7 Lacs
Thanks for asking please don't forget to share subscribe and like our channel.
How much they give to a fresher?
@@vishalmane3139 depends on the company but generally 4 to 6 lpa is possible
Sync filter is the answer for the last question.
Absolutely right. Thanks for commenting on the answer please don't forget to share subscribe and like our channel ...
I have a question..... Can a fresher get a power bi job???
Hi. I have one question about power BI. Can answer it.
How to connect cpanel live remote phpmyadmin MySQL database to power BI desktop to create live reports and dashboard ? No one is giving me correct solution. Hope you will. Waiting for your answer. Thank you
Guys, please tell me what are the shift timings of a power bi developer, I have started learning power BI and have enough experience in BPO.. I am fed up doing night shifts..
It may changes from company to company.
Anyone from mindtree here?
Mostly day shifts. Far better than BPOs.
Also having specific skills like Business Analyst will get you more salary and good work life balance and it's the future. So don't think twice just start learning
@@HoneyBunnySugarPlum thank you for answering 😊
It,s depends upon the project that they have allocated to you bro.
Thanks for asking please don't forget to share subscribe and like our channel ...
Thanks
FINISHED WATCHING
Bro, your offer letter which u posted is done by your self 😀 right. I can see ignorence words which you won't get from the mail typical format.
Anyway good work for ur efforts and thanks this useful for beginners.👍
The interviewee has good knowledge. But I am once again shocked with the interview style in India. Why does somebody needs to know about specific functions at all, why can’t they not ask about the work which the interviewee has done in this realm and what all issues he faced while he was working on the reports. How did he manage to solve the issues. And is he really keen on learning and enhancing his skills further. Same old bullshit about what’s the definition of this and where a Menu or option is. Please change this interview style and move on to a level where you gather knowledge about interviewee at a higher level.
Hi don't mind asking this question here First I will explain my situation. I am 22 years old male who is from very poor family who is fighting for better life. Now I graduated in 2021( BSC computers and stat) got opportunity in one India MNC( 1.8 lpa/year) - but What happened is I am interested in data analytics/programming, logic building kind of fields but what I get is support role( incident management) from last 6 months I am literally fighting to convinence myself to work here for financial reasons. So plzzzzzzzzzzzzzzz 🙏🙏🙏🙏🙏🙏 help I want to make a career in data analytics and ready to work hard how much it takes. Can you plz tell me whether it is possible to me to get transition from my current role and guide me how to that. Plz brother anyone I am not able to explain my current situation 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
I am having 9.6 years of experience in TCS with having 4+ years in Tableau and have done couple of POCs in MS Power BI. How much package can i get if I switch to any other MNCs as a senior Tableau/Power BI developer or Data Visualization lead
25-30 LPA
@@shortss1527 across any location in India. If I want to switch in Kolkata only
Hr will ask for your previous salary.
30 to 50 percent can be possible.
Anyone from mind tree here??
Good, instead of "instead of" you could have said "other than that, alternatively, otherwise" etc
Questions 21: drill down
Thanks for helping me as well as others brother .
Thanks for asking please don't forget to share subscribe and like our channel ...
Good Job brother...guess last answer is Sync Slicer
I hope the answer is Persisent filter ..
@@vinothganapathi5571 Yes It is given that we are talking about PowerBI Service ... Reset to default button ...
What happened to interview sir, got selected?
Hi sir , can you give a roadmap on how to get power bi jobs.i have 3 years IT experience on different technologies. But work experience is very less due to long duration of bench period. I want to switch company by learning power bi. Also, please tell what salary I can get without having power bi work experience ?
www.linkedin.com/in/deepan-kumar-patel-777591202/
Even i have the same question could please answer here I unable msg or connect you on LinkedIn just tried
I also in similar situation please reply 🙏🙏🙏🙏🙏🙏
So this kind of interview .. is by audio only no video ..so like phone interview
I have 2+ years experience in accounts payable domain,
Can I switch into power bi developer and they consider this experience ??
Yup of course you can. bcz you can be a financial analyst using power bi.
Thanks for asking please don't forget to share subscribe and like our channel.
How many years of experience do you have before joining Mindtree ?
2 Years.
Thank you so much. Please don't forget to share subscribe and like our channel ...
What will be the answer of last question? Where filter is getting set to default?
drill through filter
@@Dimplebeta i thought it might be persistent filter options
Persisent filter
@@vinothganapathi5571 hi what does it actually mean and how can we apply that filter.
@@arjun_rudra_shorts hi what does it actually mean and how can we apply that filter.
Fresher's can do that power BI course and have job for them?
a lot of opportunities are there for power bi. but if u are experienced for 1 year even it's far better.
Thanks for asking please don't forget to share subscribe and like our channel ...
Its fake, usually nobody use "sir " in interview. Its all simple questions. Just basic only. The real interview will sounds diffrent
Upload more interview videos
How much time will take to release the offer letter after filling the selection process form
Same question here can anybody help with the answer
Did u took any course??
@@divyasrinivas6029 is there any opportunity as Power BI developer .i have experience of 3.4 years.
Most important....were you selected after all? :)
Did you got job for the same interview?
Could you please let me know the package for power bi Developer in banglore. I have 2 years experience in Power bi and from Kerala. I am looking for a job change in banglore. Please reply. It would be helpful for me 😊
I think you can ask for 5lac pckg
www.linkedin.com/in/deepan-kumar-patel-777591202/
I think last question solution we will go with SYNC SLICER correct me if iam wrong..
RIGHT
Bro.. For power bi developer, do i need knowledge of ssis or any other etl tool? Or just power bi is enough to get the job? Do you perform etl also before reports? I am into manual testing and want to switch the technology
if you think learning only power bi will get you job then your wrong ,you need to atleast know basic SQL nd DAX functions, bi is just an visualisation tool we can do all tht with microsoft excel too ya know
What package did they offer?
It's drpend upon your skill set and experience . Thanks for asking please don't forget to share subscribe and like our channel 🎉
What is the package offered for this role in Mindtree?. Please let us know
6.5 L for 2 years of experience.
Thank you so much. Please don't forget to share subscribe and like our channel ...
How much pay scale for power bi with 2 years of experience
Avg 5-7.
Thanks for asking please don't forget to share subscribe and like our channel ...
@@milestonecreator2545 is there any opportunity on Power BI developer?
Can u please tell me What are the documents they are asking?
passport,aadhaar, pan,una, no form 16 , and all certificates
Thanks for asking please don't forget to share subscribe and like our channel . Have a great day ...
Bro total how many rounds of interview for experience people's
2 round . Thanks for asking please don't forget to share subscribe and like our channel 🎉
2 technical rounds ??? Or tech + managerial ???
@@desifood1895 In MNC's there are only two rounds ,1st technical for 28 min and 2nd for HR. That's it..
So have you selected in Mindtree?
Yes, Brother. and very soon I will switch to another ...
Thank you so much. Please don't forget to share subscribe and like our channel ...
In which place in Hyderabad, We get best training for PowerBi.
Iam also looking for power bi training..If you know ,please provide for me also
@@arjunreddy-dz6du Hi arjun reddy, I'm currently learning power bi course in one of the finest institution..if you are interest to learn power bi, give your contact details...I'm from guntur ap state...
I am not sure brother . any way
Thanks for asking please don't forget to share subscribe and like our channel ...
@@lenin504 can yu send your contact details plz
@@sreekanthreddykanala3832 mention ur number bro...(if you don't mine)
Is SSIS and SSAS for power BI ,has a future growth?..
No cloud is best Azure synapse, Databricks
Hi bro.... How come you face many interviews in 2021... I watch many interview vedios, all of them mentioned the name Deep,.. Are these vedios real????
Yup, it's a real one brother you can find me in Lnkdin as well ...
And All the best for your upcoming interview ...
@@milestonecreator2545 Thanks bro...