Learn Power Query in just 45 mins | Power BI | Must Watch

This video will make you learn all the important transformations that we can perform in Power Query within Power BI Desktop and thus will enhance your knowledge as a Power BI developer.
Link to download sample files: drive.google.com/file/d/12Wh1...
☀ 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
#PowerQuery
#PowerBI
#LearnWidGiggs

[@learnwidgiggs]

Link to download the sample files for practice is there in description box. Please feel free to use it.

[@ganeshreddymotakatla6244]

@LearnWidGiggs Hi Bro, Thanks for your clear videos on interviews...I hve cleared my interview @PWC..thanks. Hope we can meet over in PWC communities/ teams

[@learnwidgiggs]

@@ganeshreddymotakatla6244 Glad to hear this news!

[@ganeshreddymotakatla6244]

@@learnwidgiggs 👍

[@sainathguthula981]

that link can not be dowland @learnwidgiggs

[@vaibhavitatekar4700]

Thank you for making this video on Power Query and explaining it in the most easiest way.

[@Shinde9755]

Hi Shashank. Thank you so much video of Power Query. Its Easy to understand

[@hairavyadav6579]

Best video to learn any thing in easy way

[@priyankathakur1691]

Thank u for creating such clean videos on Power Query, which is easily understood. Keep posting such informative videos on PBI projects as well.

[@learnwidgiggs]

Thank you, I will

[@mukulraj6184]

Thank you so much for the informative video. Well explained 👍👍

[@learnwidgiggs]

Glad it was helpful!

[@jaypandey4101]

Great video, right to the important points. Please do upload mores stuff like this. Thank you.

[@learnwidgiggs]

Welcome 🙂

[@raghibelahi937]

Thank you so much for explaining complex queries and transformations with ease..Great👏

[@learnwidgiggs]

My pleasure 😊

[@jagadishreddy9140]

Thanks for your efforts and for making this video. Very Informative Video this is.

[@learnwidgiggs]

Welcome 🙂

[@venkatasireeshamarella5677]

Really very good and informative vedio with clear explanation nd less time 🤩 .... Thank you 😊

[@learnwidgiggs]

Most welcome 😊

[@GAMERX-vk6fc]

bhai you earned a subscriber. thanks a lot for this video.

[@mahfoudhcheikhna2754]

Excellent video

[@sanyarastogi9205]

Thank you so much Sir for this informative video. Learned a lot about different transformations used in Power Query and practiced alongside. Keep sharing such videos.

[@learnwidgiggs]

You are most welcome!

[@rupeshsurve6088]

Great video and good explanation. Thanks for your efforts.

[@learnwidgiggs]

Welcome 🙂

[@RaMeShBaBu-gf1wc]

This is the best video of power query transformation

[@learnwidgiggs]

Thank you..share it with your friends too 🙂

[@sreemalapal]

Super helpful video...Great explanation!!

[@learnwidgiggs]

Glad you think so!

[@perfectionist6624]

Hi sir, Can u plz make full video on where to use Calculated columns in & when to use Measures in real projects. Like give examples where we need mandatorily required to create Calc column in model and measures examples which can replace creating Calclated columns. Plz make this with one example for each to clear understanding. Thanks in advance.

[@praveenkumar_0143]

Covered important topics and practiced along with you!! Very Useful video

[@learnwidgiggs]

Glad it was helpful!

[@sambhajizambre9650]

thanks for making this video .Nice explanation and all things really needful

[@learnwidgiggs]

Glad it was helpful!

[@AkankshaSingh-mg1vr]

Great video indeed, learning many new things 👍🏻

[@learnwidgiggs]

Welcome 🙂

[@user-zu5wy1wu7m]

grate thank you 👏👏👏👏👏

[@shivangisrivastav3336]

Best❤

[@sandeepghatge7859]

It will help us a lot. Thank you

[@learnwidgiggs]

Welcome 🙂

[@deepmathur6390]

informative video brother..... thanks for your efforts

[@learnwidgiggs]

Welcome 🙂

[@ajaykumar-ye8cv]

Thanks for your efforts and it is very useful

[@learnwidgiggs]

Welcome 🙂

[@manjupreetham]

Thank you so much your explanation is nice 👌

[@learnwidgiggs]

Thank you 🙂

[@Aestheticdeeps]

thank you soo much sir clearly explained😇

[@learnwidgiggs]

Most welcome 😊

[@tinnymanmeet]

Good and quick explanation.

[@learnwidgiggs]

Thank you 🙂

[@ravitejadatta7862]

simply superb sir

[@learnwidgiggs]

Thank you 🙂

[@KaleemUllah-qi7hf]

I learnt many things

[@sanket565]

Really helpful video 👌

[@learnwidgiggs]

Thank you 🙂

[@rajatdixit11]

Very informative video 😊🙏

[@learnwidgiggs]

Thank you rajat 🙂

[@krishnamagdum6496]

Very helpfull sir...thanks

[@learnwidgiggs]

Welcome 🙂

[@srinuguntaka4341]

This content is very useful to us ,thanks a lot.

[@learnwidgiggs]

Glad to hear that!

[@srinuguntaka4341]

@@learnwidgiggs Can you please do the complete DAX tutorial ASAP.

