Live Recorded Interview For Power Bi Developer [Experienced] || Mindtree-2023

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 "

[@mohitupadhayay1439]

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.

[@mohitupadhayay1439]

A phenomenal video for any beginner. You will learn more here than the Power BI itself.

[@yogeshwaran3888]

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 ❤️👍

[@dataanalyticstrainingcente3905]

good job on the quality of this video...I know how much work it takes

[@jayabakshi4034]

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 ☺️

[@vanip5345]

🔥

[@milestonecreator2545]

Thank You So Much, Dear...

[@keerthisri4171]

Is that easy to learn ???

[@gayatridanda5169]

Hi hav u got the job

[@arulraj6776]

Thanks lot.... This vedio give me more understanding and confidence

[@kishanbhise4733]

12:08 we can create multiple relationships between two tables but there will be only one active relation

[@prashantlabde]

Suggestion to viewers: Replace every instead of that with apart from that to make more sense, rest is fine.

[@parameshpenikelapati3217]

Thank u so much and Congratulations 👏👍

[@sanketmote3393]

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.

[@milestonecreator2545]

synchronisation filter. Thanks for asking please don't forget to share subscribe and like our channel ...

[@gamen9029]

Hi...where is the persistence filter

[@ankitmaheshwari6746]

Sync slicer would be correct

[@TarunKumar-be7zj]

we need to update... bookmark

[@jvelu3058]

Thanks man this helping me in attending my upcoming interviews

[@milestonecreator2545]

You are always welcome brother. Thanks for your valuable comment please don't forget to share subscribe and like our channel.

[@deepensingh8596]

Hi Deep, Very Informative and well explained...last question answer is Synchronisation filters...Good Luck Dost 👍

[@milestonecreator2545]

You are right brother ...

[@powerbi5499]

Can any one provide proxy for power bi?

[@Mopurumanasa]

upload more innterview videos it will be very useful for us

[@dasarirajesh8819]

Pls upload somemore interview videos

[@chaitrahr9425]

For sync slicers, select a slicer in one of your report page and start synching it accross another page is the answer

[@itscmg]

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

[@shrikantlandage7305]

No people are asking it

[@milestonecreator2545]

Bro, it totally depends upon the interviewer.

[@lakshmikalyanir4510]

last question answer is Sync slicer option so that all pages should be in sync when you select a particular value.

[@sairao1240]

Exactly it is sync slicers

[@jagadishreddy5693]

True

[@milestonecreator2545]

You are right. synchronisation filter. Thanks for helping others as well as me please don't forget to share subscribe and like our channel ...

[@thenun963]

Hi sis can u guide me where I can learn this power BI

[@ashokpaul1156]

@@thenun963 you can learn your own from online there are so many online content bro

[@nisithh24]

Bhai, I am from Odisha . Nice interview

[@techhilfiger1014]

Very genuine interview. Well bro

[@deepakmaity2991]

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.

[@milestonecreator2545]

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

[@farhanaroomy591]

@@milestonecreator2545 I need 1 help from you..

[@radhekrashna2148]

Thank you so much sir It's very helpful

[@techietips]

Last question: Bookmarks with data unchecked can be a solution.

[@deeparatheesh634]

Informational video

[@hanaayele7113]

Thank you so much I hope it will help us a lot

[@veenajiyer9621]

how do you rate a fresher with intermediate sills in PBI,SQL,EXCEL,PYTHON getting hired as a PBI dev ???????

[@pranshu_tiwari]

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?

[@wandering_joshi]

For the last question you have to check out the data option from the bookmark option

[@naidupinninti7543]

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!

[@milestonecreator2545]

synchronisation filter. Thanks for asking please don't forget to share subscribe and like our channel ...

[@pvlsaikumar9655]

After submition of selection process form approximately how many days it will take to get the offer letter ?

[@dataanalystdeep3075]

Thanks for this video ...

[@HinaHimaniTales]

Persistent filter could be the answer of the last question.

[@ManiDurga]

Tq ❤️

[@balukapoorcs251]

Thanks brother

[@prasadch2279]

Thanks bro , upload more videos

[@milestonecreator2545]

sure brother. Thanks for commenting please don't forget to share subscribe and like our channel ...

[@memorysciencevidhi800]

Thanks

[@devsharma5669]

It os so easy question he was asking

[@ankitmaheshwari6746]

Sync the slicer would be the right answer in last question...

[@olutobifakeye3068]

Nice

