SSAS Developer Interview Questions
There 5 key areas to test:
1. Cube design: the stages of creating a cube in BIDS, i.e. data source, DSV, dimension, cube.
2. Performance tuning: troubleshooting query performance as well as processing performance.
3. MDX: the multi dimensional expression that we all love.
4. Client tools: creating reports and dashboards on Strategy Companion, Excel, Tableau, Panorama, etc.
5. Administration: installing and upgrading SSAS servers, configuring SSAS server settings, security, processing, deployment, migration, backing up and restoring the cubes.
Tags: interview