Must Have Technical/Functional Skills
Primary: PowerBI (DAX Power query Data Modeling) IBM Cognos Analytics (Reports Dashboards Framework Manager SDK / Metadata Extraction)
Secondary: SQL (Oracle/SQL Server) Python Data warehousing concepts Databricks Azure Cloud
Certification: PL 300 - Power BI Data Analyst Associate
Proven experience in migrating reports from Cognos to Power BI
Roles & Responsibilities
End-to-End BI Solution Design (PowerBI Cognos Data Model DAX)
Data Integration & Optimization (Integrate data from multiple sources fine tuning)
Analyze existing Cognos reports Packages and data models
Map Cognos FM models to Power BI semantic models
Rebuild Cognos reports and dashboard in Power BI with same functionality
Validate data accuracy by reconciling Cognos vs Power BI outputs
Optimize Power BI reports for performance security and usability
Performance optimization of large datasets
Create equivalent unsupported Cognos functionalities/features in Power BI