[@krantikumar894]

❤️

[@Vinu8143]

Pls upload more

[@bhagyak2576]

Good Stuff Man

[@milestonecreator2545]

Thank you so much. Please don't forget to share subscribe and like our channel ...

[@SachinVerma-jr1qm]

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

[@SaniyaMapari]

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

[@milestonecreator2545]

synchronisation filter. Thanks for asking please don't forget to share subscribe and like our channel ...

[@sportiz8909]

The answer of the last question is while creating a bookmark please make sure to unchecked the data option of bookmark.

[@anilredddykanthala]

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

[@arpankumarbiswal8970]

bro...left outer join is left join itself....those are not 2 different join

[@vivekpuurkayastha1580]

For last question given that we are talking about PowerBI Service, it is actually persistent filter... Reset to default button ...

[@kumargarapati603]

Good Job brother...guess last answer is Sync Slicer

[@vinothganapathi5571]

I hope the answer is Persisent filter ..

[@vivekpuurkayastha1580]

​@@vinothganapathi5571 Yes It is given that we are talking about PowerBI Service ... Reset to default button ...

[@SantoshKumar-ku7po]

For the last question, when slicers are synced this happen

[@sakshinaik05]

Upload more interview videos

[@chetnabhola4056]

Do you know that dynamic top N part ?

[@devashisdas3607]

How many technical round was there....or this is only the technical round???

[@ovichowdhury2398]

hello mr deep..... can you organize the answer of the question pls....??? "Tell me your last project on HR Data using Power BI....."

[@siddarthakoka4470]

Last question is you want to use sync slicer

[@rajatdixit11]

Can you please share your resume if possible for reference?

[@pinkilihitkar8093]

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

[@pinkilihitkar8093]

I mean for the last que..

[@pinkilihitkar8093]

After unchecked the data option in bookmark you have to sync the slicer on each page you will get this option in view tab.

[@sandipansarkar9211]

FINISHED WATCHING

[@singhjirajeev]

Where was the interview location ???

[@rajatjainahmedabad]

Can you tell a salary range, how much salary you are geeting in mindtree, just give some range, not excat amount.

[@Ragusubedi]

Good, instead of "instead of" you could have said "other than that, alternatively, otherwise" etc

[@Smeetr]

Was this interview via video call or audio?

[@lalitthapa007]

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

[@jagadishreddy5693]

It may changes from company to company.

[@Naveen-iq6mx]

Anyone from mindtree here?

[@HoneyBunnySugarPlum]

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

[@lalitthapa007]

@@HoneyBunnySugarPlum thank you for answering 😊

[@milestonecreator2545]

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

[@hunny635]

what is the average salary of Power BI developer with 1-2 year experience

[@pvlsaikumar9655]

What is the answer for last question?

[@bajigunturu910]

Last question answer is , we need to Keep Filters on in the first page..

[@vijayachandrareddysingared3271]

'Sync slicers' for the last question answer

[@vasimishaq9419]

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

[@san-shi5220]

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

[@Rupali_S15]

What is average salary offered to 4 year experience

[@mademc3839]

So this kind of interview .. is by audio only no video ..so like phone interview

[@superman4237]

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

[@shortss1527]

25-30 LPA

[@superman4237]

@@shortss1527 across any location in India. If I want to switch in Kolkata only

[@premjitchowdhury262]

Hr will ask for your previous salary. 30 to 50 percent can be possible.

[@cn9699]

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

[@soumyaswarupnayak4334]

I have a question..... Can a fresher get a power bi job???

[@swarup3853]

Last qs answer will be to work with the interaction facility of pbi.

[@vaishnavtej1819]

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 ?

[@milestonecreator2545]

www.linkedin.com/in/deepan-kumar-patel-777591202/

[@sowjik6778]

Even i have the same question could please answer here I unable msg or connect you on LinkedIn just tried

[@cn9699]

I also in similar situation please reply 🙏🙏🙏🙏🙏🙏

[@shahinashaik7394]

May i know whats your total experience and how much package you got from this

[@milestonecreator2545]

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.

[@vishalmane3139]

How much they give to a fresher?

[@rajashrin5221]

@@vishalmane3139 depends on the company but generally 4 to 6 lpa is possible

[@shubhamtiwary2455]

Questions 21: drill down

[@milestonecreator2545]

Thanks for helping me as well as others brother . Thanks for asking please don't forget to share subscribe and like our channel ...

[@arjun_rudra_shorts]

