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 ❤️👍
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 ☺️
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.
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 ...
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!
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
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
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?
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..
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
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
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 ?
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????
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
@@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...
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.
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...
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 ...
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 😊
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 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
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.👍
Hi Bro, Does age matter moving to power bi,, i have experience in excel in BPO for 2 years, then i moved to another industry for 10 years, but kept using my excel skills..started learning power bi as well , can i switch to data analysis now
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
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.
![Live Recorded Interview For Power Bi Developer [Experienced] || TCS-2021](http://i.ytimg.com/vi/NTY_7Jxwvi4/mqdefault.jpg)
![Live Recorded Interview For Power Bi Developer [Experienced] || TCS-2021](/img/tr.png)
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.
12:08 we can create multiple relationships between two tables but there will be only one active relation
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 ❤️👍
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
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
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
A phenomenal video for any beginner. You will learn more here than the Power BI itself.
21:20 in this case we can simply use bookmark to capture the state of the page with all selected filters.
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.
upload more innterview videos it will be very useful for us
Pls upload somemore interview videos
Suggestion to viewers:
Replace every instead of that with apart from that to make more sense, rest is fine.
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..
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 ...
good job on the quality of this video...I know how much work it takes
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?
Last question: Bookmarks with data unchecked can be a solution.
how do you rate a fresher with intermediate sills in PBI,SQL,EXCEL,PYTHON getting hired as a PBI dev ???????
For sync slicers, select a slicer in one of your report page and start synching it accross another page is the answer
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.
Very genuine interview. Well bro
Thank you so much sir
It's very helpful
Informational video
Bhai, I am from Odisha . Nice interview
Thank u so much and Congratulations 👏👍
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.
Good Stuff Man
Thank you so much. Please don't forget to share subscribe and like our channel ...
Thank you so much I hope it will help us a lot
Thanks bro , upload more videos
sure brother.
Thanks for commenting please don't forget to share subscribe and like our channel ...
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 ...
Sync the slicer would be the right answer in last question...
The answer of the last question is while creating a bookmark please make sure to unchecked the data option of bookmark.
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.
It os so easy question he was asking
Thanks for this video ...
For last question given that we are talking about PowerBI Service, it is actually persistent filter... Reset to default button ...
Pls upload more
Nice
How many technical round was there....or this is only the technical round???
Tq ❤️
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 ...
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
Thanks brother
Last question is you want to use sync slicer
Can you please share your resume if possible for reference?
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 ...
Was this interview via video call or audio?
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.
FINISHED WATCHING
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.
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 🙏🙏🙏🙏🙏🙏
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 ...
bro...left outer join is left join itself....those are not 2 different join
Thanks
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..
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 ...
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...
hello mr deep..... can you organize the answer of the question pls....???
"Tell me your last project on HR Data using Power BI....."
Do you know that dynamic top N part ?
Anyone from mind tree here??
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
What happened to interview sir, got selected?
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)
For the last question, when slicers are synced this happen
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.
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.
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...
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 you tell a salary range, how much salary you are geeting in mindtree, just give some range, not excat amount.
So this kind of interview .. is by audio only no video ..so like phone interview
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 ...
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/
Hi bro any course recommendation to learn PowerBI and tableau
You can prefer youtube 1st then go for udemy .
@@milestonecreator2545 thank you for replying. Any TH-cam specific Chanel or Udemy course base on your experience.
@@zion96776 did u purchased any course
@@divyasrinivas6029 no yet
Upload more interview videos
Did you got job for the same interview?
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 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Is SSIS and SSAS for power BI ,has a future growth?..
No cloud is best Azure synapse, Databricks
'Sync slicers' for the last question answer
I have a question..... Can a fresher get a power bi job???
Last question answer is , we need to Keep Filters on in the first page..
Live Recorded Power Bi Interview With TCS [2021] :- th-cam.com/video/NTY_7Jxwvi4/w-d-xo.html
What is average salary offered to 4 year experience
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.👍
what is the average salary of Power BI developer with 1-2 year experience
❤️
Hi Bro, Does age matter moving to power bi,, i have experience in excel in BPO for 2 years, then i moved to another industry for 10 years, but kept using my excel skills..started learning power bi as well , can i switch to data analysis now
Did u purchased any course??
@@divyasrinivas6029 yes...
@@gautam-b1w wich one..can u suggest
@@gautam-b1w I want to start my career in power BI...can u suggest best course..
@@gautam-b1w hello..u purchased power BI course from lokesh lawlal right???
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 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 ...
Brother, I am seeking your help. I am from odisha. Also. Please help me to fix my interview.
1:48 starts the interview
Where was the interview location ???
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
Last qs answer will be to work with the interaction facility of pbi.
Hy bro, i have also given the interview for powerbi in mindtree and got the offer for banglore location.
Great!
Were the questions same?
yes almost same, but in my interview they mainly focus on DAX functions
Okay ...
Pranav Kumar bro how to prepare DAX please give suggestion any video link or particular website
@pranav want to know something from you
Can I get your number?
I think last question solution we will go with SYNC SLICER correct me if iam wrong..
RIGHT
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.
Can you help me to clear DA100 exam..
Can b.com gen graduated get the job in power bi