Exclusive: EY 2021 Power Bi Developer Interview 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/3IG1wm
"Take a look at our demo classes for one week before making a decision. "
Get an exclusive inside look at an EY 2021 Power Bi Developer interview! Learn what questions to expect and how to prepare for your next job interview in the field of Power Bi. Don't miss out on this valuable insight!
📊 Unleash the power of data with our Full-Stack Power BI course.
Learn SQL, Power BI, Azure, and Microsoft Fabric Environment to transform raw data
into insightful dashboards. Perfect for aspiring data analysts!
Full-Stack Power Bi by Mr. Santhosh
Key Highlights
🆓 1 Week Free Classes
📑 Resume Support
🔄 Free Agile Classes
💯 100% Job Assistance
📚 Easy Learning Access
🎁 Free Power Bi License and 50% off Pl-300 Certification
Join What's-App Group:
chat.whatsapp.com/DM2k8vX3yxQ...
Join Telegram Group: t.me/ksrdatanalytics
🚀Register Now:
www.datavizon.com/course/Full...
Visit www.ksrdatavision.com for more information
Talk to Course Adviser: 8951795123 / 8951785123 / 9916961234
#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

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

[@Mercy0812]

Hello, I would like to connect with you to get some insights on Power BI please. I live in USA. The WhatsApp link here isn’t working. Is there an email or another WhatsApp number to connect please

[@mludi9092]

😅😅

[@AhmedZech]

😂

[@mohitupadhayay1439]

2:05 : Import vs Direct Query mode. 4:47 : Roles played. 6:50 : Custom charts : Infographics, Scroller, Word cloud, Drill down column charts. 7:50 : Sankey chart : To compare two categorical variables. 8:10 : Ribbon chart : Extended version of column chart. 9:05 : Conditional formatting. 10:00 : Time intelligence functions : Function name 'SamePeriodLastYear' 11:58 : SUM and SUMX 13:30 : All and AllX 15:07: M-Language? Mashup code. 16:30 : Star and Snowflake schema 17:48 : Types of JOINS 19:20 : Dense Rank function 21:25 : Challenges faced : Data gathering 25:00: RLS 26:10 : Bookmarks 27:10 : How do you update yourself? 28:30 : Questions for the Interviewer?

[@KSRDatavizon]

This is very helpful. Thank you so much for this

[@mohitupadhayay1439]

@@KSRDatavizon Thanks to you for providing such valuable content. Please consider dropping links below your video for all the topics in the time stamp if you have made them. In this way any one will click the link and will be able to learn about it.

[@deependrasingh2700]

Thanks

[@abhinitkumar8274]

good job

[@sajalshrivastava2202]

Mohit sir your comments as helpful as this interviews 🙏

[@supr13]

This interview is so engaging. and the Dinesh guy is in his top form... I do manage a Data Analytics team, even I wouldn't be able to answer the questions so swiftly. Nice.

[@kalichettyudayasri3600]

Similar qns are asked in almost all interviews. Really helpful 😊

[@KSRDatavizon]

Glad it was helpful!

[@manishvysyaraju2219]

@@KSRDatavizon hi sir , I wanted to start my career in power bi , is it a good time to start ? , I am having two years of it experience as a support role

[@gamerboyakansh8081]

@@KSRDatavizon 😂🤩

[@charithacherry3099]

This guy has so much knowledge! 👍 👌

[@KSRDatavizon]

Thanks for your comments. Please Subscribe and Share

[@dharmakale254]

so beautiful ❤️

[@lalitkaushik1812]

Candidate has good knowledge

[@saurabhsoni6609]

This dude have so much pf knowledge, I learnt a lot from this video. Thanks You.

[@KSRDatavizon]

Glad to hear that!

[@CK-ir2ke]

Really very useful sir, please share more videos will help us to crack interview.

[@KSRDatavizon]

Ok. Thanks

[@TEJ-hy6bn]

you gained my like after finished your skills part.

