Data analyst interview questions for freshers: what to expect in Kerala
Data analyst interview questions for freshers are far more predictable than most candidates in Kerala expect. Whether the employer is a Technopark services firm in Trivandrum, a product company at Infopark in Kochi or a Bengaluru startup hiring remotely, the technical rounds keep returning to the same dozen ideas in SQL, Excel, Power BI and basic statistics. If you can answer those clearly and back each one with an example from your own project, you are ahead of most of the field.
Thinking of starting? See the Data Analytics course page.
This guide gives you the 12 questions that appear most often, a short model answer for each, and the reasoning behind the answer so you can handle follow-up questions. It also covers how the rounds are structured, how to present a portfolio project, and a short preparation plan for the two or three weeks before your first interview.
How a fresher data analyst interview is structured
Quick answer: Most fresher data analyst interviews have three or four rounds: a timed technical test on Excel or SQL, a case or scenario question, a project walk-through with a senior analyst, and an HR round on salary, location and notice period.
The order varies, but the pattern is consistent across Kerala employers:
- Screening test. Usually online and timed. Expect a few SQL queries on a small dataset, an Excel sheet to clean or summarise, and sometimes a short aptitude section. Large employers use this round to cut the list before anyone speaks to you.
- Technical interview. A working analyst asks the conceptual questions in this guide and may give you a laptop to write a query or build a quick pivot table.
- Case or project discussion. You are given a business scenario, or asked to walk through your own portfolio project, and the interviewer watches how you think.
- HR round. Communication, willingness to relocate to Kochi, Trivandrum or Bengaluru, shift flexibility and expected salary.
Notice that only one of those rounds is about definitions. The rest test whether you can apply the tools to a real question, which is why practising on datasets matters more than reading notes.
SQL interview questions for data analyst freshers
Quick answer: SQL is the most tested skill in fresher data analyst interviews. The four questions below cover joins, filtering groups, ranking and window functions, and together they account for most of what you will be asked.
- What is the difference between INNER JOIN and LEFT JOIN? INNER JOIN keeps only rows that match in both tables. LEFT JOIN keeps all rows from the left table and fills missing matches from the right table with NULL. Example: joining customers to orders with a LEFT JOIN shows customers who have never ordered, which an INNER JOIN would hide.
- WHERE vs HAVING? WHERE filters individual rows before grouping. HAVING filters groups after aggregation. If you want districts with more than 100 orders, the count only exists after GROUP BY, so the condition belongs in HAVING.
- How do you find the second-highest salary? Use DENSE_RANK() in a window function and pick rank 2, or use MAX() with a subquery that excludes the overall maximum. Mention that DENSE_RANK handles ties cleanly, which is usually the follow-up.
- What is a window function? A calculation across a set of related rows that does not collapse them into one row, such as a running total with SUM() OVER (ORDER BY date) or a rank within each region with PARTITION BY. Interviewers like this question because it separates candidates who have only used GROUP BY from those who have worked with real reporting queries.
If any of these feel shaky, the SQL for data analysis guide covers the small subset of SQL that analysts use every day.
Excel interview questions for freshers
Quick answer: Excel questions check whether you can look up, summarise and clean data without breaking it. The three most common are VLOOKUP versus XLOOKUP, when to use a pivot table, and how to remove duplicates safely.
- VLOOKUP vs XLOOKUP? XLOOKUP can look to the left of the key column, returns an exact match by default, and lets you set a value for missing matches instead of showing an error. VLOOKUP only looks right, defaults to approximate match, and breaks when columns are inserted. If the employer still uses older Excel, say you know both.
- When would you use a pivot table? To summarise a large table by category quickly, such as sales by district and month, or complaints by product and week. Add that you would use it for a first look at the data before deciding what to analyse further.
- How do you remove duplicates safely? Copy the data to a new sheet first, decide which columns define a true duplicate, then use Remove Duplicates on those key columns only. Removing on all columns can miss rows that differ in a trailing space or date format, so trim and standardise first.
Many Kerala offices still run reporting entirely in Excel, so a fresher who is fast and careful in it is immediately useful, even before SQL and Power BI come into play.
Power BI interview questions for data analyst freshers
Quick answer: Power BI questions focus on the data model and DAX. Expect to explain calculated columns versus measures, what a star schema is, and what CALCULATE does, because those three ideas underpin every working dashboard.
- Calculated column vs measure? A calculated column is computed when the data loads and stored row by row, so it takes memory and does not change with slicers. A measure is calculated at query time and responds to the filter context of the visual, which is why totals, ratios and year-to-date numbers are written as measures.
- What is a star schema? One fact table, such as sales transactions, linked to dimension tables such as date, product, customer and region. It keeps relationships simple, makes DAX behave predictably and performs better than one wide flat table.
- What does CALCULATE do? It evaluates an expression under a changed filter context. For example, CALCULATE of total sales with a filter on the previous year gives last year's sales for comparison, regardless of what the user has selected on the page.
Interviewers often follow up by asking you to open one of your own dashboards and explain a measure. Have one ready. The Power BI module in the Cokonet programme ends with a dashboard you can present; you can see how it fits with the rest of the syllabus at Cokonet Academy or compare it against all courses.
Statistics and case questions
Quick answer: Statistics questions for freshers stay basic: mean versus median, what an outlier is, and how to read a trend. Case questions test structure, and the most common one is some version of "sales dropped last month, how would you investigate?"
- Mean vs median? The mean is the arithmetic average and moves with extreme values. The median is the middle value and resists outliers, so it is the better summary for salaries, house prices or order values where a few large numbers would distort the average.
- Sales dropped 20% last month. How would you investigate? Check data quality first: was the month fully loaded, did a store or channel stop reporting, did a product code change? Then break the drop down by region, product, channel and customer segment to see whether it is broad or concentrated in one place. Finally compare against the same month last year to rule out seasonality, and state what you would check next.
With case questions, the interviewer is not looking for the right answer. They want to see that you start with the data pipeline, split the problem into parts, and keep talking in a structured way instead of guessing a cause.
How to present your project, and a short preparation plan
Quick answer: Explain any project in four parts: the business question, the data, what you did, and the result with one number. Then spend two to three weeks before interviews on SQL practice, one timed Excel exercise a day and rehearsing that project story out loud.
A project story that works in under three minutes:
- The question. "The dataset covered two years of sales for a retail chain and I wanted to know which districts were losing repeat customers."
- The data. Where it came from, how many rows, what was messy and how you cleaned it.
- What you did. The SQL or Excel steps, the model you built in Power BI, and one decision you made along the way.
- The result. One clear number or finding, and what a manager could do with it.
For preparation, a simple weekly plan is enough. Week one: write 20 to 30 SQL queries covering joins, GROUP BY, HAVING and window functions on a sample database. Week two: one timed Excel exercise each day plus rebuilding one dashboard from scratch. Week three: mock interviews with a friend or trainer, recording yourself answering the 12 questions above. Practising these with real datasets and trainer feedback is exactly what the Cokonet data analytics course is built around.
Not sure which route fits you? Talk to a counsellor on the contact page or call +91 8075 400 500.
Why Cokonet Academy for data analytics
Cokonet Academy trains data analysts at its campuses in Trivandrum and Kochi, with mock interviews built into every batch. Visit us on Google: Cokonet Academy, Trivandrum and Cokonet Academy, Kochi.
- NSDC partner
- 11,200+ successful placements
- 50+ corporate hiring partners
- Expert trainers in Data Analytics, Power BI, Python with AI, AWS and SAP (FICO, MM, ABAP)
- Portfolio projects on real-world style datasets, timed test practice and recorded mock interviews
Data analytics course details
The Data Analytics course takes a fresher from Excel basics to a presentable Power BI portfolio, in the order employers test: Excel first, then SQL, then Power BI, then Python with pandas for larger datasets. Each module ends with a project, and the final weeks are spent on exactly the interview questions covered in this guide, with timed tests and mock interviews.
- Course: Data Analytics (Excel, SQL, Power BI, Python)
- Best for: Freshers and graduates from any stream, including BCom, BSc, BBA, BTech and arts
- Formats: Weekday batches, weekend batches and live online classes
- Locations: Classroom in Trivandrum (Ulloor) and Kochi (Vennala), or online from anywhere in Kerala
- Includes: Portfolio projects, SQL and Excel test practice, mock interviews and placement support
See the full syllabus and next batch dates on the Data Analytics course page.
Visit our training centres
Walk in for a free career consultation and a look at the course. We are open Monday to Saturday, 9:30am to 10:00pm.
Enrol now
Walk into your first data analyst interview with projects to show and answers you have practised. Join the Data Analytics course, explore Cokonet Academy, or call and WhatsApp +91 8075 400 500 today.
