5 Best Practices in Power Query

In this video, we will learn about some best practices that can help us to be more efficient & smart working on Power Query!

Additionally Helpful Video Links:

Join this channel to get access to perks:

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[jimfitch]

Great tips! Thank you. Here is another suggestion for naming steps: Remove blanks & special characters that cause the step to be named #”Step Name” in the Advanced Editor. I find that the M code is much easier to read & maintain.

[shirleymoreman]

Love the "bin the red" - it's a great way to try to get rid of as much hard coding as possible. I also remove the spaces in step names - it makes them much easier to read in the M code. I didn't know about the QAT in Power Query! Great tip.

[grahamc]

To add multi line comments, start with /* and end with */ or use the shortcut key ALT + SHIFT + A

The shortcut key for single line comments is CTRL + /

[swilson]

So helpful! Especially re-naming steps. Don't know why I never thought to do this. Thanks!

[kishangzp]

All tips are great and practical and I reccomend everyone to watch this video... I would also like to recommend one very important best practice... do not overcomplicate your queries especially when dealing with large data as this can slo down response time significantly.. what is complex unfortunately you can learn this only thru experience

[ArmandoReportes]

I loved the column names tip. So easy and yet so helpful. Thanks.

[thebhaskarjoshi]

Great tips! Thank you. I always look forward to your new videos.

[bhaskaraggarwal]

Superb, as usual.✨Apart from your content, I would also like to appreciate your lighting. Very soothing.

[stephenkaras]

Great content! Also love your two interview videos with Chandoo and Matt Arlington. I feel they were ground breaking in that they presented a peek into the mind sets of two leaders within the power bi community. BTW you too are becoming one of the leaders 😊

[EricHartwigConsulting]

Very awesome video! I love it when a fellow Excel & Power Query enthusiast shares their best practices!
Thank you for creating/sharing this video!

[Locomaid]

Thank you! I wondered how I could add comments to the renamed steps. Now I know!

[fernandojara]

Gracias, ya estoy poniendo en practica tus "Best

[OmisileKehindeOlugbenga]

Thanks a lot for sharing. Always a great pleasure to listen to you teach these stuff. My PQuery skills have improved greatly since I started watching your videos.

[franciscom.paredesarias]

Thank you very much for these Tips that are really important to have everything more organized.

Greetings from Chile

[paspuggie]

Really liked the Expand Column names tip Goodly, will use that in my queries. As for Quick Access Toolbar, whenever I liaise with staff at work I consistently teach them about this tip and they should use it because that is one of the best shortcut tips ever !

[zahoorsarbandi]

The way you picked the column names.. that is really a catchy one.. Other techniques are also very useful. Thanks for all of your videos.

[semakoadovohekpe]

Thanks for these tips! Will also review videos on staging queries. 👍🏽👍🏽

[Rice]

Thanks for priceless tips!😊
I think commenting have to raise power query skills, but frequently there are a lot of tasks you have to finish "yesterday", so you just quickly finish one and switch to another.🤔

[SaladSharkGaming]

Love your content and really helping me get better at using Power Query!
I was wondering whether you have any content regarding working smarter when getting data from multiple sources and then my Queries panel has loads of Transform file from query folders for each import.
Such files as Sample file, parameter, transform file and transform sample file appear and I'm not quite sure if I can be smarter with how its all constructed.

Beginner trying to benefit from using Power Query

[databicep]

This is great way of presentation. I just started a channel focusing more on Data Analyst with advance excel... was looking for inspiration on how to present and I got here... :)