Hello and welcome to Curbal’s first course on Power Query!
I’ve been wanting to do this course for a long long time. I think Power Query is one of the most important tools or skills that you need to learn in the coming years. Why do I say that? Well Power Query is available now in Excel, in Power BI, in Analysis Services, you have it in PowerApps, in flow… Microsoft is putting Power Query everywhere! There are two reasons for that: it is that good, is an amazing tool and number two: it just makes your life easier.
- 57 video lessons
- 3 hours of short videos
- English captions on all lessons
- 23 downloadable resources
- Lifetime access
- Certification upon course completion
- Mobile Friendly
- Access to the Power BI High level introduction course included
- 3 preview lessons available
Who is this course for?
This course is for people that are beginners in Power Query and for those that have worked with Power Query for a while but would like to have a structured way of learning it. If you have been doing Power Query longer than that, you can still take the course because, you know me, I always put best practices there and some tips and tricks… is filled with that!
What are we going to cover?
Well it is packed, packed, packed with material. We’re going to do of course a round tour of Power Query and explain how everything works.
We’re going to go through get sources. We will go through how to connect to the most common sources. There are eleven lessons on that, so I think I’ve got to cover with most of them. Then we’re going to go through the most common transformations that you will do in Power Query, the ones that you have on the user interface where you click, click, click and then you have it. There are some buts and ifs and some mmm… I’ll go through that too, so you know what to expect when you’re clicking those buttons.
After that, we’re going to go through how to join tables: you have merge and you have append and I will go through both and we have great examples to do that. You will be able to follow along with the examples that I provide, you have all the material there for you to go along and do it with me.
Once we have done the join tables, well we’re going to go through the column transformations and the column transformations is such a great “advanced feature” because it allows you to make transformations that are fairly basic but there is no button for it, so it allows you to make Power Query to write code in a very simple way.
Once we’ve gone through the custom columns, I have to do this, I have to show you the best practices. These are habits that you need to implement every time you create a Power Query file. We will go through what those habits are and what they are good for.
Last but not least, we have a module on M. M is the language that is written behind the scenes when you are doing Power Query transformations and it’s an amazing skill to have. You don’t need to be an M master, to be able to know enough M to do amazing thing, but that is exactly what I’m going to show you. I’m going to show you what M is, I’m going to go through the basic workflow for M, so you get a feel for how that works and I’m going to bombard you with the examples: if you want to do this, this is how you do it in M and you’ll see how much faster and easier things get done. It will actually allow you to implement the best practice that I showed you faster. The hope for to me at creating that lesson, was that you shouldn’t be afraid of M, you shouldn’t be afraid of the advanced editor. Be curious! Go there and check and modify and see what happens…Hopefully slowly but surely, you will start learning M without even realizing it.
Those are the main topics. I really hope that you enjoy this course, it is available at curbal.com/courses-overview at the same place as the free course.
If you haven’t taken the free course do that, it is an introduction to Power BI and I really hope you enjoy it, I put my heart and soul on it! Looking forward your feedback and until then, take care!