Access courses

Power Query Course

What will I learn?

Open up the full power of your data with our Power Query Training. This training is made special for people who work with Business Intelligence. You go learn how to change data, put it in good order, and bring it together with Excel. You go learn how to make new columns that calculate things, split and join data, and make the data refresh itself automatically. We go even look deep into things like M Language and how to make your queries run faster. With real examples and good ways of doing things, you go make sure your data is correct and the same all the time. Make your data analysis strong today!

Apoia's Unique Features

Online courses available for life
Certificate aligned with educational standards
Printable PDF summaries
24/7 online support
Select and arrange the chapters you want to study
Set your own course schedule
Instant feedback on practical activities
Study at your convenience, no internet needed

Develop skills

Enhance the practical skills listed below

Master how to change data: Make columns that calculate things, split data and join it together well-well.

Put data in good order: Group data, count it together, turn it this way and that way, and filter it to make it clear.

Excel and Power BI working together: Make data refresh itself and create reports that show you things clearly.

Fix problems good-good: Find common problems and make sure the data is correct.

Make queries run faster: Use M Language and make them work well so they don't take too long.

Suggested summary

Workload: between 4 and 360 hours

Before beginning, feel free to change the chapters and the workload.

  • Choose which chapter to start with
  • Add or remove chapters
  • Increase or decrease the course workload

Examples of chapters you can add

You will be able to generate more chapters like the examples below

This is a free course focused on personal and professional development. It is not akin to a technical, undergraduate, or postgraduate course, but offers practical and relevant knowledge for your professional journey.