Data Analytics (Excel, SQL & Power BI) interview questions and answers
The most frequently asked Data Analytics (Excel, SQL & Power BI) interview questions, with simple answers to help you revise before your interview.
01What is the difference between data analytics and data science?
Data analytics focuses on analysing existing data to answer business questions and create reports. Data science also builds predictive models using machine learning.
02What is the difference between WHERE and HAVING in SQL?
WHERE filters rows before grouping. HAVING filters groups after aggregation with GROUP BY.
03What is a pivot table?
A pivot table summarises large datasets by grouping and aggregating values, letting you analyse data from different perspectives quickly.
04What is DAX in Power BI?
DAX (Data Analysis Expressions) is a formula language used in Power BI to create calculated columns, measures and custom aggregations.
05What are KPIs?
Key Performance Indicators are measurable values that show how effectively a business is achieving its objectives, such as revenue growth or customer retention rate.
Want complete interview preparation?
Our Data Analytics (Excel, SQL & Power BI) course includes real-time projects, mock interviews, resume building and placement support.