- Type Learning
- Level Advanced
- Time Weeks
- Cost Paid
Power BI & SQL- Gold
Issued by
Lumify Group
Holders of this badge have knowledge of DAX, including knowing row context, functions, calculated columns, measures and working with various data sources. Having an in-depth understanding of the DAX language endows holders with modelling abilities. In SQL, holders have sophisticated techniques for querying and reshaping result sets. They can reshape data, write complex queries, query hierarchal data, create table-valued functions, simplify querying, work with an Azure SQL, and write in T-SQL.
- Type Learning
- Level Advanced
- Time Weeks
- Cost Paid
Skills
- API Data Sources
- Contexts in Calculated Columns
- Control of Flow in SQL
- DAX – Contexts & Relationships
- DAX – Evaluation Contexts
- DAX – Measures and Filters
- DAX Optimisation
- DAX Performance
- DAX - Table Joins
- DAX – The CALCULATE function
- DAX – The FILTER function
- DAX – The Rules of Evaluation
- DAX Tools
- DAX – Variables
- Functions and FILTER
- More Complex Joins in SQL
- Nested Row Context
- Power BI Date Dimension
- Power BI Files in Folders
- Power BI Report Features
- Power Query M Formula Language
- Practical DAX
- Query Parameters
- Query Performance in SQL
- Ranking
- Reshaping data in SQL
- Row Contexts in Measures
- Row Level Security
- Simplifying Code Reuse
- Streaming Data Sources
- Table Functions
- User-Defined Functions in SQL
- Variables in SQL
- Writing More Complex Queries in SQL