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.
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 ☺️
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 ❤️👍
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 ...
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
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!
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?
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. 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
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????
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.
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
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...
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 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
@@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...
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
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 😊
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 ...
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
@@milestonecreator2545 BUT MY QUESTION is say: if we have a excel sheet , where top mgmnt is using it as a decision making tool, a report, now, they wanna migrate it to P BI. now, inside this excel report, there are several calculations included , which has sum of many cells, and some cells values are populating from another DB -oracle or csv file or another xlsx file -,. now looking at this scenario, how can i generate a P BI report. where where i need to use measures, etc . this is the question
Sir even I want to become a data analyst and I have completed my post graduation in Msc computer science and I have knowledge of MySQL, Excel,Stats, Python. Sir plz tell us how to search job for data analyst,where to apply.make a vdo on this if possible
Then what does exprinced person use.... And what's wrong by calling sir... Is there any rules or rights in the labour law or company policy.... ఎక్కడా నుంచి వస్తారు రా బాబు మీరంతా.... కోడి చూడండి రా అంటే కోడి గుద్దలో fingers పెట్టీ గుడ్డు ఉంద అని చూస్తారు కదా రా ....
![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.
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
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
12:08 we can create multiple relationships between two tables but there will be only one active relation
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
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..
Suggestion to viewers:
Replace every instead of that with apart from that to make more sense, rest is fine.
how do you rate a fresher with intermediate sills in PBI,SQL,EXCEL,PYTHON getting hired as a PBI dev ???????
21:20 in this case we can simply use bookmark to capture the state of the page with all selected filters.
Last question: Bookmarks with data unchecked can be a solution.
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.
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 ...
A phenomenal video for any beginner. You will learn more here than the Power BI itself.
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 ...
For sync slicers, select a slicer in one of your report page and start synching it accross another page is the answer
The answer of the last question is while creating a bookmark please make sure to unchecked the data option of bookmark.
upload more innterview videos it will be very useful for us
Pls upload somemore interview videos
Sync the slicer would be the right answer in last question...
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?
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.
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.
good job on the quality of this video...I know how much work it takes
For the last question, when slicers are synced this happen
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?
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. 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
Thanks lot.... This vedio give me more understanding and confidence
Last question is you want to use sync slicer
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 ...
For last question given that we are talking about PowerBI Service, it is actually persistent filter... Reset to default button ...
How many technical round was there....or this is only the technical round???
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 🙏🙏🙏🙏🙏🙏
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
bro...left outer join is left join itself....those are not 2 different join
Persistent filter could be the answer of the last question.
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...
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.
Can you please share your resume if possible for reference?
Thank you so much sir
It's very helpful
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..
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.
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 ...
'Sync slicers' for the last question answer
hello mr deep..... can you organize the answer of the question pls....???
"Tell me your last project on HR Data using Power BI....."
Last question answer is , we need to Keep Filters on in the first page..
Was this interview via video call or audio?
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...
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.
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 ...
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 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Can you tell a salary range, how much salary you are geeting in mindtree, just give some range, not excat amount.
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)
Its fake, usually nobody use "sir " in interview. Its all simple questions. Just basic only. The real interview will sounds diffrent
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.
Do you know that dynamic top N part ?
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
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/
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 ...
I have a question..... Can a fresher get a power bi job???
What happened to interview sir, got selected?
What is average salary offered to 4 year experience
So this kind of interview .. is by audio only no video ..so like phone interview
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?
what is the average salary of Power BI developer with 1-2 year experience
Bhai, I am from Odisha . Nice interview
I think last question solution we will go with SYNC SLICER correct me if iam wrong..
RIGHT
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.👍
Is SSIS and SSAS for power BI ,has a future growth?..
No cloud is best Azure synapse, Databricks
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 ...
Thank u so much and Congratulations 👏👍
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 🎉
Very genuine interview. Well bro
Did you got job for the same interview?
Informational video
Thank you so much I hope it will help us a lot
Brother, I am seeking your help. I am from odisha. Also. Please help me to fix my interview.
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 UA-cam specific Chanel or Udemy course base on your experience.
@@zion96776 did u purchased any course
@@divyasrinivas6029 no yet
It os so easy question he was asking
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...
@@VisionAstrology1985 wich one..can u suggest
@@VisionAstrology1985 I want to start my career in power BI...can u suggest best course..
@@VisionAstrology1985 hello..u purchased power BI course from lokesh lawlal right???
Good, instead of "instead of" you could have said "other than that, alternatively, otherwise" etc
Where was the interview location ???
Anyone from mind tree here??
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 ...
Last qs answer will be to work with the interaction facility of pbi.
FINISHED WATCHING
Most important....were you selected after all? :)
Hi could you share power bi content from where i can learn for the interview
ua-cam.com/video/NTY_7Jxwvi4/v-deo.html
is that a easy tool? this POWER BI ? can any experts pls clarify
Yea It's easy bt cracking interview it's little bit difficult
easy one .
Thanks for asking please don't forget to share subscribe and like our channel ...
@@milestonecreator2545 BUT MY QUESTION is say: if we have a excel sheet , where top mgmnt is using it as a decision making tool, a report, now, they wanna migrate it to P BI. now, inside this excel report, there are several calculations included , which has sum of many cells, and some cells values are populating from another DB -oracle or csv file or another xlsx file -,. now looking at this scenario, how can i generate a P BI report. where where i need to use measures, etc . this is the question
Thanks bro , upload more videos
sure brother.
Thanks for commenting please don't forget to share subscribe and like our channel ...
Thanks
Good Stuff Man
Thank you so much. Please don't forget to share subscribe and like our channel ...
Can you help me to clear DA100 exam..
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 ...
Upload more interview videos
can you share your resume?
Sir even I want to become a data analyst and I have completed my post graduation in Msc computer science and I have knowledge of MySQL, Excel,Stats, Python. Sir plz tell us how to search job for data analyst,where to apply.make a vdo on this if possible
u take up certifications
Prepare resume and put it in naukri..
Can b.com gen graduated get the job in power bi
Experience person won't use sir it's fake one
Yes it's a fake one
Then what does exprinced person use.... And what's wrong by calling sir... Is there any rules or rights in the labour law or company policy.... ఎక్కడా నుంచి వస్తారు రా బాబు మీరంతా.... కోడి చూడండి రా అంటే కోడి గుద్దలో fingers పెట్టీ గుడ్డు ఉంద అని చూస్తారు కదా రా ....
Thanks for this video ...