[@KSRDatavizon]

Thank You :)

[@kshitijpande1874]

I have been selected in 3 companies for power bi Developer position. Accenture, Polycab and Toyo Engineering. 3 years of power bi experience. Thanks for your videos.

[@bhangura3026]

Linkdin ?

[@biswadeepsahoo]

Please advise how to get opportunity for fresher in PBI

[@prathapreddygerigi3262]

When you getting?

[@sayyedsahil4184]

Are bhailog ye jut bolra hai LinkedIn ki profile share q bhi kra fir

[@vijayprasad-vu5yd]

How much salary you except

[@rajsekhar6391]

It's really helpful and I get some confidence 🙌

[@KSRDatavizon]

I'm so glad!

[@KSRDatavizon]

Please subscribe our channel for more series

[@sarihaddu]

Thanks for this interview. It boosted my confidence. I will be uploading resume and attending interviews shortly.

[@KSRDatavizon]

Best of luck!,

[@shwetharaokadari3200]

such a useful video and thanks a lot for all the efforts in taking time and sharing this!

[@KSRDatavizon]

You are most welcome, Please subscribe our channel, it motivates a lot

[@pranalialaspure1833]

I just completed power BI course. I really like this interview answer questions. Thanks for providing this interview reference.

[@KSRDatavizon]

Thank you for your kind words! I'm thrilled that the interview answer questions were useful to you after completing the Power BI course. All the best for your next interview. we have few more videos like top 25 sql, power bi interview questions it may helps you. , please subscribe our channel for regular updates and it motivates us a lot

[@pavanjahagirdar9527]

This is very useful before attending interview, Thankyou for uploading. ❤

[@KSRDatavizon]

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

[@nagacharikalluri9859]

Really helpful.do some more videos to crack interviews.thanx

[@KSRDatavizon]

More to come!

[@lopamudra22]

This is a well informed prep for all interviewee.

[@KSRDatavizon]

Thank you Lopamudra, please do refer the channel in your network.

[@TDNoteBook]

Thank you for this video and it is really helpful.

[@KSRDatavizon]

Thank You So much

[@abithaguru2272]

Thanks bro for this video this is very helpful. Pls do more videos.

[@KSRDatavizon]

Sure I will, please subscribe our channel, it will motivates us to do more, thank you

[@arunn7255]

Really very helpful...tqqqs alottt

[@KSRDatavizon]

Happy to help

[@shaloh9206]

From the last 15 minutes I was listening this in 1.5X and I was thinking how is this man able to recall everything so fast. 🤣

[@KSRDatavizon]

Please do watch our videos on Frequent asked PowerBi Interview questions

[@unitedwings6216]

he is faculty of ksr datavizion who runs this institute

[@iskav]

This is not a real interview.. No one explain that much elaboratively during interviews. Need some time to think and come up with examples. But it is a really helpfull.

[@hallbody33]

Brilliant video, really great knowledge

[@KSRDatavizon]

Thank you so much for your comment, please subscribe our channel for regular updates. it motivates us a lot

[@mera6888]

its very clearly understand please make more power bi interview videos for freshers also

[@KSRDatavizon]

Thank you for the feedback! I will definitely consider creating more Power BI interview videos for freshers.

[@venkataramanak8264]

The interview is not in-depth . However for a candidate who has 4 yrs exp this is a good interview. I used to work on Analysis services when I had 4yrs exp but the interviews used to be tougher than this.

[@KSRDatavizon]

Thank you for your feedback, Please subscribe our channel

[@hemanthyadav601]

Thank you brother!

[@KSRDatavizon]

My pleasure!

[@kavithareddy222]

Thank you so much share this

[@KSRDatavizon]

You are so welcome

[@maratha0261]

Thanks 🙏🏻 it's really helpful

[@KSRDatavizon]

Glad it was helpful! please subscribe our channel for regular updates

[@roshansaikumar5995]

