Start with the core concepts — SELECT, WHERE, JOINs, GROUP BY, HAVING, and subqueries — and then move to window functions, CTEs, and query optimization. Follow a simple plan: pick one topic each day, solve 15–20 questions on it, note your mistakes, and revise them weekly. Since most data analyst interviews in India begin with an SQL round, practice writing queries yourself instead of only reading answers.

First repeat the requirement and state your assumptions, then explain your approach — which tables, joins, and filters you will use — before writing anything. Build the query step by step, validate it with a small sample of data, and mention alternatives like a subquery, CTE, or window function where relevant. Interviewers judge your thought process as much as the final output, so think aloud clearly rather than rushing.

Practice topic-wise on real datasets instead of randomly — one week on joins, the next on aggregations, then window functions. Time yourself, maintain an error log of every query you got wrong, and redo those after a few days. Solving a compiled set of 100 questions with worked examples, and explaining each answer aloud as if to an interviewer, is one of the fastest ways to become interview-ready.

The most frequently asked ones cover types of JOINs, WHERE vs HAVING, DELETE vs TRUNCATE vs DROP, primary and foreign keys, aggregate functions with GROUP BY, subqueries, and window functions like ROW_NUMBER and RANK. Classic scenario questions such as finding the second highest salary or detecting duplicate records appear in almost every SQL interview, so keep their solutions ready.

Fresher rounds stay close to the basics — SELECT queries, filtering, sorting, simple joins, GROUP BY, constraints, and normalization. SQL interview questions and answers for experienced professionals go deeper into window functions, CTEs, query optimization, indexes, and complex scenario-based problems, so prepare according to your experience level and be ready to discuss queries you have actually used in projects or at work.

Expect business-oriented queries — monthly sales trends, month-over-month growth, top N customers per region, duplicate detection, and date-based filtering — because data analyst rounds test how you turn data into insight, not just syntax. Multi-table joins, aggregation with GROUP BY, and window functions for rankings come up repeatedly, so practice explaining the business meaning behind your query output as well.

The usual ones cover Power BI vs Excel, import vs DirectQuery mode, what Power Query does, measures vs calculated columns in DAX, relationships and data modeling, filters vs slicers, and how scheduled refresh works. Interviewers also commonly ask you to walk through one dashboard project end to end, so prepare a clear story around a report you have built.

Fresher rounds focus on fundamentals — components of Power BI, basic visuals, data types, simple DAX functions, and one mini project explanation. Power BI interview questions and answers for experienced professionals go deeper into star schemas, time-intelligence DAX, row-level security, performance tuning, and incremental refresh, so match your preparation depth to the level of the role you are targeting.

Look for compiled question banks and notes on creator platforms like Topmate, where analytics mentors sell ready-made sets of the top 100 Power BI questions with answers and revision notes. A good PDF should be organised topic-wise, include short summaries for each section, and cover both DAX and data modeling so you can revise everything in a couple of hours before the interview.

Along with tool basics, data analyst rounds test practical reporting skills — cleaning raw data in Power Query, building a data model with correct relationships, writing DAX measures for KPIs like revenue and growth percentage, choosing the right visual for each insight, and troubleshooting refresh errors. Be ready to explain one complete dashboard from raw data to the final business insight you delivered.

Use a clean, ATS-friendly layout and place your tools — SQL, Excel, Python, Power BI, Tableau — in a dedicated skills section near the top. Add two or three projects with measurable outcomes, quantify achievements (for example, "reduced manual reporting time by 40%"), and mirror the keywords from each job description you apply to. Keep it to one page if you are a fresher.

Replace the experience section with projects, internships, and certifications — a strong data analyst resume for freshers leads with skills and two to three portfolio projects built on public datasets and published on GitHub, the Power BI service, or Tableau Public. Add relevant certifications and coursework, highlight transferable skills from any previous role, and write a summary that clearly states the tools you work with and the roles you are targeting.

It should follow a clear order — name and contact details, a two-line summary, a skills section covering SQL, Excel, Python, Power BI, and Tableau, then projects or work experience with quantified bullets, followed by education and certifications. Use a single-column layout, start every bullet with an action verb, keep fonts and date formats consistent, and limit the length to one page for freshers and two pages for experienced professionals.

Choose a simple, single-column, ATS-friendly template rather than a heavily designed one with graphics, tables, or multiple columns, because applicant tracking systems often fail to parse those elements. The template should have clearly labelled sections for skills, projects, and experience so a recruiter can spot your SQL, Excel, and Power BI work within seconds of opening the file.

Email a data analyst resume PDF to recruiters and attach it on LinkedIn, since a PDF preserves your formatting on every device. On job portals and company career pages, follow the instructions — Naukri and many ATS portals parse Word files more reliably — so keep both versions ready and upload whichever format the application specifically asks for.