Live Recorded Interview | Power BI | Experience(2-4 yrs) | BIG 4 firm | 2022🔥

Link for the Scenario based QnA in Power BI: • Scenario based QnA - P...
Link for the Power Bi Interview QnA playlist :
• Power BI Interview QnA
Link for the SQL QnA playlist :
• SQL Interview QnA for ...
Link for the Data Warehousing QnA playlist :
• DW Concepts Based QnA
☀ Connect with me Here on Social Media ☀
LinkedIn : / shashank-singh-🇮🇳-ba4b...
Instagram : / shashank_nikumbh26
Your queries:
power bi interview questions
power bi interview questions and answers
power bi interview
power bi interview questions for experienced professionals
power bi interview questions for freshers
deloitte power bi interview questions
power bi scenario based interview questions
power bi service interview questions
scenario based power bi interview questions
power bi practice scenarios
power bi real time scenarios
shashank singh power bi
power bi scenario based questions
sql and power bi interview questions
capgemini power bi interview questions
accenture power bi interview questions
power bi managerial round interview questions
how to explain project in power bi interview
power bi roadmap
power bi jobs for freshers
power bi project explanation in interview
power bi resume for freshers
power bi fresher jobs
power bi resume
power bi developer resume
power bi resume for 2 years experience india
power bi developer resume for experienced
#powerbiinterview
#learnwidgiggs

[@AkankshaSingh-mg1vr]

Now this is what we needed, very useful video indeed! 👍🏻

[@learnwidgiggs]

🙂

[@mohitupadhayay1439]

0:56 : Append queries. 2:08 : Query Folding. 3:16 : Column from example. 7:48 : Limitations of Direct query mode. 8:48 : Star and Snowflake schema? 9:20 : How to convert Star to snowflake schema? 11:48 : Role playing dimensions? 11:55 : Use relationship DAX function. 12:32 : DAX queries? 12:55 : Cumulative total using DAX? 17:42 : Customizing chart. 19:23 : Relative vs Lookup value function 19:46 : Count vs Count rows function 20:00 : Try to understand 21:36 : Row context vs Filter context 22:30 : Decomposition tree use case 24:00 : Ways to share report to end user 24:55 : Row level security 25:11 : User principal name vs User name DAX function Later, SQL part.

[@nagarapusudheeksha5750]

Thanks broo 🙏

[@dipeshvarma1160]

Thanks buddy

[@dipeshvarma1160]

thanks bro

[@Royalkrk369]

For 3rd question replace values Also works

[@ravireddy270]

Completely real time based questions.....Most Appreciated

[@learnwidgiggs]

Thanks!

[@mangaldeep9544]

very simple interiew ....awesome interviewer

[@vikassinghjayara510]

Question: Rs 1000 $5000 4000$ Text.Select([Column1],{"0".."9"}) Solution: Go to Add Column---->Custom Column----> write the above formula and then currency values will automatically remove from the new column. Output will look like: 1000 5000 4000 After that change the datatype accordingly. Thanks!

[@Ali-ds5iy]

She seems more like a CS grad. Look at her going full confident at SQL section (vs becoming hesitant at power bi DAX questions)

[@indianparadisetrainer]

Just Superbbb Yarr.... Very Nice

[@learnwidgiggs]

Thank you 🙂

[@nishthatank5954]

Awesome sir really helpful 🤩

[@learnwidgiggs]

🙂

[@heroraji]

We need more videos like this

[@manishsathe8371]

Very Good ..Some really good questions are there with some good difficulty level

[@learnwidgiggs]

Glad you liked it.

[@Thetradersclub_]

Thank you Shashank bhai❤❤

[@sakshinaik05]

Looking forward more videos like this

[@letsexplore0075]

Hi Shashank, Thanks for the Great Video... Pls share the Answers for the interview questions...

[@Aeditya]

Thanks helped alot 👍🙏🏼

[@learnwidgiggs]

Glad it helped

[@vinayl910]

Thanks a lot...!!!

[@learnwidgiggs]

😊

[@incredibleradhika4164]

Keep creating such content...you deserve millions of subscribers!!

[@learnwidgiggs]

Thank you for appreciating 🙂

[@geetasingh2701]

Great video 👍

[@learnwidgiggs]

Thank you 🙂

[@Peaceful_World130]

Thanks sir

[@learnwidgiggs]

😊

[@user-zp6go2tz2r]

Thank you for sharing this information, kindly share more videos like this, can you please share a video for fresher with respect to power BI

[@learnwidgiggs]

Noted

[@shibayanbhowal2871]

Great video. Can you list out some more frequently asked questions in power bi and SQL interviews.

[@learnwidgiggs]

