<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Kaabil AI</title>
    <description>The latest articles on DEV Community by Kaabil AI (@kaabil_ai_ee6e0bc792cf126).</description>
    <link>https://dev.to/kaabil_ai_ee6e0bc792cf126</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4253502%2Fa9a2ffb7-dc40-4ac0-8a64-c9b69e84839e.png</url>
      <title>DEV Community: Kaabil AI</title>
      <link>https://dev.to/kaabil_ai_ee6e0bc792cf126</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/kaabil_ai_ee6e0bc792cf126"/>
    <language>en</language>
    <item>
      <title>Excel, SQL and Power BI Interview Questions for Fresher Data Roles</title>
      <dc:creator>Kaabil AI</dc:creator>
      <pubDate>Thu, 19 Nov 2026 09:38:47 +0000</pubDate>
      <link>https://dev.to/kaabil_ai_ee6e0bc792cf126/excel-sql-and-power-bi-interview-questions-for-fresher-data-roles-3o4o</link>
      <guid>https://dev.to/kaabil_ai_ee6e0bc792cf126/excel-sql-and-power-bi-interview-questions-for-fresher-data-roles-3o4o</guid>
      <description>&lt;p&gt;Fresher data roles in India go by many names: data analyst trainee, MIS executive, business analyst, reporting analyst. Whatever the title, the interview usually checks the same three tools. Excel shows whether you can clean and summarise data quickly. SQL shows whether you can pull the right data from a database. Power BI shows whether you can turn that data into a report someone can actually use.&lt;/p&gt;

&lt;p&gt;This article walks through the questions freshers are most likely to face in each tool, with short sample answers and small examples you can practise. It also covers the "thinking" questions that sit on top of the tools, such as how you would approach a messy dataset or explain a dip in sales. At the end you will find a one-week practice plan and answers to common doubts.&lt;/p&gt;

&lt;p&gt;Treat the sample answers as models, not scripts. The interviewer will often ask "why?" or "show me", so make sure you can do each thing on a laptop, not only describe it.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Frmhs984rbwiiiv0d86po.jpg" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Frmhs984rbwiiiv0d86po.jpg" alt="Excel, SQL and Power BI Interview Questions for Fresher Data Roles - cover image by Kaabil AI" width="800" height="450"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  What do interviewers check in a fresher data interview?
&lt;/h2&gt;

&lt;p&gt;Interviewers check three things: whether you know the tools, whether you can think through a business question, and whether you can explain your work simply. Tool knowledge gets you through the first round; clear thinking gets you the offer.&lt;/p&gt;

&lt;p&gt;That is why many interviews include a small practical task. You may get a sample sheet in Excel, a table to query in SQL, or a request to describe a dashboard you built. Practise doing, not just reading.&lt;/p&gt;

&lt;h2&gt;
  
  
  What Excel questions should you prepare?
&lt;/h2&gt;

&lt;p&gt;You should prepare questions on lookups, conditional formulas, pivot tables, data cleaning and basic charts. These are the Excel skills most data roles use every day. For a longer list with worked answers, see this set of &lt;a href="https://kaabil.ai/interview-questions/excel" rel="noopener noreferrer"&gt;Excel interview questions and answers&lt;/a&gt;.&lt;/p&gt;

&lt;h3&gt;
  
  
  What is the difference between VLOOKUP and XLOOKUP?
&lt;/h3&gt;

&lt;p&gt;VLOOKUP searches the first column of a range and returns a value from a column to its right. XLOOKUP can search any column, return values to the left or right, and handles not-found results more cleanly.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Sample answer:&lt;/strong&gt; "VLOOKUP needs the lookup value in the first column and uses a column number, so it breaks if columns are inserted. XLOOKUP takes a separate lookup array and return array, so it works in both directions and is easier to maintain. If XLOOKUP is not available in the Excel version, I use INDEX with MATCH."&lt;/p&gt;

