Proficiency in concepts of base measures, calculated measures, role-playing dimensions, slowly changing dimensions etc.. and their application in a business contex.
Ability to work with business users and architect data based on Kimball's principles of fact-dimensional modeling
Design SSAS self-service Multidimensional and/or Tabular cubes on top of fact-dimension model, and utilize reporting and visualization tools like SSRS and Power BI for automated reports processing
Well versed with aggregations and partitions and understands pros and cons of these techniques for Cubes performance tuning