Power BI Developer Interview Insider Secrets Revealed!

Enroll in our new batch every month. Kickstart Your Career with Our Full Stack Power BI with Microsoft Fabric Course 2024. Register Now :- bit.ly/3IG1wmF
"Take a look at our demo classes for one week before making a decision. "
Live Recorded Interview For Power Bi Developer - Round - 2 (Manager Level)|| EY-2021
---------------------------------------------------------------------------------------------------------------------------
(if you miss the 1st round of interview please click on • First Round Live Inter... )
This video contains Interview Questions And Answers asked as part of the EY Interview process
It's a real-time interview session that was faced by one of our student and even he got selected in EY. So we would like to share this experience with all of you.
We 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 the topics/areas on which you need to concentrate while attending the technical interview.
#PowerBIInterview #PowerBI #WhatIsPowerBI #PowerBITraining #PowerBIforbeginners #azure #microsoft #microsoftfabric #datascience #dataanalytics #powerbi #cloudcomputing
#PowerBi #DataAnalytics #BusinessIntelligence #DataVisualization #BigData #Microsoft #Analytics #DataScience #BI #SQL #Excel #AnalyticsTool #MasteringData #DataInsights #Dashboard #DataAnalysis #Tableau #DataDrivenDecisions #DataReporting #businessanalyticscourse #powerbiinterview #powerbiinterviewquestions questions #datascience #ksrdatavizon #ksrdatavision
How are we different from others
1. 24*7 Life time Access & Support
2. Flexible Class Schedule
3. 100 % Job Guarantee
4. Mentors with +14 yrs
5. Industry Oriented Course ware
6. Life time free Course Upgrade
------------------------------
Call us on IND: 8951795123 / 8951785123 / 9916961234 to talk to our Course Advisors.

[@KSRDatavizon]

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 KZbin channel 👉Please ping on WhatsApp wa.me/9916961234

[@Ramreddy-kq5or]

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

[@KSRDatavizon]

Thank you

[@GopalSamantaray]

Way he was explaining, man!! what a flow.. Dinesh bhai baakiyon ka job khatre pe hai aapke wajeh se.. Literally a gem.

[@KSRDatavizon]

Person was trained in our institute

[@GopalSamantaray]

@@KSRDatavizon could you please share me your details , i had few queries and i guess you guys can guide me the correct path.

[@krisy8434]

candidate is dominating the interviewer. he is much more confident than the interviewer

[@KSRDatavizon]

:)

[@vamshiabhilash]

This is a mock interview i believe

[@Bahella]

😅

[@ShashiEY]

This guy is like complete package, exactly like what PBI offers to its users :)

[@KSRDatavizon]

Thank You so much for your message. please subscribe our channel.

[@ShashiEY]

@@KSRDatavizon I did beforehand 👍😊

[@nikhileshrao9159]

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

[@KSRDatavizon]

Thank you so much,

[@bezawadasujatha7327]

actually it is more useful those who are freshers to attend the interviews it gives complete guidence of interview

[@KSRDatavizon]

Thank you so much for your responce, please like, share and subscribe our channel for regular updates, and it motivates us a lot.

[@nikhilbhute07]

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.

[@KSRDatavizon]

So nice of you, Please subscribe our channel for regular updates.

[@gharikrishna2280]

What an interview , excellent sir very use full, thank you for uploading this great interview

[@KSRDatavizon]

Glad you enjoyed it! kzbin.info/www/bejne/jHKyoYB-lM6Lg6M

[@anamikatyagi8660]

what an interview. seriously .hats off

[@KSRDatavizon]

Thank you so much for your feedback, please subscribe our channel for more videos like this- its just motivating us

[@MoinKhan-1707]

Man he is a gem of knowledge.

[@KSRDatavizon]

Yah..

[@waseemalam9649]

Great Sir! I have learnt so many things by these two Videos. Thanks you so much It will be helping us

[@KSRDatavizon]

You are most welcome, all the best for your future interviews.

[@krishnamohangarlapati488]

Very useful for me, thanks a lot for uploading interview videos

[@KSRDatavizon]

Thank you so much, please subscribe our channel, it will motivate us to do more videos.

[@charithacherry3099]

This guy is an asset to the company! 👍

[@KSRDatavizon]

