Enterprise BI Solutions (Adventure Works Company)

Executed full-lifecycle development of an optimized multi-fact star/snowflake schema resolving mixed-granularity targets. Built robust ETL pipelines in Power Query, authored advanced DAX KPIs, and secured data using dynamic RLS (UPN). Engineered an executive-level UI/UX utilizing report bookmarks for view-switching, conditional color scales, and hidden detail pages for structured drillthrough workflows.

Used active and inactive relationships with DAX USERELATIONSHIP functions.