- PowerBI Reports and Dashboard creation
- SSAS Tabular model - Experience in creating and deploying tabular models in SSAS
- SQL - Strong SQL skills for querying relational databases
- DAX - Handling many-to-many relationships, complex business logic, calculated tables to create intermediate data structure for calculations
- Data transformation using Power Query
- Data Modelling optimization - Reducing cardinality, summarized tables and DAX optimization