What is a star schema, and why do BI tools tend to work well with it?

What the interviewer is looking for

• This question tests data modelling for analytics. Explains star schemas, grain and slowly changing dimensions, and designs models that keep history accurate.
• Strong answers: A central fact table linked to dimension tables, simpler filtering and faster aggregation, and clear relationships for the tool.
• Likely follow-up: What problems appear if you use one huge flat table instead?

Another way it may be asked: If you had sales, products, stores and dates, how would you arrange those tables for reporting, and why that way?

A structure to follow: Answer, explain, example, limits

1. Step 1

   Answer

   Give your direct answer in the first sentence so the interviewer knows where you are going.

2. Step 2

   Explain

   Say how it works or why you would do it that way, in plain words before jargon.

3. Step 3

   Example

   Anchor it in something you have actually done or seen, with the detail that shows hands-on experience.

4. Step 4

   Limits

   Say when your approach would not be the right one. It shows judgement.

This is guidance on shape, not a script. Use your own real experience and facts; never invent details to fill a gap. See the STAR guide and answer frameworks.

Common slips

• Reciting a definition without showing you have applied it.
• Using terms you cannot explain if asked a level deeper.
• Claiming experience beyond what you can discuss in detail.

How to practise it

Say the answer in 90 seconds, then answer the follow-up as if it were a new question.

Related questions

• How do you handle a salesperson moving to a new territory so that historical reports still show their past sales correctly?
• How would you write a query to find each customer's most recent order?
• A manager asks for a dashboard showing sales performance. What questions would you ask before building anything?
• Tell me about a report you built in Power BI, Tableau or a similar tool that you're proud of. What made it work for its users?
• Two dashboards show different revenue numbers for the same month. How do you track down why and fix it for good?

Browse all questions