- Type Learning
- Level Foundational
- Time Weeks
- Cost Paid
Power BI & SQL - Bronze
Issued by
Lumify Group
Those who hold the bronze PBI + SQL badge know how to manipulate data and enrich data models to produce powerful interactive dashboards, as well as knowing how to create custom reports and analyse data. They also know about data transformations, measures, DAX, row level security, Power Query and advanced visualisations. In SQL, holders know the basics of relational databases and how to run queries from the Azure portal and from Azure Data Studio.
- Type Learning
- Level Foundational
- Time Weeks
- Cost Paid
Skills
- Access Data from Multiple Tables in SQL
- Append and Merge Queries
- Basics of Queries in SQL
- Basic Understanding of Power BI DAX
- Column Transformations
- Combining multiple SELECT Results in SQL
- Creating Power BI Dashboards
- Data Modelling
- Data Normalization
- Data Transformation
- Filtering Data with a WHERE Clause
- Filtering on Aggregated Values in SQL
- Group Query Results in SQL
- Load Data
- Ordering Query Results
- Power BI Advanced Visualisations
- Power BI Custom Visuals
- Power BI Quick Measures
- Power BI Spatial Visuals
- Power BI Visualisations
- Publishing with Power BI
- Secure and Share Data in Power BI
- Share Power BI Reports
- Understand of Relational Databases
- Unpivot Data
- Using Power Query
- Working in Azure
- Working with Filters in Power BI