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

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

[@Doyouknowwhy3407]

This helps more than the actual video! Thanks

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

[@ravireddy270]

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

[@learnwidgiggs]

Thanks!

[@SandeepSingh-cy4hw]

commulative = calculate(sum(sales[revenue]),filter(all(order[date]),order[date]

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

[@lalitkaushik1812]

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

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

[@varunas9784]

Fantastic share Shashank!! Could we please be shared more of such live recorded interviews

[@Yog3shPatel]

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

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

[@indianparadisetrainer]

Just Superbbb Yarr.... Very Nice

[@learnwidgiggs]

Thank you 🙂

[@heroraji]

We need more videos like this

[@RajeshManepalli-o8b]

select * from( select *,denserank() over(order by salary desc) rnk from table_Name) A where rnk = 2

[@letsexplore0075]

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

[@hiteshKumar-bd7pk]

2nd highest salary:- Select max(salary) from employee Where

[@zenjiyt8381]

salary is missing select max(salary) as 2nd_highest From employee Where salary < (select max(salary) From employee)

[@perfectionist6624]

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

[@manishsathe8371]

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

[@learnwidgiggs]

Glad you liked it.

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

[@mangaldeep9544]

very simple interiew ....awesome interviewer

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

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

[@nishthatank5954]

Awesome sir really helpful 🤩

[@learnwidgiggs]

🙂

[@incredibleradhika4164]

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

[@learnwidgiggs]

Thank you for appreciating 🙂

[@mansikhandwe9284]

Interview questions was awesome

[@HarshithaKumar-i5f]

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

[@RajeshManepalli-o8b]

clustered index which is created on primary key column where as non clustered index which is performed on foreign keys i guess

[@A-qd5vc]

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

[@learnwidgiggs]

Thanks for the suggestion

[@powerbivisual]

Bro Try to do video for self introduction in Power bI

[@learnwidgiggs]

Noted 👍

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

[@Viky-ee4id]

​@@learnwidgiggscan I use split(Digit to non digit & non digit to digit)

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

[@Thetradersclub_]

Thank you Shashank bhai❤❤

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

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

[@saurabhMaratha]

for measures aggregation is must

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

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

[@rangamharsha]

Can we use split ( Digit to Non digit) ..

[@Bangloreblogs]

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

[@sharathkumar1103]

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

[@learnwidgiggs]

Hopefully soon 😊

[@RajeshManepalli-o8b]

for date related we have to split by characters then we need to merge them and need to change the date as data type this is my approach

[@koustavbag3907]

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

[@learnwidgiggs]

Welcome 🙂

[@sakshinaik05]

Looking forward more videos like this

[@insidehead]

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

[@Aeditya]

Thanks helped alot 👍🙏🏼

[@learnwidgiggs]

Glad it helped

[@Jit02]

Thanks, Very Useful Video 🙌

[@learnwidgiggs]

Thank you!

[@welcomevlogs7838]

I want power bi videos pls

[@starsrocks06]

Sir pls upload fresher interview for power bi

[@learnwidgiggs]

I will.

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

[@vinayl910]

Thanks a lot...!!!

[@learnwidgiggs]

😊

[@Peaceful_World130]

Thanks sir

[@learnwidgiggs]

😊

[@geetasingh2701]

Great video 👍

[@learnwidgiggs]

Thank you 🙂

[@RajeshManepalli-o8b]

where is used to filter on existing column where as having is used to filter on aggregated data

[@seemagadge3425]

What she answered all of them are correct..?

[@learnwidgiggs]

80% correct

[@Saumyagrow]

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

[@SyedAfroz3]

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

[@thesakshiskitchen6460]

Sir please make record interview video for freshers

[@learnwidgiggs]

I will, stay tuned.

[@ravihanwate.]

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

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

[@devushivagonda4902]

I recommend to learn how to take interview from foreigners straightforward this is what i need, can u? If any additional work we will train u, r u ready for that. But Indian interviews r like preparing for IAS Exams 😂 in real time all copy paste work

[@g.janardhanreddyjanardhan4478]

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

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

[@WORLDOFGANGSTER]

Please upload more interview videos

[@learnwidgiggs]

Will upload hopefully soon 🙂

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

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

[@piyushramkar9404]

Thank you sir

[@learnwidgiggs]

😊

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

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

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

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

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

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

[@jaikishanthakur3459]

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

[@DurgaPrasad-fo9iu]

Power bi in trend??

[@learnwidgiggs]

Yess

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

[@xyz_1943]

@kiranmai8773 sumx

[@varrenagavenkatasuresh1236]

What was the package offered bro

[@iccstudio1106]

Pls share power bi CV so i can update my CV

[@sandeepreddy7687]

Is it for which company questions?

[@amishadagar4700]

Please also share ryt ans of these questions

[@learnwidgiggs]

Noted.

[@Ishu_mehta_22]

great vdeo but not all answers are correct

[@longliveindia1637]

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

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

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

[@ShubhashriBhintade-qz2br]

Is she got selected?

[@bilhanbel7591]

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

[@learnwidgiggs]

Yeah, somehow it cracked, sorry for that.

[@prajaktapawar5389]

Is she selected??

[@varrenagavenkatasuresh1236]

What as the package?

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

[@gautam-b1w]

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

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

[@saranvenkat6102]

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

[@learnwidgiggs]

Using Sum() function

[@mangaldeep9544]

😃

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

[@beingrishi6450]

Demo Interview

[@sonuy5036]

What is the experience of candidate

[@learnwidgiggs]

3.5 yrs

[@sonuy5036]

Ohk n did she get placed

[@abhishekgour103]

bro issko hire karlo cute hai ladki

[@Ali-ds5iy]

jaan lay li larki ki

[@bandarusrinivasarao2857]

YOU KNOW😅😅😅

[@rahulwagh1678]

voice celerity is sooo poor

[@learnwidgiggs]

yeah, sorry for that, it somehow cracked.

[@bvinod8338]

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

[@gourabsjourney]

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

[@Jeet-_-]

😂😂

[@Jeet-_-]

😂😂😂