Please watch all the videos from the below playlist that I have already uploaded: kzbin.info/aero/PLk-s1KYuT-Pk2a1mbFe-nH7BNVdQjsWVU

[@daXcel7448]

The primary key doesn't stop us from dropping the table. We indeed can drop the table even if we have a primary key. If the primary key of the table is referenced by a constraint belonging to another table, then the table CAN'T be dropped

[@learnwidgiggs]

Right answer

[@sagarsharma12_]

SQL Server 1. Difference between Primary Key & Unique Key. 2. Can you Drop a table having primary key in it. 3. How to extract First Name in a new column from Full Name. 4. Difference between UNION and UNIONALL 5. When do we use HAVING clause. 6. Difference between Clustered and Non Clustered index. 7. Have you heard about common table expressions. Can you write a SQL query to delete duplicate records of a table using common table expressions. 8. If you have to take our 2nd highest salary from a Salary column using a sub query. How will you do it.

[@perfectionist6624]

Hi sir, if you can provide these questions and answers plz keep that link in description.... thanks in advance...

[@saurabhMaratha]

for measures aggregation is must

[@lavanyapadma3024]

Hi, can you please make more videos on DAX and python interview questions and if possible on ssas, thanks in advance

[@learnwidgiggs]

I have already uploaded few videos on DAX: kzbin.info/aero/PLk-s1KYuT-PnTC_JnuLsZvCnhdUgd5puZ

[@koustavbag3907]

Very good interview, questions were very good standard, I liked her approach to solve each problem, thanks :)

[@learnwidgiggs]

Welcome 🙂

[@SonuSonu-uh2er]

Was this the real time interview or some practice interview. I have never faced a interviewer so friendly even the camera is off,ahe says "wow" for a que.She is taking time to search.

[@sharathkumar1103]

Can you please do more video like this it is very much helpful to mee

[@learnwidgiggs]

Hopefully soon 😊

[@Jit02]

Thanks, Very Useful Video 🙌

[@learnwidgiggs]

Thank you!

[@powerbivisual]

Bro Try to do video for self introduction in Power bI

[@learnwidgiggs]

Noted 👍

[@insidehead]

After this interview Interviewer: will get back to you. 😁

[@madhusudhanreddyt2838]

fiscal year question...you can create a new column with month number and set the month for april as 1 upto march as 12 and the sort the columns by month number...pretty simple

[@learnwidgiggs]

Yes, this will work 👍

[@welcomevlogs7838]

I want power bi videos pls

[@lalitkaushik1812]

Basics are not clear in power bi she has 3.5 yrs looks like a fresher

[@sandeepreddy7687]

Is it for which company questions?

[@A-qd5vc]

You should have a course for interview preparation. It will help a lot of ppl

[@learnwidgiggs]

Thanks for the suggestion

[@Saumyagrow]

superb interview I watched so many mock but her knowledge is top notch

[@Yog3shPatel]

There should be correct answers as a part of the video. At the end of the interview

[@starfish9928]

thank you so very much for this video. But this itself feels like a technical round. Is there other technical round for this?

[@learnwidgiggs]

There was one more.

[@mangaldeep9544]

😃

[@WORLDOFGANGSTER]

Please upload more interview videos

[@learnwidgiggs]

Will upload hopefully soon 🙂

[@varrenagavenkatasuresh1236]

What was the package offered bro

[@jaikishanthakur3459]

Will I get pdf or file definition of question asking in interview Like any difference between this type question

[@longliveindia1637]

How can i give mock interview to you for sql and power bi

[@Bangloreblogs]

The mic she is speaking from alibaba useless power audio she is having but overall ❤️

[@tejtabla8246]

Hi Sir, Thanks for the good content. Did you get permission from Shivangi Mishra(Interviewee) to publish this recording of her interview on social media along with her photograph and name visible in chat box? I hope that's legal?

[@thesakshiskitchen6460]

Sir please make record interview video for freshers

[@learnwidgiggs]

I will, stay tuned.

[@Prachi.motarwar]

for 20200114 datatype to date, first in query editor we have to change its type to text then to date. Direct conversion is not possible

[@learnwidgiggs]

Yess

[@ravihanwate.]

How to install power bi in desktop windows 7 pe ek latest video banao

[@pasupathi9954]

Too be frank, I can't explain these things but can perform. If I was in her place, I might have said that "it's hard for me to explain and let me do it on the power bi"

[@learnwidgiggs]

Yeah that's also fine, if you have power bi desktop downloaded on yr desktop then you could share the screen and explain the answers.

[@vinayakkulkarni5407]

Sir, nice interview feel like real interview, But pls give output interview result on which areas they need to work on, it will help for fresher, sir

[@learnwidgiggs]

Noted!

[@mdsameersiddiqui5333]

