Hi Viewers, if you have any queries on this topic or you want any topic to learn from us, drop them in our comments section. Please make sure you subscribe to our TH-cam channel 👉Please ping on WhatsApp wa.me/9916961234
This guys Dinesh spoke like more matured who are actually having like experience of 8 to 10 years......Great skill in short period of 4 years.......Im sure you will be way beyond your expectations in next 4 to 5 years....I wish All the very best....By the way thanks for giving us this opportunity to listen and gain some knowledge...
i just dont know how to react to this, whether I need to cry cause I don't have these much knowledge, or this person gave 100% info on power bi. as I have an interview but time is too low., any way thanks to this channel and Mr dinesh
Hello @KSRDatavizon I have one question how to answer one of the above question how Big your data and how many fact and diamemsion you have in your dataset for banking domain... please guide it will really help
hank you for your question! When responding to questions about the size of your data and the number of facts and dimensions in your dataset for the banking domain, here’s how you can approach it: How Big is Your Data? The size of your data can depend on various factors like the number of customers, transactions, accounts, and products. In banking, the dataset often consists of millions of rows due to high transaction volumes. You could mention an approximate size (e.g., "We are working with a dataset of over 50 million rows" or "Our dataset is around 200GB") to give context. If unsure, it's good to mention typical data size ranges. Number of Facts and Dimensions: Fact Tables: These store transactional data like deposits, withdrawals, loan disbursements, or credit card payments. You can explain that fact tables in banking usually revolve around customer transactions, loan accounts, or financial product performance. Dimension Tables: These store descriptive information like customer details, branch information, product types, etc. In banking, dimensions might include customer demographics, transaction type, account type, and time dimensions. For example, you might say, "Our dataset has 3-4 fact tables that store transaction-level data for loans, credit cards, and customer accounts, and we have around 10-15 dimension tables, including customer profiles, branch details, and time dimensions." I hope this helps! Feel free to reach out for further clarification, and don't forget to subscribe for more updates and insights on such topics. It really helps us create more content for you! Best regards,
Thank You Raj for feedback, yes we are planning to upload HR round too, also planning to upload other companies rounds also. please do subscribe our channel for more updates
Hello, Is there way to find whether a column is based on another column in power bi desktop or service ? Example- If database has two columns 'FirstName' and 'LastName'. They're concatenated to 'FullName'. Is there way to find in power bi that 'FullName' is made of two columns.
If you’re doing it as part of a native query or power query transformation, you can back track in M code to see at which point Full Name was created. If the transformation happens outside power query, say for instance you write a view in your db, in that case you will not be able to check whether it’s made form two columns within power bi as the raw source had the concatenation column
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...
thank you so much for this it helped me alot i got next step mail after manager level whr they asked my pan card and pay slips and they sent pre offer form as a fresher i dnt hv pay slips so i ws sent whaterver available with me (adhaar and pan) can i hope for offer?
You're absolutely right. It's generally considered unprofessional to disclose client information during the interview process unless explicitly asked by the interviewer. but to make the interview process easy from candiate point of view he reveleaed but its not advisable untill pannel aksing. if its Product based company its a open secret
Being confident is good being overconfident while getting interviewed can make you loss your job that your interviewing for be humble n confident not over confident 😂
Excellent interview. I am systems administrator, having 9 years experience. I have learnt PBI, MS SQL and ADVANCE EXCEL through an Institute. Please share some key ideas how to switch my profile into Power Bi professional. Two of my interviews in AXA XL & ACCENTURE did not got cleared. Need some guidance
@@KSRDatavizon really How it is Possible to import this much amount in Power BI? He said in interview he used import mode ? so can u explain ? please reply fast
@@KSRDatavizon I again Listen it and he said it in MBs and NOT in Terabyte. Please don't create unnecessary confusion. Please You listen it and then Tell. 3.25 min
@@8bitsql Hi Akshay !! Good Day.. sorry for late reply.. we took time to verify from the mentor to double check on this.. we dint want to give false statement. that's the only reason we took time to respond. Now coming to question, yes sir you are right in this video it was MB only. However its still possible to connect to TB data to power bi (by using direct query or by using azure services). Apologies for inconvenience 🙂 and we sorry for wasting your time sir.. we understood that your time is precious.
Exactly !!, as informed earlier we just recreated an actual interview. as we cant upload the Pannel voice. we recorded the conversation and recreated with same questions. hope you cna understand. Thank You so much for your comment, Please subscribe our channel for regular updates, its motivates us a lot
again.... Thank you, we are trying to give confidence to the job aspirants. so our trainer only attended for this interview to check the current market and clients requirement, it helps them to get a job. if this video helps a single person we are so happy.
Hi Viewers, if you have any queries on this topic or you want any topic to learn from us, drop them in our comments section. Please make sure you subscribe to our TH-cam channel 👉Please ping on WhatsApp wa.me/9916961234
This guys Dinesh spoke like more matured who are actually having like experience of 8 to 10 years......Great skill in short period of 4 years.......Im sure you will be way beyond your expectations in next 4 to 5 years....I wish All the very best....By the way thanks for giving us this opportunity to listen and gain some knowledge...
Thank you
Way he was explaining, man!! what a flow.. Dinesh bhai baakiyon ka job khatre pe hai aapke wajeh se..
Literally a gem.
Person was trained in our institute
@@KSRDatavizon could you please share me your details , i had few queries and i guess you guys can guide me the correct path.
candidate is dominating the interviewer. he is much more confident than the interviewer
:)
This is a mock interview i believe
😅
This guy is like complete package, exactly like what PBI offers to its users :)
Thank You so much for your message. please subscribe our channel.
@@KSRDatavizon I did beforehand 👍😊
One of the best interview i have watched so far. Got to learn alot from Mr Dinesh. Thank you sir for providing this package to us.
So nice of you, Please subscribe our channel for regular updates.
actually it is more useful those who are freshers to attend the interviews it gives complete guidence of interview
Thank you so much for your responce, please like, share and subscribe our channel for regular updates, and it motivates us a lot.
Microsoft please hire this guy Dinesh asap, he is an ocean of talent...
His way of explanation is more clearer and much more confidence.
Thank you so much for your comment, Please like, share and subscribe our channel for regular updates. it motivates us a lot
Man he is a gem of knowledge.
Yah..
What an interview , excellent sir very use full, thank you for uploading this great interview
Glad you enjoyed it!
th-cam.com/video/VAOpMH_iXMA/w-d-xo.html
This guy is an asset to the company! 👍
Candidate was trained in our Institute !!
@@KSRDatavizon Hi May I know which institute?
@@KSRDatavizonhii will u please give ur no
what an interview. seriously .hats off
Thank you so much for your feedback, please subscribe our channel for more videos like this- its just motivating us
Great Sir! I have learnt so many things by these two Videos. Thanks you so much It will be helping us
You are most welcome, all the best for your future interviews.
i just dont know how to react to this, whether I need to cry cause I don't have these much knowledge, or this person gave 100% info on power bi. as I have an interview but time is too low., any way thanks to this channel and Mr dinesh
Thank you so much,
Very useful for me, thanks a lot for uploading interview videos
Thank you so much, please subscribe our channel, it will motivate us to do more videos.
As a freshers lot of things to learn from Dinesh
thank you
excellent job i can say and thank you very much for uploading and making it easy for most of the people who are looking for real time experience.
Thanks and welcome
I had an interview ur video helped alot for please make more videos with respect to other companies too.
sure, will plan to make more videos in this kind, please subscribe our channel, it motivates us.
Awesome man I learnt a lot of things from dis, I think this can help so many people who r trying to attend a PBI interviews Tqsm.
Thank you so much Kranti, i am waiting to hear a good news from you, hope very soon you will get job
Next level interview.. Dinesh is legend...
Thank you !! Please subscribe our channel
Hello @KSRDatavizon
I have one question how to answer one of the above question how Big your data and how many fact and diamemsion you have in your dataset for banking domain... please guide it will really help
hank you for your question! When responding to questions about the size of your data and the number of facts and dimensions in your dataset for the banking domain, here’s how you can approach it:
How Big is Your Data?
The size of your data can depend on various factors like the number of customers, transactions, accounts, and products. In banking, the dataset often consists of millions of rows due to high transaction volumes. You could mention an approximate size (e.g., "We are working with a dataset of over 50 million rows" or "Our dataset is around 200GB") to give context. If unsure, it's good to mention typical data size ranges.
Number of Facts and Dimensions:
Fact Tables: These store transactional data like deposits, withdrawals, loan disbursements, or credit card payments. You can explain that fact tables in banking usually revolve around customer transactions, loan accounts, or financial product performance.
Dimension Tables: These store descriptive information like customer details, branch information, product types, etc. In banking, dimensions might include customer demographics, transaction type, account type, and time dimensions.
For example, you might say, "Our dataset has 3-4 fact tables that store transaction-level data for loans, credit cards, and customer accounts, and we have around 10-15 dimension tables, including customer profiles, branch details, and time dimensions."
I hope this helps! Feel free to reach out for further clarification, and don't forget to subscribe for more updates and insights on such topics. It really helps us create more content for you!
Best regards,
Finished watching
Happy Learning !!!
wowowo. he covered entire Powerbi.. awesome.
Thank you
It's really good and try to upload more videos
Thank you for your valuable feedback, Please subscribe our channel for more informative videos
Very Useful for me thanks a lot 🙏🏻🙏🏻🙏🏻
Welcome 😊
Try to upload all rounds if possible.. thankful for videos
Thank You Raj for feedback, yes we are planning to upload HR round too, also planning to upload other companies rounds also. please do subscribe our channel for more updates
Hello, Is there way to find whether a column is based on another column in power bi desktop or service ?
Example- If database has two columns 'FirstName' and 'LastName'. They're concatenated to 'FullName'. Is there way to find in power bi that 'FullName' is made of two columns.
In anycase its a transformation
If you’re doing it as part of a native query or power query transformation, you can back track in M code to see at which point Full Name was created. If the transformation happens outside power query, say for instance you write a view in your db, in that case you will not be able to check whether it’s made form two columns within power bi as the raw source had the concatenation column
Create a new column as FullName and write the code like this: FullName = CONCATENATE(CONCATENATE([FirstName],+ " "),'[LastName])
In power query editor we can do it.
Bhai 8+ yrs me b humara itna well mannered explain nhi ho pa rha,, kese kiye ho ye practice :)
He is from KSR Datavizon.. he was been trained in such a way ..
Very informative! Learnt a lot.
Glad it was helpful!
Verry much helpful Thank you so much
Glad it helped
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...
please reach our team for more details
Sir make more vedio on manager round...
sure, recently uploaded, please check in our channel.
Superb Interview,very Helpful..
Glad you liked it!
Very informative
Glad you think so!
thank you so much for this it helped me alot
i got next step mail after manager level whr they asked my pan card and pay slips and they sent pre offer form
as a fresher i dnt hv pay slips so i ws sent whaterver available with me (adhaar and pan)
can i hope for offer?
Yes you will be getting response. There is delay in every organization due to vacation period.
Simply super
Thank you very much
Gr8 video and very informative
Glad you liked it, please subscribe our channel
I don't think we should disclose the client info until and unless interview dont ask you right. As per my understanding i am telling.
You're absolutely right. It's generally considered unprofessional to disclose client information during the interview process unless explicitly asked by the interviewer.
but to make the interview process easy from candiate point of view he reveleaed but its not advisable untill pannel aksing.
if its Product based company its a open secret
Looks like your interview was gone very well. So, Are you working in EY now?
Yes the candidate in working
@@KSRDatavizon What is the package and Location?
Superb
thank you
Being confident is good being overconfident while getting interviewed can make you loss your job that your interviewing for be humble n confident not over confident 😂
Thank You for your valuable suggestion, however confidence and over confidence may depnds on person to person and exp
good interview, but didn't ask much technical questions.
Yes. Depends on Job Description
What r interviewe 👌
Thanks
1 thing I noticed he always say Myself, is not it wrong when it comes to introduction?
Yes, better if you avoid using Myself.
My friend is looking to get placed as Power Bi developer with a fake experience certificate. What should he be mindful of in interview and while work?
start working on basics and practice more with kaggle datasets
This is real interview or mock
It’s mock with real interview questions
Hello sir. I have registered for Accenture Innovation Chllenge. Can you please suggest me some tips to win this challenge?
👉Please ping on WhatsApp wa.me/919916961234
Helpful
Glad you think so! , Please subscribe our channel, it will be motives to do more video's like this
Can I get Dinesh resume please
Hi Nikki, 👉Please ping on WhatsApp wa.me/919916961234
Thank you so much.
Always welcome
It is technical round 2 or manager round??
techno managerial round
Hi bro.. iam also from fidelity National financial company..i am searching job in power BI can you guide me how to clean interview please
Hi Chidanand, 👉 drop a message on our WhatsApp wa.me/919916961234 our course advisor will help you with guidance
Very helpful bro.. Wats ur current pkg n how much hike they offered, if may I know to ask in my interview?
Thank you so much Raghavendra, please subscribe our channel it will motivate us
is it okay to mention Client name in interview ?
Yes, as we are mentioning the client name in resume too
Hope...these are all mock interviews
These interviews are from our candidates
Excellent interview.
I am systems administrator, having 9 years experience. I have learnt PBI, MS SQL and ADVANCE EXCEL through an Institute. Please share some key ideas how to switch my profile into Power Bi professional. Two of my interviews in AXA XL & ACCENTURE did not got cleared. Need some guidance
Thank you
How much data size he said in this video? Audio is not clear Can anyone tell
Terabyte
@@KSRDatavizon really How it is Possible to import this much amount in Power BI? He said in interview he used import mode ? so can u explain ? please reply fast
@@KSRDatavizon I again Listen it and he said it in MBs and NOT in Terabyte. Please don't create unnecessary confusion. Please You listen it and then Tell. 3.25 min
@@KSRDatavizon please reply dont waste time
@@8bitsql Hi Akshay !! Good Day.. sorry for late reply.. we took time to verify from the mentor to double check on this.. we dint want to give false statement. that's the only reason we took time to respond. Now coming to question, yes sir you are right in this video it was MB only. However its still possible to connect to TB data to power bi (by using direct query or by using azure services). Apologies for inconvenience 🙂 and we sorry for wasting your time sir.. we understood that your time is precious.
Wow 🤩
Thanks
Hi Tahnks
Shape MAP for % wise
👉Please ping on WhatsApp wa.me/919916961234 to have a word with our trainers.
Can anyone help me like how do we get requirements from clients and what are the steps you follow for creating power bi reports??
Hi Narasimha, 👉Please ping on WhatsApp wa.me/919916961234 for more details on this.
How big is your data
Just checking? what's your question please?
Fact and dimensions
Just checking? what's your question please?
It's all staged. They are just acting it. In another audio interview, this man is the interviewer and the girl is the candidate.
Exactly !!, as informed earlier we just recreated an actual interview. as we cant upload the Pannel voice.
we recorded the conversation and recreated with same questions.
hope you cna understand.
Thank You so much for your comment, Please subscribe our channel for regular updates, its motivates us a lot
Data source..is flat files and SQL server
Excel, CSV are flatfiles
Why recruiters will ask PAN card no.? During interview
Verification
What do they verify?
Again, question paper leaked 😂😂
again....
Thank you, we are trying to give confidence to the job aspirants. so our trainer only attended for this interview to check the current market and clients requirement, it helps them to get a job.
if this video helps a single person we are so happy.
present power bi jobs unnaYA
yes, students are getting calls regularly, it may little slow in the year end, calls will get again in January
This guy knows nothing.
Candidate got placed with 18LPA with EY (4 years exp)
@@KSRDatavizon hahahah great answer
Finished watching
Happy Learning !!!