Candidate was trained in our Institute !!

[@deep3133]

@@KSRDatavizon Hi May I know which institute?

[@rmrj3655]

@@KSRDatavizonhii will u please give ur no

[@abhishekroy8125]

Microsoft please hire this guy Dinesh asap, he is an ocean of talent...

[@maheshtiwari2297]

His way of explanation is more clearer and much more confidence.

[@KSRDatavizon]

Thank you so much for your comment, Please like, share and subscribe our channel for regular updates. it motivates us a lot

[@Zvapvlogs]

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.

[@KSRDatavizon]

Thanks and welcome

[@krantikumar894]

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.

[@KSRDatavizon]

Thank you so much Kranti, i am waiting to hear a good news from you, hope very soon you will get job

[@shrushtikhaire2829]

I had an interview ur video helped alot for please make more videos with respect to other companies too.

[@KSRDatavizon]

sure, will plan to make more videos in this kind, please subscribe our channel, it motivates us.

[@perfectionist6624]

Next level interview.. Dinesh is legend...

[@KSRDatavizon]

Thank you !! Please subscribe our channel

[@AsifIqbal-nv5cv]

As a freshers lot of things to learn from Dinesh

[@KSRDatavizon]

thank you

[@Bhaskar-c9l]

Dinesh explained superb but the interviewer didn't ask technically can you please share that videos

[@durgamshashidhar4736]

wowowo. he covered entire Powerbi.. awesome.

[@KSRDatavizon]

Thank you

[@Gvfashontalks]

Very Useful for me thanks a lot 🙏🏻🙏🏻🙏🏻

[@KSRDatavizon]

Welcome 😊

[@SandipanSarkar-c8v]

Finished watching

[@KSRDatavizon]

Happy Learning !!!

[@gaikwadruchita16]

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

[@KSRDatavizon]

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,

[@leol6817]

Very informative! Learnt a lot.

[@KSRDatavizon]

Glad it was helpful!

[@lalitganoskar7476]

Verry much helpful Thank you so much

[@KSRDatavizon]

Glad it helped

[@amalayadav7406]

It's really good and try to upload more videos

[@KSRDatavizon]

Thank you for your valuable feedback, Please subscribe our channel for more informative videos

[@jatothveeresh2381]

Simply super

[@KSRDatavizon]

Thank you very much

[@samirsam4379]

Superb Interview,very Helpful..

[@KSRDatavizon]

Glad you liked it!

[@rakesh2017]

Bhai 8+ yrs me b humara itna well mannered explain nhi ho pa rha,, kese kiye ho ye practice :)

[@KSRDatavizon]

He is from KSR Datavizon.. he was been trained in such a way ..

[@Pratheek91]

Very informative

[@KSRDatavizon]

Glad you think so!

[@Rehan-os5ui]

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.

[@KSRDatavizon]

In anycase its a transformation

[@Imm23743]

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

[@rameshm3247]

Create a new column as FullName and write the code like this: FullName = CONCATENATE(CONCATENATE([FirstName],+ " "),'[LastName])

[@hrishikesh7291]

In power query editor we can do it.

[@rajsekhar6391]

Try to upload all rounds if possible.. thankful for videos

[@KSRDatavizon]

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

[@maheshtiwari2297]

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.

[@KSRDatavizon]

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

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

[@KSRDatavizon]

please reach our team for more details

[@souravsen8246]

Looks like your interview was gone very well. So, Are you working in EY now?

[@KSRDatavizon]

Yes the candidate in working

[@idwtv534]

@@KSRDatavizon What is the package and Location?

[@noshortcuttoglory6443]

Thank you so much.

[@KSRDatavizon]

Always welcome

[@harikrishnachavadam7899]

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?

[@KSRDatavizon]

Yes you will be getting response. There is delay in every organization due to vacation period.

[@Archanapandhare1997]

Sir make more vedio on manager round...

[@KSRDatavizon]

sure, recently uploaded, please check in our channel.

[@RamyaAdarsh182]

Superb

[@KSRDatavizon]

thank you

[@ankitjoshi8436]

Wow 🤩

[@KSRDatavizon]

Thanks

[@ankitseth100]

Gr8 video and very informative

[@KSRDatavizon]

Glad you liked it, please subscribe our channel

[@PankajPandey-vc6vc]

1 thing I noticed he always say Myself, is not it wrong when it comes to introduction?

[@KSRDatavizon]

Yes, better if you avoid using Myself.

[@rameshkomarapuri159]

Helpful

[@KSRDatavizon]

Glad you think so! , Please subscribe our channel, it will be motives to do more video's like this

[@xyz_1943]

This is real interview or mock

[@KSRDatavizon]

It’s mock with real interview questions

[@anweshkp6231]

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?

[@KSRDatavizon]

start working on basics and practice more with kaggle datasets

[@Ali-ds5iy]

good interview, but didn't ask much technical questions.

[@KSRDatavizon]

Yes. Depends on Job Description

[@8bitsql]

How much data size he said in this video? Audio is not clear Can anyone tell

[@KSRDatavizon]

Terabyte

[@8bitsql]

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

[@8bitsql]

@@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]

