Advanced Power Query Case Study 🔴 (with downloadable files)

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!

[christinelowery]

I think you have no worries for live events. Great job! Love your videos. You are very talented and helpful.

[naimishsiddhpura]

Your small video where your face is displayed covers the Steps window, it is hard to know/understand into which step, what edits you are doing?

[mannyjubran]

You are the best of the best in Explaining complex issues. I wish you best of success.

[vipulraf]

You are the best of the best in Explaining complex issues. I wish you best of success.

[lionels]

I believe the perfect universal course would be about data modelling including both M and Dax codes as you said (with a dynamic focus as you showed today). Something with a up to bottom logic: Dashboard => pivot tables => power pivot (dimension and fact table design, measures) and power query light and dynamic transformations with big data and non-financial examples(as the one I sent you ;)

[KuldeepSingh-nqvi]

Wow Chandeep You are Super awesome, I have not seen such stuff on any other Channel, please keep it up..
Thank You So much again..

[crutz]

Nice video Chandeep! Perfect timing for what I'm doing at work where I made a table mapping and doing the renames like you did for status reports we get from different suppliers and transform them to a ready-for-import format into our system. I have 3 types of columns to process, 1) direct mapping/renamed columns, 2) hardcoded value/constants not in the supplier data, and 3) derived value where I had to concatenate different columns from the supplier first as the value to one of the columns to be imported. Been learning a lot from your channel! Thanks so much!

[Viola]

Astonishing logic path. It's like getting puzzle pieces together. Thank you very much. You're great.

[joelabacherli]

This is brilliant. Yet another example of how to make the query dynamic. I am so grateful to have such a great reservoir of knowledge from you. Thanks again for the great content.

[dabrain]

That was a really cool data cleaning case. At first, I thought, the tables need to be treated separately. Magic solution :-)

[manphu]

Great demo and extensive knowledge of Power Query, can you please advise how to open other excel file/New while at Power Query editor of an existing Excel file? Thanks

[ngocnguyen]

Thanks so much for useful video.
If my file has some null columns inside the table. and the header has some merge column. So, is there any way to handle it?

[raitup]

The definition of a Master Class. Amazing video!!! Directly to my library

[profcor]

Thank you for clear explanation. I learn something every time. Greatings from the Netherlands

[brianmullins]

Chandeep, just found you. Excellent presentations. I'm eager to see more!

[manideepak]

Can you make a vedio on loop in power query
Along with list.generate

[kaushikgohil]

Hi sir, I regularly watch power query videos and it changed the way i see the new task to perform, thank you for sharing useful tricks and magic in power query.

[seamushand]

This is so very much a real case study. Thanks for being real in the problems you have selected and solved.

[Erika-tbkd]

Wow. I've learnt so much from this live. Thank you so MUCH __ from UK.

[Maartenmarsje]

Thanks for sharing your great knowlesge in M and letting me learn so much each video. Great fan!