Interview Preparation
Data Analytics Interview Questions and Answers for Freshers — 2026
These are the most commonly asked Data Analytics interview questions for freshers in 2026 — compiled by Vtricks faculty based on real interview feedback from students placed at companies like Accenture, Deloitte, Infosys, Wipro, Amazon, Flipkart in Bangalore.
There are currently 4,200+ active Data Analytics job openings in Bangalore. Freshers can expect ₹4.5–6.5 LPA at companies across Bangalore's tech corridor — Whitefield, Electronic City, Koramangala, and the CBD. Preparation matters: candidates who practise these questions consistently perform significantly better in technical rounds.
Interview Tips from Vtricks Faculty
- Always explain your reasoning process — interviewers want to see how you think, not just the final answer.
- Use real examples from projects you have worked on when answering scenario-based questions.
- If you don't know the answer, say so honestly and describe how you would find the answer — this is better than guessing.
- For Bangalore companies specifically: be ready to answer follow-up questions — they often go 2-3 levels deep on any concept.
- Always ask clarifying questions before answering complex scenario-based questions — this demonstrates professional problem-solving approach.
Easy — basic concept check
Medium — applied knowledge
All 20 Questions
Data Analytics Interview Questions — Freshers
Q1. What is Data Analytics and why is it important?
Conceptual
Easy
ANSWER
Data Analytics is the process of examining raw data to find patterns, draw conclusions, and support decision-making. It is important because businesses use data to understand customer behaviour, optimise operations, reduce costs, and predict future trends. Companies like Amazon and Flipkart use data analytics to personalise recommendations and improve supply chain efficiency.
Q2. What is the difference between Data Analytics, Data Science, and Business Intelligence?
Conceptual
Easy
ANSWER
Data Analytics focuses on analysing historical data to answer specific questions and identify trends. Data Science uses machine learning and statistical models to build predictive systems and discover new patterns. Business Intelligence is the process of collecting, integrating, and visualising business data using tools like Power BI and Tableau to help management make decisions. In practice, Data Analytics sits between BI and Data Science.
Q3. What are the 4 types of Data Analytics?
Conceptual
Easy
ANSWER
The 4 types are: Descriptive Analytics — what happened (sales reports, dashboards); Diagnostic Analytics — why it happened (root cause analysis); Predictive Analytics — what will happen (forecasting, ML models); Prescriptive Analytics — what should we do (optimisation recommendations). Most entry-level analyst roles focus on descriptive and diagnostic analytics.
Q4. What is the difference between structured and unstructured data?
Conceptual
Easy
ANSWER
Structured data is organised in rows and columns — like data in Excel spreadsheets or SQL databases. It is easy to query and analyse. Unstructured data has no fixed format — like emails, social media posts, images, and videos. Most real-world data (about 80%) is unstructured. Tools like Python's NLP libraries are used to process unstructured data.
Master These Questions
Practice Data Analytics with Live Mentors at Vtricks
500+ students placed · 87% placement rate · Starts at ₹35,000
Free Demo Class →
Q5. Explain what a SQL JOIN is and the types of JOINs.
Technical
Medium
ANSWER
A SQL JOIN combines rows from two or more tables based on a related column. The main types are: INNER JOIN — returns only matching rows from both tables; LEFT JOIN — returns all rows from the left table and matching rows from the right; RIGHT JOIN — opposite of LEFT JOIN; FULL OUTER JOIN — returns all rows from both tables with NULLs where there is no match; CROSS JOIN — returns all combinations of rows from both tables.
Q6. What is a Pivot Table in Excel and when do you use it?
Technical
Easy
ANSWER
A Pivot Table is an Excel feature that summarises large datasets by grouping and aggregating data. You use it to quickly calculate sums, averages, counts, and percentages across different categories. For example, you can use a Pivot Table to show total sales by region and product category from a dataset with 50,000 rows in seconds without writing any formulas.
Q7. What is the difference between COUNT, COUNT(*) and COUNT(DISTINCT) in SQL?
Technical
Medium
ANSWER
COUNT(column) counts all non-NULL values in a column. COUNT(*) counts all rows including those with NULL values. COUNT(DISTINCT column) counts only unique non-NULL values in a column. For example, if a customer table has 1000 rows with 800 unique customer IDs, COUNT(*) returns 1000, COUNT(customer_id) returns the number of non-null IDs, and COUNT(DISTINCT customer_id) returns 800.
Q8. What is the difference between VLOOKUP and INDEX MATCH in Excel?
Technical
Medium
ANSWER
VLOOKUP looks up a value in the first column of a range and returns a value from a specified column to the right. It only works left to right and breaks if you insert columns. INDEX MATCH is more flexible — INDEX returns a value from a range, MATCH finds the position of a value. INDEX MATCH works in any direction, handles column insertions, and is faster on large datasets. Most experienced analysts prefer INDEX MATCH over VLOOKUP.
Q9. What is the purpose of GROUP BY in SQL?
Technical
Medium
ANSWER
GROUP BY groups rows with the same values in specified columns and is used with aggregate functions like SUM, COUNT, AVG, MAX, and MIN. For example: SELECT region, SUM(sales) FROM orders GROUP BY region — this returns total sales for each region. GROUP BY is one of the most used clauses in analytical SQL queries.
Master These Questions
Practice Data Analytics with Live Mentors at Vtricks
500+ students placed · 87% placement rate · Starts at ₹35,000
Free Demo Class →
Q10. What is a KPI and how do you choose the right ones?
Conceptual
Easy
ANSWER
KPI stands for Key Performance Indicator — a measurable value that shows how effectively a company or team is achieving a business objective. To choose the right KPIs, they must be Specific, Measurable, Achievable, Relevant, and Time-bound (SMART). For example, for an e-commerce company, relevant KPIs include customer acquisition cost, conversion rate, cart abandonment rate, and monthly revenue growth.
Q11. What is data cleaning and what are common data quality issues?
Technical
Easy
ANSWER
Data cleaning is the process of fixing or removing incorrect, incomplete, duplicate, or irrelevant data. Common data quality issues include: missing values (NULLs), duplicate rows, inconsistent formatting (dates in different formats), outliers, incorrect data types, and whitespace errors. In Python, Pandas provides functions like dropna(), fillna(), drop_duplicates(), and str.strip() for cleaning data.
Q12. What is the difference between mean, median, and mode?
Conceptual
Easy
ANSWER
Mean is the average of all values — calculated by summing all values and dividing by count. It is affected by outliers. Median is the middle value when data is sorted — it is more robust to outliers. Mode is the most frequently occurring value. For example, in salary data where most employees earn ₹5L but the CEO earns ₹5Cr, the mean is distorted. The median gives a better picture of the typical salary.
Q13. What is Power BI and how is it different from Excel?
Technical
Easy
ANSWER
Power BI is Microsoft's business intelligence tool for creating interactive dashboards and reports from multiple data sources. Unlike Excel, Power BI handles much larger datasets, connects to live databases, supports real-time data refresh, and creates shareable interactive dashboards accessible via browser or mobile. Excel is better for ad-hoc analysis and small to medium datasets. Power BI is better for ongoing monitoring dashboards shared across an organisation.
Q14. What is an outlier and how do you handle it?
Technical
Medium
ANSWER
An outlier is a data point significantly different from other observations. It can be caused by data entry errors, measurement errors, or genuine extreme values. To handle outliers: first identify them using box plots, Z-score, or IQR method; then decide based on context — remove them if they are errors, cap them at percentiles (Winsorisation), or keep them if they represent real events. Never blindly remove outliers without understanding the business context.
Master These Questions
Practice Data Analytics with Live Mentors at Vtricks
500+ students placed · 87% placement rate · Starts at ₹35,000
Free Demo Class →
Q15. Explain the difference between a bar chart and a histogram.
Conceptual
Easy
ANSWER
A bar chart displays categorical data — each bar represents a category with its count or value, and bars are separated. A histogram displays the distribution of continuous numerical data — bars are adjacent with no gaps, and each bar represents a range (bin) of values. For example, a bar chart shows sales by product category. A histogram shows the distribution of customer ages across different age ranges.
Q16. What is Tableau and when would you use it over Power BI?
Technical
Easy
ANSWER
Tableau is a data visualisation tool known for its drag-and-drop interface and powerful visualisation capabilities. You would choose Tableau over Power BI when: you need more advanced and customised visualisations, your organisation uses non-Microsoft data sources, you need stronger geospatial analytics, or your team is not embedded in the Microsoft ecosystem. Power BI is generally preferred when the organisation already uses Microsoft products like Azure and Office 365.
Q17. What is a Null value and how do you handle it in SQL?
Technical
Easy
ANSWER
A NULL value in SQL represents missing or unknown data — it is not the same as zero or an empty string. To handle NULLs: use IS NULL or IS NOT NULL in WHERE clauses; use COALESCE(column, default_value) to replace NULLs with a default; use NULLIF(value1, value2) to return NULL when two values are equal; use COUNT(*) instead of COUNT(column) when you want to include NULL rows in counts.
Q18. What is correlation and does it imply causation?
Conceptual
Medium
ANSWER
Correlation measures the strength and direction of the linear relationship between two variables, ranging from -1 (perfect negative) to +1 (perfect positive). Correlation does NOT imply causation — two variables can be correlated without one causing the other. A classic example: ice cream sales and drowning rates are positively correlated, but ice cream does not cause drowning — both are driven by a third variable (hot weather). Always look for confounding variables before concluding causation.
Q19. What is the difference between a database and a data warehouse?
Conceptual
Medium
ANSWER
A database (OLTP — Online Transaction Processing) is designed for real-time transactional operations — inserting, updating, and deleting records. It is optimised for current data. A data warehouse (OLAP — Online Analytical Processing) is designed for analytical queries on large historical datasets. It stores integrated data from multiple sources, is read-optimised, and uses dimensional modelling (star schema, snowflake schema). Examples: MySQL is a database; Amazon Redshift, Google BigQuery are data warehouses.
Q20. Walk me through how you would approach a data analysis project from scratch.
Scenario
Medium
ANSWER
A structured approach: 1) Understand the business problem — what question are we answering? 2) Identify and collect data from relevant sources. 3) Explore the data — check shape, data types, missing values, distributions (EDA). 4) Clean the data — handle nulls, duplicates, outliers, formatting issues. 5) Analyse — apply statistical methods, build visualisations, identify patterns. 6) Interpret results — translate findings into business insights. 7) Communicate — create clear charts and a concise summary for stakeholders. 8) Recommend actions based on findings.
Company Insights
What Data Analytics Companies in Bangalore Actually Ask
Based on interview feedback from Vtricks students placed at Bangalore companies in 2026:
Round 1 — Written/Online Test
Most Bangalore companies start with a written or online test covering data analytics fundamentals, multiple choice questions on Excel and SQL, and basic problem-solving questions. Duration: 30–60 minutes. Companies like Accenture and Deloitte use platforms like HackerRank or their own internal assessments.
Round 2 — Technical Interview (Most Important)
This is where most candidates are filtered. Expect: direct questions from this list, hands-on tasks (write a SQL query, debug a piece of code, explain a dashboard you built), and scenario-based questions where you walk through how you would solve a real problem. Be prepared to share your screen and code live.
Round 3 — Managerial / HR Round
Focuses on: why you chose data analytics as a career, how you handle ambiguous requirements, a project you are proud of (have this ready in detail — situation, what you did, result), and salary expectations. Research the company's tech stack and recent news before this round.
Tools You Must Be Able to Demonstrate
- Excel — be ready to use this live in an interview
- SQL — be ready to use this live in an interview
- Python — be ready to use this live in an interview
- Power BI — be ready to use this live in an interview
- Tableau — be ready to use this live in an interview
More Resources
More Data Analytics Interview Preparation
Prepare for Your Data Analytics Interview at Vtricks
Our students practise all these questions with live mentors and get placed at top Bangalore companies. Join 500+ students already working in Data Analytics.
Mock interviews with mentors
Live daily classes
87% placement rate
Starts at ₹35,000
Book Free Demo Class at Vtricks →
Vijayanagar, Bangalore · Online also available · No payment required