&lt;h3&gt;
  
  
  How do you use IF, COUNTIF and SUMIF?
&lt;/h3&gt;

&lt;p&gt;IF returns one value when a condition is true and another when it is false. COUNTIF counts cells that meet a condition, and SUMIF adds values that meet a condition. COUNTIFS and SUMIFS handle more than one condition.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Sample answer:&lt;/strong&gt; "If I want to tag orders above a certain value as 'High', I use IF. To count how many orders came from Delhi, I use COUNTIF on the city column. To total sales for Delhi in March, I use SUMIFS with two conditions."&lt;/p&gt;

&lt;h3&gt;
  
  
  What is a pivot table and when would you use it?
&lt;/h3&gt;

&lt;p&gt;A pivot table is an Excel feature that summarises large data by grouping and aggregating it, without writing formulas. You drag fields into rows, columns, values and filters.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Sample answer:&lt;/strong&gt; "I use a pivot table when I need a quick summary, like total sales by region and month. It lets me change the view in seconds and spot patterns before building a proper report."&lt;/p&gt;

&lt;h3&gt;
  
  
  How do you clean messy data in Excel?
&lt;/h3&gt;

&lt;p&gt;You clean data by removing duplicates, fixing extra spaces and text cases, splitting or joining columns, correcting data types and handling blanks. Functions like TRIM, PROPER and TEXT, plus Remove Duplicates and Text to Columns, cover most cases.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Sample answer:&lt;/strong&gt; "First I make a copy of the raw data. Then I remove duplicates, use TRIM to clear extra spaces, make sure dates are real dates and not text, and decide how to treat blanks based on the business question. I note every change so the cleaning can be repeated."&lt;/p&gt;

&lt;h2&gt;
  
  
  What SQL questions should you prepare?
&lt;/h2&gt;

&lt;p&gt;You should prepare SQL questions on SELECT with filters, GROUP BY with HAVING, joins, subqueries and simple window functions. Most fresher tests and interviews stay within these topics.&lt;/p&gt;

&lt;h3&gt;
  
  
  What is the difference between WHERE and HAVING?
&lt;/h3&gt;

&lt;p&gt;WHERE filters rows before grouping. HAVING filters groups after the GROUP BY has been applied, usually on an aggregate like SUM or COUNT.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Sample answer:&lt;/strong&gt; "If I want only orders from 2026, I use WHERE on the order date. If I want only customers whose total order value crosses a limit, I group by customer and use HAVING on SUM of the amount."&lt;/p&gt;

&lt;h3&gt;
  
  
  What are the types of joins?
&lt;/h3&gt;

&lt;p&gt;The main joins are INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL OUTER JOIN. They differ in which rows they keep when there is no match in the other table.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;INNER JOIN:&lt;/strong&gt; only rows that match in both tables.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;LEFT JOIN:&lt;/strong&gt; all rows from the left table, plus matches from the right; non-matches show as NULL.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;RIGHT JOIN:&lt;/strong&gt; the opposite of LEFT JOIN.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;FULL OUTER JOIN:&lt;/strong&gt; all rows from both tables, matched where possible.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;strong&gt;Sample answer:&lt;/strong&gt; "If I want all customers, including those who never ordered, I use a LEFT JOIN from customers to orders. Customers with no orders will show NULL in the order columns."&lt;/p&gt;

&lt;h3&gt;
  
  
  Can you write a query for the top customers by sales?
&lt;/h3&gt;

&lt;p&gt;Yes. Group the orders by customer, sum the amount, sort in descending order and limit the result. This is one of the most common practical questions.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="c1"&gt;-- Top 5 customers by total sales in 2026&lt;/span&gt;
&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="n"&gt;c&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;customer_name&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
       &lt;span class="nb"&gt;SUM&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;o&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;amount&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;AS&lt;/span&gt; &lt;span class="n"&gt;total_sales&lt;/span&gt;
