- Type Learning
- Level Intermediate
- Time Weeks
- Cost Paid
Power BI & SQL - Silver
Issued by
Lumify Group
Badge holders can manipulate data and data models from many sources to create intelligent and interactive dashboards. They understand data transformations, measures, row level security, Power Query, creating advanced visualisations, row context, functions, calculated columns, and measures. Holders have an understanding of the theory of DAX. In SQL, students can work with many types of functions and expressions, use subqueries views when querying and can also create user-defined functions.
- Type Learning
- Level Intermediate
- Time Weeks
- Cost Paid
Skills
- Aggregate Functions and Group By Extensions in SQL
- API Data Sources
- Append and Merge Queries
- Column Transformations
- Data Modelling
- Data Normalization
- Data Transformation
- Data Types in SQL
- Date and Time Functions in SQL
- DAX – Contexts & Relationships
- DAX – Evaluation Contexts
- DAX – Measures and Filters
- DAX – The CALCULATE function
- DAX – The FILTER function
- DAX – The Rules of Evaluation
- DAX – Variables
- Functions in T-SQL
- Improving Query Performance in SQL
- Load Data
- Logical Functions in SQL
- Mathematical Functions in SQL
- Power BI Advanced Visualisations
- Power BI Date Dimension
- Power BI DAX
- Power BI Files in Folders
- Power BI Quick Measures
- Power BI Report Features
- Power Query
- Power Query M Formula Language
- Query Parameters
- Ranking Functions in SQL
- Row Level Security
- Secure and Share Data in Power BI
- Streaming Data Sources
- String Functions in SQL
- Unpivot Data
- User-Defined Functions in SQL
- Window Functions in SQL
- Writing More Complex Queries in SQL