[@SanthoshkumarSenthilmurugan]

Absolute basics

[@subhranilmajumder2938]

U have changed the data type in customer3 instead of customer1 to show refference,although the explanation is pretty good to understand. Please watch it from 5:01 time of this video for better understanding.

[@learnwidgiggs]

Okay, thanks for pointing it out

[@shilpishukla8706]

thanks

[@syedmohammedidris5605]

Super

[@nishthatank5954]

Great content sir

[@learnwidgiggs]

Thank you 😊

[@perfectionist6624]

Thanks sir ❤

[@learnwidgiggs]

Welcome 🙂

[@ReshmaShaik-vt4wb]

Thank you sir

[@learnwidgiggs]

Welcome

[@divyachamakuri769]

Excellent ❤️

[@learnwidgiggs]

Thank you 🙂

[@divyachamakuri769]

@@learnwidgiggs can you make videos on pivot, view, services aswell

[@avinashsomesula4166]

thank you

[@learnwidgiggs]

Welcome 🙂

[@user-yq4ed3dq2q]

Sir please make one shot video on dax function

[@vaijayantigulve4883]

very useful content. But kindly zoom-in your screen or increase the font size. Thank you.

[@learnwidgiggs]

Sure, thanks for the feedback

[@santoshwaghmare4081]

Please bring the advanced transformation video of part 2🙏

[@learnwidgiggs]

Will plan 👍

[@sanket565]

I have a querry. If we create a reference table and then make changes to master table..but disable load. Will our reference table be affected?

[@learnwidgiggs]

I think it will be affected because disable load would come into effect once we do close n apply..not before that.

[@enjystory464]

Sir if data is in sales then same customer buys 2 time ,1st time phone and 2nd time earphone so then we have to delete the duplicates?

[@learnwidgiggs]

No, why will you delete

[@enjystory464]

@@learnwidgiggs u said in video that first trim the data and delete the duplicates these are must do when you r working in power bi like that u said sir

[@Nani-et7gk]

Hi, I'm not able to view/open the .rar sample file from drive. Can you please advise how to do ? Thanks!

[@learnwidgiggs]

Download and then right click extract it.

[@perfectionist6624]

Hi sir can u plz make similar type of full video for Data Modelling In Power BI...

[@learnwidgiggs]

Will do a video on this soon.

[@aparnavenkataraaman8804]

Hi Sir, i got an interview question on calculated columns. I am in beginner level. Hence i am asking such question. We have table with one column and column consists of 1 lakh rows with numbers. Interviewer asked me to display odd and even numbers form that column. Can you please explain me how to do that

[@learnwidgiggs]

Use Conditional column feature

[@meghab2910]

What is the difference between Left join and left anti?

[@learnwidgiggs]

Left join - All the matching records + Left records in left table Left Anti - All the non-matching records in the left table

[@gsreenivasulu3246]

Please provide the dataset that will be help full, other wise it doesn't make sense

[@learnwidgiggs]

The link to download the sample files is there in description box. Please use it for practice.

[@bhargavibharu5883]

Hi I am from Non It background I. Have learned power bi and SQL. can I get job on powerbi as fresher.. how can I approach the companies who take me as a fresher..

[@learnwidgiggs]

Yes you can get the job as a fresher. You need to apply extra efforts than other people, you have to make online presence on linkedin.

[@learnwidgiggs]

If want to discuss things in detail, then plz book 1:1 session on Topmate.(link in About section of the channel)

[@LakshmiNarayana-rm4oq]

Can you do video on power pivot module

[@learnwidgiggs]

ok, I will do a video soon.

[@krisy8434]

in Merge if there are no common columns to join, then ?

[@learnwidgiggs]

Then you can't merge.

[@krisy8434]

@@learnwidgiggs okay but can we do it with custom column

[@learnwidgiggs]

@@krisy8434 yess if you somehow create one.

[@NitinSharma-sr5rn]

Its only basic in power query not advance

[@danielessiet4063]

Do you have a personal website?

[@learnwidgiggs]

Not yet!

[@vikkyghale4311]

do i need to be an expert in power query M?

[@learnwidgiggs]

No, basic understanding would also work.

[@perfectionist6624]

Please provide sample dataset

[@learnwidgiggs]

The link to download the sample files is there in description box. Please use it for practice.

[@perfectionist6624]

@@learnwidgiggs thanks

[@vjyrml]

Try to work on larger data, the data you taken is very few rows

[@learnwidgiggs]

noted, thank you

[@lakshmipriyachandra5604]

Found the best video for beginner stage thank you @learnwidgiggs

[@learnwidgiggs]

Glad to hear this!

[@Peaceful_World130]

Thanks sir

[@learnwidgiggs]

Welcome 🙂

[@anupmishra154]

Hi sir, Can u plz make full video on where to use Calculated columns in & when to use Measures in real projects. Like give examples where we need mandatorily required to create Calc column in model and measures examples which can replace creating Calclated columns. Plz make this with one example for each to clear understanding. Thanks in advance.

[@learnwidgiggs]

Noted

[@syedmohammedidris5605]

Super

[@learnwidgiggs]

Thanks 😊

[@SaiKumar-eo1ql]

Thanks sir

[@learnwidgiggs]

Welcome 🙂