Power BI
- SQL Foundations: Managing relational data sets with comprehensive DDL, DML, and DQL scripting, alongside advanced database window functions.
Data Modeling & Design: Designing optimized relational star-schemas utilizing distinct dimensional tables and transactional fact tables.
Visual Optimization: Authoring complex DAX measures, building interactive dashboard matrices, and deploying secure parameterized workspaces within the Power BI Service.