In this interview video usefull for all upcoming PBI developer's...

[@KSRDatavizon]

Thank you

[@Soulenergy31]

Great content bro!!!

[@KSRDatavizon]

Glad you liked it

[@kovvurudharani9602]

It is very wonderful and excellent 👌👌👌

[@KSRDatavizon]

Thank you so much 😀

[@KSRDatavizon]

Please subscribe our channel its motivating us to make more valuable sessions

[@vgurureddy]

It's so much helpful thanks so much 👍🙏🏽 requesting for more videos thanks 👍😊🙏🏽

[@KSRDatavizon]

More to come!

[@jawediqubal7557]

This interview could be possibly any thing but live interview!

[@KSRDatavizon]

Its live interview recorded

[@sasidharreddykomatla3006]

Thanks for your Information

[@KSRDatavizon]

Welcome

[@sakshinaik05]

Thank you for the video plz expl one proj

[@KSRDatavizon]

sure Sakshi, very soon we are going to upload one video with end to end Project explanation

[@manjulagowda2414]

too good.... 👍 thanks for sharing

[@KSRDatavizon]

Most welcome 😊

[@srivaniidha9821]

Very useful thank you 😊

[@KSRDatavizon]

Glad it was helpful!

[@rajap5751]

It was helpful. 🙏🙏

[@KSRDatavizon]

Glad you think so!

[@raginishrivastav4264]

Please make this type of video for fresher data analyst and thank you

[@KSRDatavizon]

sure, You are most welcome, Please subscribe our channel, it motivates a lot

[@lalitganoskar7476]

Good one thank you

[@KSRDatavizon]

You're welcome

[@furkankhan3879]

Please make a video of power bi service. Tell us about publish report n access, gateway, n refresh options.

[@KSRDatavizon]

We will be uploading complete project shortly

[@mazharhussain8871]

Date manipulation if automated on selection will be appreciated such as parallel period last year, YTD, QTD,MTD etc.

[@KSRDatavizon]

Thanks

[@padmapriya9139]

Really helpful

[@KSRDatavizon]

Glad you think so!

[@pathurimounika6873]

Next time, please interview a bit tough questions on powerbi. So, it will be useful for the people who has more than 4years experience.

[@KSRDatavizon]

Sure we will prepare on same. we are coming up with Power Bi Resume Projects

[@vishnurao2901]

He is having good knowledge on power bi 👍

[@KSRDatavizon]

Candidate was trained in our institute. Owns 4 years Exp

[@shaikshoyab1536]

he is a trainer

[@unitedwings6216]

@@shaikshoyab1536 yes

[@Moon_Rise6393]

Thanks Santosh Sir 😊

[@KSRDatavizon]

Welcome :)

[@srinuvasu4148]

👍 very useful

[@KSRDatavizon]

Glad to hear that

[@BTECH123]

Please make a video on architecture from sql server to power bi prohect steps if we don't use data warehouse. 🌹🌹🌹🌹

[@KSRDatavizon]

We will planning for similar project as well. Thanks for your suggestions

[@240vipin]

Job Laga bhai after that good interview

[@KSRDatavizon]

Yes he got offered

[@babus2241]

Around 10 companies asked same questions

[@KSRDatavizon]

Thank you for your feedback, please subscribe our channel

[@kesavanandt1195]

Super bro....

[@KSRDatavizon]

Thanks

[@kaptanrajpoot9832]

Pls make a demo class.. I am interested.

[@KSRDatavizon]

Here was the link demo conducted kzbin.info/www/bejne/o53Zq6pslN2Ilck

[@kusaanjireddy5563]

Super...👍👍👍

[@KSRDatavizon]

Thank you! Cheers!

[@jagatkrishna1543]

Thanks 🙏

[@KSRDatavizon]

You’re welcome 😊

[@TechnoReddy]

I have attended EY Power Bi positions, they asked same questions but not these many , Usually EY panel is is 2 members

[@deepanwitabasu3416]

