Training Trains logo

Business Intelligence Internship Interview Questions for Freshers (with Answers)

By K. Boopathikumar, CEO & Founder · 16 November 2026 · 7 min read

BI interns turn company data into reports people use every day. Interviews focus on data modelling, Power BI or Tableau skills, and whether your dashboards answer real business questions.

Modelling

  • What is a star schema and why does Power BI like it? A central fact table linked to dimension tables. It makes filters flow simply, keeps measures fast and avoids confusing many-to-many paths.
  • What is relationship cardinality? How rows match between tables: one-to-many is normal (one customer, many orders); many-to-many needs care.
  • Why use a date table? A proper calendar table enables time intelligence such as year-to-date and same period last year.
  • Import vs DirectQuery? Import copies data into the model for speed; DirectQuery queries the source live, useful for very large or real-time data but slower.

DAX and Power Query

  • Calculated column vs measure? A calculated column is computed per row and stored; a measure is computed on the fly for the current filter. Prefer measures for totals.
  • What does CALCULATE do? Evaluates an expression under modified filters, for example sales for one region regardless of the slicer.
  • What is filter context? The set of filters (slicers, rows, columns) that apply when a measure is calculated.
  • What is Power Query used for? Cleaning and shaping data before it loads: removing columns, fixing types, merging and unpivoting.

Reports and governance

  • What makes a good KPI? Clear definition, owner, target and time period, and it drives a decision.
  • What is row-level security? Rules that limit which rows each user sees, such as a regional manager seeing only their region.
  • How do you design a dashboard page? Top: the few KPIs; middle: trends; bottom: details. Consistent colours, few visuals, clear titles.
  • How do you make reports fast? Remove unused columns, use a star schema, prefer measures, reduce visuals per page and avoid heavy DAX iterators on big tables.

How to answer well in the interview

  • Show a dashboard and explain who uses it and for what decision.
  • Be ready to write CALCULATE and a time-intelligence measure.
  • Talk about checking numbers against the source system.
  • Mention refresh schedules and data gateways if you used them.

Next steps

Looking for an internship near Erode?

10 days to 6 months, online or at our Erode and Perundurai branches, with a verifiable certificate.

See internships →

More guides