Thnx sir, I have one question...I have experienced in power bi and Sql.. Will I get the job on the basis of that?

[@learnwidgiggs]

Yes, you will get it if you have proper knowledge in both.

[@priyaagarwal4559]

Hi Shashank Sir,What is the answer for ..1. there is a column with records Rs 1000, 5000$ ..how will you pickout number from the column ? 2.And how to convert start schema to snowflake schema ?

[@learnwidgiggs]

1. Can use 'Column from examples' feature in power query 2. Can't explain here

[@priyaagarwal4559]

@@learnwidgiggs : Thanks for the answer. Your videos are really very good. Thanks a lot. For second question if possible to post a video on that question will be helpful.

[@varrenagavenkatasuresh1236]

What as the package?

[@arjunk8259]

now a days openings for power BI was decreased, any reason behind it ?

[@learnwidgiggs]

I think it is due to year end, Dec and mid Jan most of the people were on vacation so recruitment was less

[@nobody99186]

I want to become a business analyst as a fresher. I have completed my mba in business analytics. How should I approach?

[@learnwidgiggs]

I will make a video on this soon, stay tuned.

[@iccstudio1106]

Pls share power bi CV so i can update my CV

[@sanket565]

Select max (salary) from employees where salary < (Select max(salary) from employees) Is this query correct for 2nd highest salary??

[@learnwidgiggs]

Yess, will work

[@baijayantibehera2722]

Q. Can we concatenate two diff column from diff tables ? if yes how, if no why?

[@raviteja163]

Yeah using union dax u cN DO IT

[@ganeshreddymotakatla6244]

Hi bro, I have a question on dynamic row level security. There are three columns in same dataset like Region manager ,district manager ,store manager. Qn. Based on this three columns how can we create dynamic rls.whenever region manger logins he needs to his district details and stores manager details...like for others ..how is this possible

[@learnwidgiggs]

You need to create 3 roles and use userprinciplename()

[@ganeshreddymotakatla6244]

Can I have ur mail id pls, so that I can share sample dataset..ana explain clearly

[@SyedAfroz3]

After every question she is talking more time than fresher hope she finds good answers 😂😂😂

[@ShubhashriBhintade-qz2br]

Is she got selected?

[@azammd1934]

i have a question ? the way the girl answered , is she was good at interview? as she skipped some questions

[@learnwidgiggs]

She answered 80% of the questions correctly..so it was good.

[@starsrocks06]

Sir pls upload fresher interview for power bi

[@learnwidgiggs]

I will.

[@saranvenkat6102]

How can we create measure for total sales and total cost?? Please reply

[@learnwidgiggs]

Using Sum() function

[@Crico_037]

Does data analytics hold much promise?

[@learnwidgiggs]

Absolutely yess

[@hunny635]

really a great learning from this video..i have experience at senior level in another domain ..but i wanted to switch to this field ..can i switch if i have good preparation..does age matter ?

[@learnwidgiggs]

Yes you can switch but to show yr exp as relevant exp you have to have deep knowledge as you are experienced

[@seemagadge3425]

What she answered all of them are correct..?

[@learnwidgiggs]

80% correct

[@NITIANShubham]

Thank you Shashank i have cracked R1 interview of PWC watching your video, can you tell me in R2 which type of questions I can expect

[@learnwidgiggs]

Nothing specific, just revise the videos on this channel..you are good to go.

[@pulukuriaparna7020]

Is it possible to get a job as a powerbi developer career gap with fresher?

[@learnwidgiggs]

The bitter truth is You have to toil hard to get the job... but yes possible

[@g.janardhanreddyjanardhan4478]

Voice clarity not good and next time set person from you side make interview that one and good for job seekers.

[@keerthanabethi7460]

Can you explain the answer for question,, suppose column contains Rs.1000,$ 2000,,requires new column for only nums.. How wiil u do it in Power query editor??

[@learnwidgiggs]

You can use "column from examples functionality" in power query

[@keerthanabethi7460]

By using split column---→by non digit yo digit. We can do right?

[@learnwidgiggs]

@@keerthanabethi7460 It will not work in this case!

[@thedatapros5221]

@@learnwidgiggs Extract will work i think brother

[@thandruphani]

@@thedatapros5221 no it has limitations because extract functions works like this for suppose if u extract the first character u will get the remaining characters but here u got one problem if got any blank in any one or more rows , you won't be getting correct values where as column from example it identifies the numerical values and extract them , simple . Ok

[@DurgaPrasad-fo9iu]

Power bi in trend??

[@learnwidgiggs]

Yess

[@vablestory2.0]

u know 😆

[@saranvenkat6102]

Is cumulative dax function is correct??

[@learnwidgiggs]