Could you also please mention some of the questions you faced in power bi and sql? It would be helpful for interview preparation.

[@vishukumar6377]

Hi bro.. can u help with few interview questions for power bi

[@TechnoReddy]

@@vishukumar6377 mail id

[@KSRDatavizon]

Yes. Depends on position

[@srinuvallepu2450]

I need interview support

[@perfectionist6624]

why Azure data factory is required for power bi developer. and is it really mandatory skill for freshers as well ?

[@KSRDatavizon]

yes sir, in current situation it would be good to get placed

[@raghavendrasuru6545]

Interviewer voice is so sweet ❤️

[@regulaaasrith9408]

"Just Perfect"

[@KSRDatavizon]

Thank you !! Please subscribe our channel

[@phanikumar6107]

Tq Soooooo much

[@KSRDatavizon]

Welcome 😊, Hope you have a cracked an interview. Please do share and subscribe.

[@aadityasharma9851]

The interview is really good and the quality of questions and answers are really good. But they both are in different video also and girl is interviewee, he is an interviewer. So dont assume this as a Genuine interview

[@KSRDatavizon]

you are welcome, please subscribe our channel for regular updates

[@Akash-ft6sn]

I'm joining cigna this month

[@Nana-on8vv]

Can u pls upload the videos on star schema nd snow flake schema.

[@KSRDatavizon]

Sure we will upload more videos

[@ankitjoshi8436]

Superb

[@KSRDatavizon]

Thanks 🤗

[@Samurai_420]

I also worked in Fidelity :)

[@KSRDatavizon]

Good to know Nishad.

[@machasandeep4079]

good convincing skills

[@KSRDatavizon]

Candidate trained from our Institute

[@overlord7096]

@@KSRDatavizon he is fake guy saying 3 years of experience. I am working as PowerBi developer (real) with 3 years and I can easily tell that He is fake exp guy.

[@BTECH123]

Star and snowflake are for data warehouse know sir. Can we use power bi without data warehouse also directly from sql server to ssis to ssas to power bi

[@KSRDatavizon]

Yes possible. We can

[@overlord7096]

Yeah same, He is just giving random answers not the correct answers to the point. Also this schemas are not used on Power bi. It's used on data warehouse.

[@anilpatnaik2860]

can't we use DAX and some functions in direct query mode?

[@Koushikk-re6qh]

we cant use few time intelligence functions

[@KSRDatavizon]

You can use DAX in Direct Query, although some of the functions that you are able to use are limited. Using Import mode ensures that you are able to use all DAX functions

[@vinayl910]

Clients name are always confidential how can you disclose their name in interviews...

[@KSRDatavizon]

Hi Vinay Thank you for raising your concern,, Yes we agree client name is confidential.. but we are talking about the problem statement and how our reporting is going to solve. We are not sharing client's features (Client name will also be mentioned in resume)

[@vivekch9476]

KSR best chanel for Data Analytics

[@KSRDatavizon]

Means a lot.. Thank you.. keep watching

[@vivekch9476]

@@KSRDatavizon Sure Sir, watching Tips & Trics video right now! Your videos give us confidence to attend interviews. 🙏

[@dipsaha5914]

It should not be you, it should be we :)

[@KSRDatavizon]

Thanks for corrections

[@sandrabharath836]

What is M stands for, in M - Language in Power query editor?

[@Pooja-pd1ee]

Mash up

[@KSRDatavizon]

Mash Up Language - Used to audit all transformation Steps in Power Query Editor

[@sandipansarkar9211]

finished watching

[@KSRDatavizon]

Thank you so much for your comment, please subscribe our channel for regular updates. it motivates us a lot

[@VamshiKrishna-yl8bz]

His Voice similar like hero Kalyanram

[@KSRDatavizon]

Thank you :)

[@BTECH123]

If have power bi reporting server should we have to go for ssrs sir?

[@KSRDatavizon]

Thanks

