Access courses

Power Query Course

What will I learn?

Open di way for how you fit use your data full way wit our Power Query Lesson. We mek dis one special for people wey dey work wit Business Intelligence. You go learn how to change data, put dem in order, and bring dem togeda wit Excel. You go sabi make new columns wey you calculate, cut data and join dem back, and make data update automaticali. We go even dig inside di ting dem wey hard pass, like M Language and how to make query run fast. Wit dis lesson, you go learn how to use am for real life and do am di best way, so dat your data go correct and e no go change anyhow. Lift up your data analysis game today!

Apoia's Unique Features

Accessible online course for a lifetime
Certificate aligned with educational standards
Printable PDF summaries
Online support available at all times
Select and arrange the chapters you wish to study
Set your own course workload
Instant feedback on practical activities
Study anytime, no internet required

Develop skills

Enhance your practical skills in the areas listed below.

Sabi change data well well: Make new columns wey you calculate, cut data and join dem back like shea butter.

Put data in order: Group dem, count dem togeda, turn dem any way you want, and pick out only di ones wey you need so dat e go clear.

Bring am togeda wit Excel: Make data update automaticali and make report wey go open eye.

Fix problem fast fast: Solve any problem wey come and make sure data dey correct.

Make query run fast: Use M Language and make am work fast so dat e no go waste time.

Suggested summary

Workload: between 4 and 360 hours

Before starting, you can modify 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 equivalent to a technical, undergraduate, or postgraduate course, but it offers practical and relevant knowledge for your professional journey.