Beskrivning
Audience
This training is targeted for Data professionals such as data Stewards, or Power users that are looking to design their own Power BI solutions. In other words, this course will take the Self- Service-Business- Intelligence (SSBI) concept to its edge.
Prerequisites
- Knowledge of how to create content using Power BI Desktop.
- Basic understanding of data warehouse schemas and ETL/ELT operations
Course Topics
- What is Power Query
- How Power BI Handles your Data
- Query Editor Best Practices
- Preparing Data
- Shape and Clean your Data
- Understanding Errors
- Understanding Parameters
- Understanding Template Files
- Getting Data
- Keeping data current in Power BI
- Integration with Various Azure Services
- Text Transformations
- Numeric Transformations
- Structured Column Transformations
- Add Column Transformations
- Error Handling
- Date and Time Transformations
- Understanding M Code
- Introducing the Power Query M Formula Language
- Working with M Data Structures
- Advanced M Scripting
- Dynamic Parameters in Power Query
- Introducing Functions Main Concepts
- Using Power Query Functions
- Creating Custom Functions
- Creating Parameterized Functions
- Designing with Function Queries
- Performance Tips and Tricks for Power Query
Kursen levereras i samarbete med
Recensioner
Det finns inga recensioner än.