[@chandanasapram2122]

How to learn Powerbi basic level to Professional level if you have the videos please share to me and which skills is important to get a job in Bi Developer

[@KSRDatavizon]

We provide training in Advanced level with real-time projects. Please reach out for more details. [phone]

[@jeet611_]

helpful , can we get the interview for a fresher as a power bi developer

[@KSRDatavizon]

sure will plan very soon. You are most welcome, Please subscribe our channel, it motivates a lot

[@chethikumar9789]

My self Name.... I have total 4 years experience in I. T....in that relevant experience I worked on power bi almost 3 years Currently am working for/with GMC In that am part of end to reports. Coming to skill set am good at SQL,and visualization tools such as power Bi. Most of the I experience in building end to end report. What exactly we do is....we gather a information about the insurance data...from on premises Database....we try to do ETL process....report them on an application. For example:-How the business is growing which type of insurance is not working

[@nikitasomase193]

Hey, could you please help me with information that is there any scope for non-IT candidate to start career with power Bi technology tool.. is there any criteria for selection process.

[@KSRDatavizon]

Hi Nikitha, lot many students transformed their career from Non -IT to IT, such as BPO, banking, Mechanical etc, please reach us for more details. [phone]

[@sayyedsahil4184]

@@KSRDatavizon ye number kiska hai bhai

[@manishvysyaraju2219]

Hi sir, I wanted to start my career in power bi , but I am having two years of it experience , is it a good time to start ? I have worked as a support guy

[@KSRDatavizon]

Power BI will be good opportunity to move to High skilled profile. Data Analysis will be future

[@cn9699]

hi I am also in similar situation. I am an B.Sc( mathematics, statistics, computer science graduate) 2021 currently working in an MNC in technical support role my project is like giving technical support to the client who are using product which does mail archiving , journaling etc. I am not at all getting any motivation to work here just forcing myself to work here for my poor financial condition and survival. Plz anyone provide me there inputs I am very much intrested in data analytics and programming . Does it possible to me to get career transisition after I worked here for 1.5 \ 2 years untill that I learn all skills requaired from my current role . plz guide me your small input helps me a lot I just want a better life than What I am having till now🙏🙏🙏🙏🙏🙏🙏

[@meghanamags9217]

Captions are not available for this please provide that

[@KSRDatavizon]

Sure.. will add

[@akshayshirbhate7]

Interview questions for freshers plz?

[@KSRDatavizon]

Hi Akshay, here is the link kzbin.info/www/bejne/onfHZH56nKeAl6c

[@praveensahni5547]

Power bi is only enough or need to learn anything else for data analyst role ?? Anyone please help

[@KSRDatavizon]

Hi Praveen, Sql would be the mandatory to be come a successful Data analyst, now days Azure going to be play important role

[@bhuhsan009]

Can MBA sale guy do power bi.. as powe bi is comparatively new tool and it's related businesses intelligence...

[@KSRDatavizon]

yes it will be good opportunity

[@vijayj6662]

Even I'm interested in this Power Bi tool can u advice with more details

[@KSRDatavizon]

Reach us on [phone] for more details

[@vinayroyalzcreations9665]

is this your personal interview?

[@KSRDatavizon]

its one of our students interview

[@BTECH123]

Do one more project sir

[@KSRDatavizon]

Sure we will upload more videos

[@aniljha6106]

Though I have cracked the ey interview but they are offering very less package 😭

[@KSRDatavizon]

Request you to follow this video for getting higher package kzbin.info/www/bejne/pnLRYpqbg9qGe80

[@saumyaanand3954]

How much are they offering?

[@vamshi_i]

Guys, i'm planing to choose power BI is my career option.. Is this ryt in this time.. Pls tell ur opinion..

[@abhishekkurup]

Should be great but you shouldn't just stick with Power BI you need to continuously learn new and better things and improve yourself.

[@KSRDatavizon]

