Code documentation

Links to the documentation for the various programming languages involved in the systems we teach, plus a couple of other relevant sites on coding.

The main language for Power BI expressions. Also used in Power Pivot for Excel and Analysis Services.

Relatively straightforward to learn as it is based on the Excel function language.

The nasty case-sensitive language used by Microsoft’s ETL Power Query system.

Use Power Query point-and-click if you can, but if you must get your hands dirty with some ETL programming here is how to do it.

If you want documentation on Excel you probably need information about functions.

This link takes you one stage higher to the info on how formulas as a whole work, just in case you need that too.

The language used by the components of the Power Platform to communicate with each other: Power Apps, Power Automate and the Dataverse data repository.

PowerShell is the second generation upgrade of MSDOS.

If you need to use scripts to do small tasks like updating data sets, copying files from one folder to another and applying these ideas to your local machine, Azure and SQL, you need to know PowerShell.