There is no cumulative function in Dax but ya what she wrote will work to calculate the cumulative sales

[@abrahamvincent6272]

Can we use YTD sales for cumulative for year wise sales right?

[@bandarusrinivasarao2857]

YOU KNOW😅😅😅

[@bilhanbel7591]

these sound cracking is so annoying... but thanks for sharing

[@learnwidgiggs]

Yeah, somehow it cracked, sorry for that.

[@sreemalapal]

Hi Shashank..For the ques asked at 20:20, whats the correct ans for your question? To my understanding, it can be because of 2 reasons - i. We need to check if interactions is enabled/disabled under 'Edit Interactions'. ii. If the above is On, then we have to check if the relationship is correct between the two tables loaded. Let me know if the above is correct.

[@learnwidgiggs]

Yes it's correct 👍

[@arjunk8259]

was she qualified for next round ?

[@learnwidgiggs]

Sorry, can't disclose!

[@learnwidgiggs]

@@sharathkumar7041 yes posted here so that people can have the real interview experience and test how much good is their preparation to switch... result does not matter here except for the individual who gave the interview.

[@xyz_1943]

In real time really interview questions like this sir? I know about 98 percent of answer u asked in this interview.....so ?

[@learnwidgiggs]

Well done, you will succeed soon 👍

[@kiranmai8773]

Can you please tell me how to optimize this dax code. Calculate( [sum of sales], product = 'pen')

[@xyz_1943]

@@kiranmai8773 sumx

[@kiranmai8773]

@@xyz_1943 thank you for replying....but as sumx as an iteration function ....as it performs eow by row opearation i think it takes more time ....are you sure about the answer

[@Ali-ds5iy]

jaan lay li larki ki

[@beingrishi6450]

Demo Interview

[@amishadagar4700]

Please also share ryt ans of these questions

[@learnwidgiggs]

Noted.

[@meghab2910]

what will be the answer for this questions? RS50000 and 4000$ how to convert into number

[@learnwidgiggs]

Use 'Columns from Example' functionality in Power Query Editor in Power BI

[@meghab2910]

@@learnwidgiggs i have try with this but using this only 1st value is changing rest of showing errors

[@learnwidgiggs]

Try to enter values in 3 to 4 records and then see

[@learnwidgiggs]

Otherwise you can see this video(watch from 20 mins) for more reference: kzbin.info/www/bejne/sKeZg4p_hZ6lpsk

[@sonuy5036]

What is the experience of candidate

[@learnwidgiggs]

3.5 yrs

[@sonuy5036]

Ohk n did she get placed

[@sreemalapal]

What is the correct ans for this question - How to convert Snowflake schema to Star Schema?

[@learnwidgiggs]

Can't explain this here in 2-3 lines

[@sreemalapal]

@@learnwidgiggs can you make a video?

[@learnwidgiggs]

@@sreemalapal will plan

[@MOHAN-PYARA]

simple answer is using merging we can do that

[@bvinod8338]

Give her a minute to think so that she can google 😂

[@namangarg7875]

Sir i am not from the technical background and have been working in Civil Core engineering branch since 6 years but has a decent knowledge of Power Bi but didn't have any industry experience into the same , can i enter into the industry of Power Bi, as i always had an interest in data and visualisations?? Your valuable suggestions will help me to draft my further preparation for entry into this data analytics field

[@learnwidgiggs]

Firstly from yr comment I am assuming you have 6 yrs of experience, and you want to enter in data and analytics domain with some knowledge in power bi...so my thought is yess you can definitely enter into this analytics domain..but if you are thinking to show this 6 exp range with exp of power bi and data analytics then you have to have deep knowledge of power bi plus other skills also and proper strategy how you will show it as relevant with inclusion of working on different projects duration this 6 exp. Also watch the below video to add more skills with this experience kzbin.info/www/bejne/mmTYeGOam9yVZ80

[@namangarg7875]

@@learnwidgiggs thank you sir, now will start with SQL course. Can you please tell me the appropriate learning option so that it would be easy for me to learn SQL....? I actually didn't get the idea to where to start learning SQL from basics as i am a noncoder

[@learnwidgiggs]

@@namangarg7875 You can learn from KZbin only like there are many video series present..you need to figure out from which one you are able to understand and then complete all the videos to learn it.

[@rahulwagh1678]

voice celerity is sooo poor

[@learnwidgiggs]

yeah, sorry for that, it somehow cracked.

[@thetorqtrader]

She has a bad habit of saying "you know" every time which is very annoying

[@Jeet-_-]

😂😂

[@Jeet-_-]

😂😂😂

[@bansdeepkumar]

This girl knows nothing.... Women 🤣....

[@piyushramkar9404]

Thank you sir

[@learnwidgiggs]

😊