Home/Interview prep/Data Analytics with AI: Excel, SQL, Power BI & Python

Walk into the interview already prepared.

Timed mock tests and model answers written by working engineers, for every level from fresher to lead. Pick any of our 75 courses below.

Topic: Data Analytics & BI (Excel, SQL, Power BI, Tableau). Questions are shared by related courses. View the Data Analytics with AI: Excel, SQL, Power BI & Python course → · Follow the Data Engineer roadmap and salary guide →

All Data Analytics with AI: Excel, SQL, Power BI & Python interview questions at a glance+

Fresher (0–3 years): Data Analyst (Junior)

  1. Write a query for the top 5 customers by total sales.
  2. How do you design a good dashboard?
  3. Walk me through an analysis you did from question to insight.
  4. Which join returns only matching rows from both tables?
  5. Which clause filters groups after aggregation?
  6. Which Excel function looks up a value and returns a matching value, replacing VLOOKUP?
  7. Which Excel feature summarises large data by category quickly?
  8. Which chart best shows a trend over time?
  9. The median is preferred over the mean when…
  10. In Power BI, DAX is used to…
  11. COUNT(DISTINCT customer_id) returns…

Mid-level (3–8 years): Data Analyst / BI Developer

  1. A Power BI report is slow. How do you speed it up?
  2. Sales dropped 15% this month. How do you investigate?
  3. How do you ensure the numbers in your reports are trusted?
  4. Which window function gives each row a rank within a partition?
  5. Running total of sales by date uses…
  6. A star schema has…
  7. In DAX, CALCULATE is used to…
  8. An A/B test result with p = 0.03 at a 5% threshold means…
  9. Power Query in Excel/Power BI is mainly for…

Experienced (8–15 years): Senior Analyst / Analytics Lead

  1. How do you build a data-driven culture?
  2. Design the analytics stack for a growing company.
  3. How do you prioritise analytics requests from many teams?
  4. A semantic layer / certified dataset helps…
  5. Correlation between two metrics proves…
  6. Row-level security in Power BI is used to…
  7. Best way to handle slowly changing customer attributes historically?
  8. North-star metric means…
  9. Self-service BI succeeds when…