yes vamsi, however you cant stick only with Powerbi you should learn Mysql, Powerbi and ADF or MSBI for long career, nowadays ADF would be the best option along with Powerbi

[@KSRDatavizon]

Great suggestions sir, Thank you so much

[@vamshi_i]

Thanq for ur valuable suggestion

[@reddymaestro3569]

U shd have db knowledge first and then data ware housing then u can sustain the career for a long time..else it will be a short career only with power bi reporting

[@nitinkumar-xw1vg]

This video is 100% mock test, which organized by any coaching centre 😁not a real company interview

[@Engineering4675]

Right...she is just listening

[@KSRDatavizon]

actually we have attend an interview and record the same. but we cant keep the same voice of panel due to legal issues, we re recorded the panel questions again with my team, answers are from live, we edited the concept

[@KSRDatavizon]

actually we have attend an interview and record the same. but we cant keep the same voice of panel due to legal issues, we re recorded the panel questions again with my team, answers are from live, we edited the concept

[@zohaibjamal]

genius guy

[@KSRDatavizon]

Thank you for your feedback, Please susbscribe our channel, it motiavtes to make more valuble sessions

[@prashillohakare4791]

Can non technical students gets job into IT field, can we get job after doing some courses like, java, data science or phyton or Power BI

[@KSRDatavizon]

Yes Prashil, please ping us on WhatsApp wa.me/919916961234 - Our Course advisor will provide details regarding this

[@ashokbandi578]

(what's challenges faced in project) pls any one answer this question in comment bax ,it will help full for self preparing people..it;s my humble request . i am self preparing for interview. i am fit in subject but i am struggle this type of question. I don't know how can i expalin way of explain . please please please please please help me send me answer in comment .

[@umamaheswarareddydesireddy146]

Please refer this video : kzbin.info/www/bejne/l37UgWaAgL6IkJY

[@KSRDatavizon]

please watch this video: kzbin.info/www/bejne/l37UgWaAgL6IkJY

[@aakaashskale9228]

Hr, even its the end of the world "We will get back to you" (end of the session) But they don't 🙄

[@KSRDatavizon]

Yah, it happens sometimes - but we have to fight for our chances.

[@tharunreddy2892]

As a fresher chances to get job 2020 passed out

[@KSRDatavizon]

its little difficult but if you are not bothered about salary it would be easy to get job as fresher too

[@tharunreddy2892]

How much salary can I expect bro

[@maatranmani885]

Friends, how much we can expect for the Power BI expert with 5 years of experience in Indian market

[@KSRDatavizon]

With 5 years of experience and expertise in Power BI, individuals can expect higher salaries, typically ranging from ₹10 lakhs to ₹18 lakhs per annum.

[@lakshmisravani549]

Ur great please help me bro for getting job

[@KSRDatavizon]

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

[@originasmr]

can a fresher with non-cs background get into power BI and get a job ?

[@KSRDatavizon]

Hi Origin, yes any one can learn and get as Powerbi developer, lot many our students started their career in PowerBi from non IT background like Pharma, Banking, Teaching, Mechanical etc..

[@akshaypanse9050]

How much interview rounds in EY?

[@KSRDatavizon]

3 rounds for this call

[@khushbooyadav9047]

Can I mention my client name while explaining my project

[@KSRDatavizon]

Yes, You can. However few Domain we need to maintain the secrecy like. Bank Projects.

[@ItsAlreadyDone]

Frankly telling for small matters this guy explain like it's this much big kind way . I m the only guy kind . Power bi is just cool work guys not tufff like he explaining bla bla bla . And easy to learn easy to work just be creative cool

[@KSRDatavizon]

it depends on each individual sir.. each one will have own way explainations.. but we wil take this.. thanks for the feedback

[@Ali-ds5iy]

No ETL questions?

[@KSRDatavizon]

Yes. Depends on Job Description

[@vineetraj4121]

Verdict??

[@KSRDatavizon]

Cleared. We will upload final round shortly