The exploitation of the data requires the definition of transformation processes that ensure its quality, both from the point of view of Business Intelligence and from the point of view of predictive analysis -application of Machine Learning algorithms-. Power BI, the market leader in self-service BI tools, implements a language -the M language- for the definition of these processes. M is a functional language, not particularly complex but very powerful, that is often unknown or underused by Power BI users.
In this course we will review its syntax, we will learn to use some of the most useful M functions (among the more than 800 that make up the language) and we will apply it in practical scenarios.
For the correct follow-up of this course, attendees must have at least a basic knowledge of Power BI.
Content:
- ETL processes
- Presentation
- The M language
- Writing M code
- Structure of an M query
- Steps in the ETL process
- Step formula evaluation
- Expressions and values
- Primitive types
- Comments
- Features
- Standard features
- The each keyword
- Applications
