SSAS Tabular and Power BI Interview Template

The document available for download below contains 74 SSAS Tabular and Power BI job interview questions and supporting answers (with probing questions) across the following five topics:

  • Data Modeling (33)
  • DAX (10)
  • Power Query/Query Editor (9)
  • Power BI Report Authoring (11)
  • Power BI Service and Collaboration (11)

Power BI and SSAS Tabular Interview Template

The topics and questions are diverse enough to support multiple interview scenarios – an initial phone screen for a Power BI developer or a more senior technical lead role for designing large SSAS models. The questions to select and level of depth required of course varies by team and project scenario. (Is the organization or project just getting started with Power BI or is there already a large, complex deployment? Does the team or project have certain knowledge gaps the position needs to fill or experience in a particular topic that can offset a candidates’ weakness?)

I’ll plan to update this document later this year to incorporate Azure Analysis Services, Power BI On-Premises, and all the new Power BI authoring and collaboration features that will be added throughout 2017.

Feel welcome to provide feedback on questions or concepts you believe should be included or any ‘issues’ you have with the template generally. Maybe over time I’ll incorporate SSRS, SSIS, and SQL Server as of course these tools are also often relevant for SSAS Tabular and Power BI job roles.



      1. I’m kind of behind on schedule on this…sorry.
        The CTP 1.0 version of Analysis Services 2018 (1600 CL?) will probably be released over the next few months. Certain features will be exposed to Power BI Desktop and Power BI Premium in Q3, I believe. Anyway, this badly needs to be updated so I’ll try to circle back to this at some point.


    1. Thanks Amit. There are a number of past blog posts I’d like to update or improve at some point. I recently completed a similar document to support Power BI interviews so I may share that or some version later this year.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s