What will be the answer of last question? Where filter is getting set to default?

[@mypets320]

drill through filter

[@arjun_rudra_shorts]

@@mypets320 i thought it might be persistent filter options

[@vinothganapathi5571]

Persisent filter

[@kiran4059]

@@vinothganapathi5571 hi what does it actually mean and how can we apply that filter.

[@kiran4059]

@@arjun_rudra_shorts hi what does it actually mean and how can we apply that filter.

[@krupateja9523]

What happened to interview sir, got selected?

[@bhumyinder1]

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.

[@madasulashandy6252]

I have 2+ years experience in accounts payable domain, Can I switch into power bi developer and they consider this experience ??

[@milestonecreator2545]

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.

[@Naveen-iq6mx]

Anyone from mind tree here??

[@shaiknayabrasool8462]

How much pay scale for power bi with 2 years of experience

[@milestonecreator2545]

Avg 5-7. Thanks for asking please don't forget to share subscribe and like our channel ...

[@devimanohar8113]

​@@milestonecreator2545 is there any opportunity on Power BI developer?

[@lalithprasad993]

Sync filter is the answer for the last question.

[@milestonecreator2545]

Absolutely right. Thanks for commenting on the answer please don't forget to share subscribe and like our channel ...

[@snehalnalawade9681]

Fresher's can do that power BI course and have job for them?

[@milestonecreator2545]

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

[@varshinipotteti9598]

How much time will take to release the offer letter after filling the selection process form

[@Tony-me5jk]

Same question here can anybody help with the answer

[@divyasrinivas6029]

Did u took any course??

[@devimanohar8113]

​@@divyasrinivas6029 is there any opportunity as Power BI developer .i have experience of 3.4 years.

[@mvchowdary7024]

Can b.com gen graduated get the job in power bi

[@ephraimb5644]

Its fake, usually nobody use "sir " in interview. Its all simple questions. Just basic only. The real interview will sounds diffrent

[@ashokpaul1156]

Poblem 😁

[@annaabraham4368]

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 😊

[@subhajyotibhattacharyya4807]

I think you can ask for 5lac pckg

[@milestonecreator2545]

www.linkedin.com/in/deepan-kumar-patel-777591202/

[@georgejetson9801]

You sound good. Maybe you can be phone reference for me?

[@codeaffection10]

a proxy?

[@pvlsaikumar9655]

Bro total how many rounds of interview for experience people's

[@milestonecreator2545]

2 round . Thanks for asking please don't forget to share subscribe and like our channel 🎉

[@desifood1895]

2 technical rounds ??? Or tech + managerial ???

[@vinayl910]

@@desifood1895 In MNC's there are only two rounds ,1st technical for 28 min and 2nd for HR. That's it..

[@zion96776]

Hi bro any course recommendation to learn PowerBI and tableau

[@milestonecreator2545]

You can prefer youtube 1st then go for udemy .

[@zion96776]

@@milestonecreator2545 thank you for replying. Any KZbin specific Chanel or Udemy course base on your experience.

[@divyasrinivas6029]

@@zion96776 did u purchased any course

[@zion96776]

@@divyasrinivas6029 no yet

[@rushikeshlalge7237]

What package did they offer?

[@milestonecreator2545]

It's drpend upon your skill set and experience . Thanks for asking please don't forget to share subscribe and like our channel 🎉

[@pritimore3969]

I also wants a job as a power BI developer

[@123batman1000]

Interviewee is more confident

[@travellerstail]

How many years of experience do you have before joining Mindtree ?

[@milestonecreator2545]

2 Years. Thank you so much. Please don't forget to share subscribe and like our channel ...

[@krshnydv.4599]

Can you help me to clear DA100 exam..

[@sambitsahoo6125]

Brother, I am seeking your help. I am from odisha. Also. Please help me to fix my interview.

[@Pranav-fg5jr]

Hy bro, i have also given the interview for powerbi in mindtree and got the offer for banglore location.

[@lifeofbitan]

Great! Were the questions same?

[@Pranav-fg5jr]

yes almost same, but in my interview they mainly focus on DAX functions

[@lifeofbitan]

Okay ...

[@vikrams5661]

Pranav Kumar bro how to prepare DAX please give suggestion any video link or particular website

[@Naveen-iq6mx]

@pranav want to know something from you Can I get your number?

[@sunilmotwani8982]

Mindtreeinterview

[@vjyrml]

Did you got job for the same interview?