@@KSRDatavizon please reply dont waste time

[@KSRDatavizon]

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

[@indianparadisetrainer]

What r interviewe 👌

[@KSRDatavizon]

Thanks

[@sandrabharath836]

It is technical round 2 or manager round??

[@KSRDatavizon]

techno managerial round

[@narasimhamurthy2800]

Can anyone help me like how do we get requirements from clients and what are the steps you follow for creating power bi reports??

[@KSRDatavizon]

Hi Narasimha, 👉Please ping on WhatsApp wa.me/919916961234 for more details on this.

[@pandu3320]

Hello sir. I have registered for Accenture Innovation Chllenge. Can you please suggest me some tips to win this challenge?

[@KSRDatavizon]

👉Please ping on WhatsApp wa.me/919916961234

[@vamshiabhilash]

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 😂

[@KSRDatavizon]

Thank You for your valuable suggestion, however confidence and over confidence may depnds on person to person and exp

[@Chidu-Goudru]

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

[@KSRDatavizon]

Hi Chidanand, 👉 drop a message on our WhatsApp wa.me/919916961234 our course advisor will help you with guidance

[@sasmita_cutee]

Can I get Dinesh resume please

[@KSRDatavizon]

Hi Nikki, 👉Please ping on WhatsApp wa.me/919916961234

[@rajreddy7175]

Hope...these are all mock interviews

[@KSRDatavizon]

These interviews are from our candidates

[@shashanksingh7845]

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]

Thank you

[@Lucky.Hyd95]

Very helpful bro.. Wats ur current pkg n how much hike they offered, if may I know to ask in my interview?

[@KSRDatavizon]

Thank you so much Raghavendra, please subscribe our channel it will motivate us

[@perfectionist6624]

is it okay to mention Client name in interview ?

[@KSRDatavizon]

Yes, as we are mentioning the client name in resume too

[@aapbeete9761]

It's all staged. They are just acting it. In another audio interview, this man is the interviewer and the girl is the candidate.

[@KSRDatavizon]

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

[@kunalr_ai]

How big is your data

[@KSRDatavizon]

Just checking? what's your question please?

[@shahnawaz19841]

Hi Tahnks Shape MAP for % wise

[@KSRDatavizon]

👉Please ping on WhatsApp wa.me/919916961234 to have a word with our trainers.

[@kunalr_ai]

Fact and dimensions

[@KSRDatavizon]

Just checking? what's your question please?

[@sandrabharath836]

Why recruiters will ask PAN card no.? During interview

[@KSRDatavizon]

Verification

[@sarihaddu]

What do they verify?

[@kunalr_ai]

Data source..is flat files and SQL server

[@KSRDatavizon]

Excel, CSV are flatfiles

[@AnilAnvesh]

Again, question paper leaked 😂😂

[@KSRDatavizon]

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.

[@venkateshtelugu7582]

present power bi jobs unnaYA

[@KSRDatavizon]

yes, students are getting calls regularly, it may little slow in the year end, calls will get again in January

[@kunalr_ai]

This guy knows nothing.

[@KSRDatavizon]

Candidate got placed with 18LPA with EY (4 years exp)

[@prashantvarun23]

@@KSRDatavizon hahahah great answer

[@SandipanSarkar-c8v]

Finished watching

[@KSRDatavizon]

Happy Learning !!!