Get startedGet started for free

Congratulations!

1. Congratulations!

Awesome job on finishing this course!

2. Here's what you learned

You learned a lot about transforming your data using Power Query. In chapter 1, you used Power Query to reshape and aggregate data, and how you can pivot and unpivot tables. Chapter 2 was about combining data: appending data (adding tables horizontally) and merging data (by using different kind of joins). In chapter 3, you've seen that custom columns are a flexible tool to modify your tables almost like an Excel sheet. The fourth and final chapter focused on the backbone of Power Query: the Advanced Editor. You were introduced to M language to create different data structures. This is pretty advanced stuff, so well done!

3. See you in the next course!

We invite you to try our other Power BI courses, or that you take one of the case studies to apply your skills! We hope that you enjoyed this course, and look forward to see you using Power BI in the future!