Develop Power BI datasets calculated measures and visualizations for business users.
Optimize Power BI reports using DAX performance tuning techniques.
Implement best practices for rowlevel security (RLS) and incremental refresh.
Refactor WebFocus reports into optimized SQLbased queries for Power BI.
Implement incremental data loading strategies for large datasets.
Design and implement star and snowflake schema models for Power BI reporting.
Implement slowly changing dimensions (SCDs) fact tables and aggregated views for efficient reporting.
Analyze existing WebFocus reports metadata layers and database interactions.
Migrate WebFocus reporting logic to DSS & Power BI using SQL and DAX/M for transformations.
Work with business analysts to map old WebFocus reports to new DSS models and Power BI dashboards.
Required Experience:
Senior IC