&lt;span class="k"&gt;FROM&lt;/span&gt;   &lt;span class="n"&gt;customers&lt;/span&gt; &lt;span class="n"&gt;c&lt;/span&gt;
&lt;span class="k"&gt;JOIN&lt;/span&gt;   &lt;span class="n"&gt;orders&lt;/span&gt; &lt;span class="n"&gt;o&lt;/span&gt; &lt;span class="k"&gt;ON&lt;/span&gt; &lt;span class="n"&gt;o&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;customer_id&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;c&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;customer_id&lt;/span&gt;
&lt;span class="k"&gt;WHERE&lt;/span&gt;  &lt;span class="n"&gt;o&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;order_date&lt;/span&gt; &lt;span class="o"&gt;&amp;gt;=&lt;/span&gt; &lt;span class="s1"&gt;'2026-01-01'&lt;/span&gt;
&lt;span class="k"&gt;GROUP&lt;/span&gt;  &lt;span class="k"&gt;BY&lt;/span&gt; &lt;span class="n"&gt;c&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;customer_name&lt;/span&gt;
&lt;span class="k"&gt;ORDER&lt;/span&gt;  &lt;span class="k"&gt;BY&lt;/span&gt; &lt;span class="n"&gt;total_sales&lt;/span&gt; &lt;span class="k"&gt;DESC&lt;/span&gt;
&lt;span class="k"&gt;LIMIT&lt;/span&gt;  &lt;span class="mi"&gt;5&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Mention that some databases use TOP instead of LIMIT. It shows you know the syntax can differ.&lt;/p&gt;

&lt;h3&gt;
  
  
  What is a window function?
&lt;/h3&gt;

&lt;p&gt;A window function performs a calculation across a set of rows related to the current row without collapsing them into one row. Examples are ROW_NUMBER, RANK, DENSE_RANK and running totals with SUM OVER.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Sample answer:&lt;/strong&gt; "If I need the highest order for each customer, I use ROW_NUMBER partitioned by customer and ordered by amount descending, then pick rows where the number is 1. Unlike GROUP BY, I still keep the other columns of that order."&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Feju6rp6uan9m8693ict5.jpg" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Feju6rp6uan9m8693ict5.jpg" alt="Checklist infographic: Excel, SQL and Power BI Interview Questions for Fresher Data Roles" width="800" height="800"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  What Power BI questions should you prepare?
&lt;/h2&gt;

&lt;p&gt;You should prepare Power BI questions on Power Query, data modelling, DAX measures, visuals and sharing reports. Interviewers want to see that you can go from raw data to a clean, useful dashboard. This page of &lt;a href="https://kaabil.ai/interview-questions/power-bi" rel="noopener noreferrer"&gt;Power BI interview questions&lt;/a&gt; covers these areas with more examples.&lt;/p&gt;

&lt;h3&gt;
  
  
  What is the difference between Power Query and DAX?
&lt;/h3&gt;

&lt;p&gt;Power Query is used to load, clean and shape data before it reaches the model. DAX is the formula language used to create calculations, such as measures and calculated columns, on the model.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Sample answer:&lt;/strong&gt; "I use Power Query to remove columns, fix data types and merge tables. Once the data is clean, I use DAX to calculate things like total sales, year-to-date sales and growth."&lt;/p&gt;

&lt;h3&gt;
  
  
  What is the difference between a measure and a calculated column?
&lt;/h3&gt;

&lt;p&gt;A calculated column is computed row by row and stored in the table. A measure is calculated on the fly based on the filters in the report, such as the selected month or region.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Sample answer:&lt;/strong&gt; "I use a calculated column when I need a value for each row, like a profit category. I use a measure for totals and ratios, like total revenue, because it changes correctly when users apply filters."&lt;/p&gt;

&lt;h3&gt;
  
  
  What is a star schema?
&lt;/h3&gt;

&lt;p&gt;A star schema is a data model with one central fact table, holding transactions or numbers, linked to several dimension tables, holding descriptive details like date, product and customer.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Sample answer:&lt;/strong&gt; "In a sales model, the orders table is the fact table. Date, product, customer and region are dimension tables. This layout keeps the model simple and makes DAX calculations and filters work as expected."&lt;/p&gt;

&lt;h3&gt;
  
  
  How do you choose the right visual?
&lt;/h3&gt;

&lt;p&gt;You choose a visual based on the question it answers. Line charts show trends over time, bar charts compare categories, cards show single key numbers, and tables show details.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Sample answer:&lt;/strong&gt; "If a manager asks how sales moved each month, I use a line chart. If they want to compare regions, I use a bar chart. I keep the top row for a few key cards and avoid too many colours or visuals on one page."&lt;/p&gt;

&lt;h2&gt;
  
  
  How do you answer the business-thinking questions?
&lt;/h2&gt;

&lt;p&gt;You answer business-thinking questions by restating the problem, listing what data you would check, and describing the steps in order. The interviewer cares more about your approach than a perfect final answer.&lt;/p&gt;

&lt;p&gt;Take a common example: "Our sales fell last month. What would you check first?" A strong answer goes step by step. First, confirm the drop is real and not a data issue. Then break sales down by region, product, channel and customer type to see where the fall is concentrated. Compare with the same month last year to check for seasonality. Finally, talk to the business team about any changes such as price, stock or marketing. For more scenario-style questions like this, see these &lt;a href="https://kaabil.ai/interview-questions/data-analyst" rel="noopener noreferrer"&gt;data analyst interview questions and scenarios&lt;/a&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  How should you practise in one week?
&lt;/h2&gt;

&lt;p&gt;You should practise one tool per day with a real dataset, then spend the last days building and explaining a small project. Public datasets from government open-data portals are a good free source.&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Day 1:&lt;/strong&gt; Excel lookups, IF, COUNTIFS and SUMIFS on one dataset.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Day 2:&lt;/strong&gt; Excel pivot tables, charts and data cleaning.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Day 3:&lt;/strong&gt; SQL SELECT, WHERE, GROUP BY and HAVING.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Day 4:&lt;/strong&gt; SQL joins, subqueries and one window function.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Day 5:&lt;/strong&gt; Power BI: load, clean in Power Query, build a star schema.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Day 6:&lt;/strong&gt; Power BI: three DAX measures and a one-page dashboard.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Day 7:&lt;/strong&gt; Explain the whole project aloud in three minutes.&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  Frequently asked questions
&lt;/h2&gt;

&lt;h3&gt;
  
  
  Do I need Python for a fresher data analyst role?
&lt;/h3&gt;

&lt;p&gt;Many fresher roles focus on Excel, SQL and a BI tool. Python is a plus for some roles, so check the job description. Strong basics in the three tools come first.&lt;/p&gt;

&lt;h3&gt;
  
  
  Is Power BI or Tableau better for freshers?
&lt;/h3&gt;

&lt;p&gt;Both are used in the industry. Pick the one that appears more often in the job descriptions you are targeting, learn it properly and mention the other only if you have actually used it.&lt;/p&gt;

&lt;h3&gt;
  
  
  What project should I show in a data interview?
&lt;/h3&gt;

&lt;p&gt;Show one small, complete project: a cleaned dataset, a few SQL queries that answer business questions, and a simple dashboard with a short written summary of what you found.&lt;/p&gt;

&lt;h2&gt;
  
  
  What should you do after reading this?
&lt;/h2&gt;

&lt;p&gt;Open a dataset today and try three questions from this article on your own laptop. Then write a short project summary for your resume and practise explaining it in under three minutes.&lt;/p&gt;

&lt;p&gt;When you begin applying, Kaabil AI can point you to fresher data roles that match your skills, score your resume, and let its Career Agent message recruiters with only what you have approved.&lt;/p&gt;

</description>
      <category>career</category>
      <category>data</category>
      <category>interview</category>
      <category>sql</category>
    </item>
  </channel>
</rss>
