Data Analytics

🎓 𝗨𝗽𝘀𝗸𝗶𝗹𝗹 𝗪𝗶𝘁𝗵 𝗚𝗼𝘃𝗲𝗿𝗻𝗺𝗲𝗻𝘁-𝗔𝗽𝗽𝗿𝗼𝘃𝗲𝗱 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗙𝗼𝗿 𝟭𝟬𝟬% 𝗙𝗥𝗘𝗘 😍 ✅ AI & ML ✅ Cloud Computing ✅ Cybersecurity ✅ Data Analytics & Full Stack Development Earn industry-recognized certificates and boost your career 🚀 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:-    https://pdlink.in/4qgtrxU   Get the Govt. of India Incentives on course completion🏆

✅ Data Analyst Interview Questions with Answers: Part-8 71. What is Power BI or Tableau used for? Power BI and Tableau are Business Intelligence (BI) tools that convert raw data into interactive dashboards and reports. They help you connect to multiple data sources, clean and transform data, create visuals, and share insights with stakeholders. Example: A company connects its sales database to Power BI and builds a dashboard showing revenue trends, top products, and customer performance. 👉 Power BI and Tableau help organizations transform raw data into interactive visual insights for decision-making. 72. What is a data model? A data model defines how tables are connected using relationships, combining multiple tables for accurate analysis and improved dashboard performance. Example: Orders Table → Customer Table → Product Table (all connected using IDs). 👉 A data model organizes relationships between tables to enable accurate reporting. 73. What is a relationship? A relationship connects tables using a common column, with types like one-to-many, many-to-many, and one-to-one. Example: One customer → many orders (Customer_ID links Customers table to Orders table). 👉 Proper relationships prevent duplicate results and incorrect calculations. 74. What is DAX? DAX (Data Analysis Expressions) is a formula language used in Power BI for calculations, creating measures, time-based calculations, and business logic. Example: Total Sales = SUM(Sales[Amount]), YTD Sales = TOTALYTD(SUM(Sales[Amount]), Sales[Date]). 👉 DAX helps create advanced calculations and business metrics in Power BI. 75. Difference between measure and calculated column? Calculated columns are calculated row by row, stored in tables, and use memory. Measures are calculated dynamically, used in visuals, and more efficient. Example: Calculated column (Profit = Sales[Revenue] - Sales[Cost]), Measure (Total Profit = SUM(Sales[Revenue]) - SUM(Sales[Cost])). 👉 Measures are preferred for performance optimization. 76. What is Power Query? Power Query is a data transformation tool used before data enters Power BI, for cleaning, removing duplicates, changing data types, and more. Example: Converting text date into proper date format before building dashboard. 👉 Power Query prepares raw data for analysis. 77. What are filters and slicers? Filters restrict data in visuals or pages, while slicers are interactive filters visible to users. Example: A slicer allows users to select Region or Product to change dashboard view. 👉 Slicers improve user interaction and dashboard flexibility. 78. What is row-level security (RLS)? RLS restricts data visibility based on user roles, protecting sensitive data and enabling multi-user dashboards. Example: Sales manager sees only their region, HR sees only employee data. 👉 RLS ensures users only access authorized data. 79. What is refresh schedule? Refresh schedule automatically updates dashboard data, with options for manual, scheduled, or real-time refresh. Example: Daily sales dashboard updates every morning at 8 AM. 👉 Refresh schedules ensure dashboards always show updated data. 80. How do you optimize reports? Optimization techniques include removing unnecessary columns, using measures instead of calculated columns, avoiding too many visuals, and using star schema data models. Example: Replacing multiple calculated columns with one measure improves performance. 👉 Optimized reports improve speed, performance, and user experience. Double Tap ♥️ For Part-8

𝗧𝗼𝗽 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 𝗢𝗳𝗳𝗲𝗿𝗲𝗱 𝗕𝘆 𝗜𝗜𝗧 𝗥𝗼𝗼𝗿𝗸𝗲𝗲, 𝗜𝗜𝗠 & 𝗠𝗜𝗧😍 Placement Assistance With 5000+ Companies  𝗠𝗮𝗰𝗵𝗶𝗻𝗲 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝘄𝗶𝘁𝗵 𝗣𝘆𝘁𝗵𝗼𝗻 :- https://pdlink.in/4khp9E5 𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗪𝗶𝘁𝗵 𝗔𝗜 :- https://pdlink.in/4qkC4GP 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗪𝗶𝘁𝗵 𝗔𝗜 :- https://pdlink.in/4rwqIAm Hurry..Up👉 Only Limited Seats Available

🚨Do not miss this (Top FREE AI certificate courses) Enroll now in these 50+ Free AI courses along with courses on Vibe Coding with Claude Code - https://docs.google.com/spreadsheets/d/1D8t7BIWIQEpufYRB5vlUwSjc-ppKgWJf9Wp4i1KHzbA/edit?usp=sharing Limited Time Access - Only for next 24 hours! Top FREE AI, ML, Python Certificate courses which will help to boost resume in getting better jobs. 🚨Once you learn, participate in this Data Science Hiring Hackathon and get a chance to get hired as a Data Scientist - https://www.analyticsvidhya.com/datahack/contest/data-scientist-skill-test/?utm_source=av_socialutm_medium=love_data_telegram_post SO hurry up!

✅ Data Analyst Interview Questions with Answers: Part-7 61. Why is data visualization important? Data visualization converts raw numbers into visual formats so humans can understand patterns, trends, and problems quickly. • Humans process visuals faster than tables • Managers don’t read SQL or Excel sheets • Decisions are made in meetings, not databases Example: A line chart instantly shows sales are declining for 3 months > Data visualization helps stakeholders quickly understand insights and take action without analyzing raw data. 62. Difference between bar chart and line chart? • Bar Chart: Used for comparison between categories • Line Chart: Used for trends over time > If time is involved → line chart. If comparison is involved → bar chart. 63. When do you use a pie chart? Pie charts show percentage or share of a whole. • Use for fewer categories (≤ 5) • When proportions matter more than exact values > Pie charts are best for showing part-to-whole relationships with limited categories. 64. What is a dashboard? A dashboard is a single screen view that tracks key metrics and performance indicators. • Monitor business health • Track KPIs in real time • Support quick decisions > A dashboard provides a high-level summary of business performance at a glance. 65. What makes a good dashboard? A good dashboard is clear, focused, and actionable. • One business goal per dashboard • KPIs at the top • Consistent colors • Minimal clutter > A good dashboard answers business questions clearly and helps decision-making. 66. What is a KPI card? A KPI card displays one critical metric clearly. • Highlighting performance • Comparing actual vs target > KPI cards highlight the most important metrics for quick evaluation. 67. Common visualization mistakes? • Using wrong chart type • Too many colors • No axis labels • Showing everything on one page > Poor visualization can mislead users even if the data is correct. 68. How do you choose the right chart? • Comparison → Bar • Trend → Line • Distribution → Histogram • Relationship → Scatter • Part-to-whole → Pie > Chart selection depends on the goal. 69. What is drill-down? Drill-down allows users to move from summary to detailed data. • Yearly sales → Monthly → Daily • Region → City → Store > Drill-down helps users explore deeper insights without cluttering the dashboard. 70. What is data storytelling? Data storytelling combines data, visualization, and narrative. • Example: “Sales dropped by 10% because website traffic declined in the North region after ad spend was reduced.” > Data storytelling turns insights into actions by explaining what happened, why, and what to do next. Double Tap ♥️ For Part-8

✅ Removing Duplicates Handling Null Values 1️⃣ Why duplicates and nulls exist in real data In real business datasets: • Same record gets inserted multiple times • Data comes from multiple systems • Users leave fields empty • System failures create partial records If not handled: • KPIs get inflated • Counts become wrong • Filters behave incorrectly 2️⃣ Removing duplicates — what it means Removing duplicates means: • Keeping only one unique record • Based on one or more columns • Removing extra repeated rows Important: > Duplicate logic depends on business rules, not Power BI rules. 3️⃣ How to remove duplicates in Power Query Editor Steps: 1. Open Power Query Editor 2. Select the column(s) that define uniqueness 3. Go to Home → Remove Rows → Remove Duplicates Power Query: • Keeps the first occurrence • Removes all other matching rows 4️⃣ Choosing the right column for duplicates (very important) Examples: • Customer table: Correct key → CustomerID • Sales table: Correct key → OrderID + ProductID 👉 Always ask: > What uniquely identifies a record? 5️⃣ Handling null values — what null means Null means: • Value is missing • Unknown or not captured • Different from zero or blank Null ≠ 0 Null ≠ empty string 6️⃣ Why nulls cause problems • Calculations fail • Relationships break • Filters behave unexpectedly • Visuals show wrong totals 7️⃣ How to handle null values in Power Query • Option 1: Remove rows with nulls • Option 2: Replace null values • Option 3: Keep nulls intentionally 8️⃣ Business examples • Sales data: Duplicate OrderID → inflated revenue • HR data: Null ExitDate → active employee 9️⃣ Common beginner mistakes • Removing duplicates without understanding keys • Replacing nulls blindly • Using DAX instead of Power Query 🔑 Best practice rules • Handle duplicates at source level • Handle nulls before modeling • Always document business logic • Prefer Power Query over DAX Final takeaway • Duplicates distort metrics • Nulls distort logic • Power Query fixes both once and permanently Double Tap ♥️ For More

📊 𝟭𝟬𝟬% 𝗙𝗥𝗘𝗘 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲😍 ✅ Free Online Course 💡 Industry-Relevant Skills 🎓 Certification Included Upskill now and Get Certified 🎓 𝐋𝐢𝐧𝐤 👇:-    https://pdlink.in/497MMLw   Get the Govt. of India Incentives on course completion🏆

✅ Data Analyst Interview Questions with Answers: Part-6 51. Difference between mean and median? Mean is the average. Median is the middle value. Example: Salaries - 20k, 22k, 25k, 30k, 1,00k Mean = 39.4k (skewed) Median = 25k (better representative) 52. What is standard deviation? It measures how spread out data is from the mean. Example: Avg sales = ₹10,000 Std dev = ₹500 → stable Std dev = ₹5,000 → volatile 53. What is variance? Square of standard deviation. Shows data spread mathematically. 54. What is correlation? Measures relationship between two variables. Range -1 to +1 Example: Ad spend vs sales = 0.8 → strong positive correlation. 55. Difference between correlation and causation? Correlation does not mean one causes the other. Example: Ice cream sales and drowning both increase in summer. 56. What is an outlier? A value far from others. Example: Order values - 500, 700, 800, 50,000 57. What is sampling? Using a subset of data to represent full dataset. Example: Survey 1,000 customers instead of 1 million. 58. What is distribution? Pattern showing how data values are spread. Example: Normal, skewed, uniform distributions. 59. What is skewness? Measures asymmetry of data. Example: Income data usually right-skewed. 60. When do you use median over mean? When data has outliers. Example: House prices, salaries. Double Tap ♥️ For Part-7

✅ Data Analyst Interview Questions with Answers: Part-5 41. What is data cleaning? Data cleaning is the process of fixing or removing incorrect, incomplete, or inconsistent data. Example: Removing duplicate customer records, Fixing wrong date formats. 42. How do you handle missing data? Common methods: - Remove rows (if few missing) - Replace with mean, median, or 0 - Use forward or backward fill Example (SQL): SELECT COALESCE(sales, 0) AS sales FROM orders; 43. How do you treat outliers? - Identify using sorting, box plots, or Z-score - Remove or cap extreme values Example: Sales = 10,000, 12,000, 15,000, 1,00,000 → outlier. 44. What is data normalization? Scaling data between 0 and 1. Example: Normalized value = (x - min) / (max - min) Used in ML and comparisons. 45. What is data standardization? Centers data around mean 0 with std dev 1. Example: Z = (x - mean) / std 46. How do you check data quality? - Accuracy - Completeness - Consistency - Validity - Timeliness Example: Sales should never be negative. 47. What is duplicate data? Same record appearing more than once. Example: Same customer ID repeated multiple times. 48. How do you validate source data? - Compare with source systems - Check row counts - Verify key metrics Example: Total revenue in report = total revenue in database. 49. What is data transformation? Converting data into usable format. Examples: - Converting dates - Creating new columns - Aggregating values 50. Why is data preparation important? Clean data = correct insights. Poor data leads to wrong decisions. Example: Wrong sales data → wrong business strategy. Double Tap ♥️ For Part-6

𝗙𝗿𝗲𝘀𝗵𝗲𝗿𝘀 𝗴𝗲𝘁 𝟮𝟬 𝗟𝗣𝗔 𝗔𝘃𝗲𝗿𝗮𝗴𝗲 𝗦𝗮𝗹𝗮𝗿𝘆 𝘄𝗶𝘁𝗵 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 & 𝗔𝗜 𝗦𝗸𝗶𝗹𝗹𝘀😍 🚀IIT Roorkee Offering Data Science & AI Certification Program Placement Assistance With 5000+ companies. ✅ Open to everyone ✅ 100% Online | 6 Months ✅ Industry-ready curriculum ✅ Taught By IIT Roorkee Professors 🔥 90% Resumes without Data Science + AI skills are being rejected ⏳ Deadline:: 8th February 2026 𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗡𝗼𝘄 👇 :-    https://pdlink.in/49UZfkX   ✅ Limited seats only

Data Analyst Interview Questions with Answers: Part-4 31. What are Pivot Tables? Pivot tables summarize large datasets quickly. Example: Rows → Product, Values → Sum of Sales Result: Total sales per product in seconds. 32. Difference between VLOOKUP and XLOOKUP? VLOOKUP works left to right only. XLOOKUP works both ways and handles missing values better. Example: =XLOOKUP(A2, Products!A:A, Products!B:B) Fetches product name using product ID. 33. What is conditional formatting? Highlights data based on rules. Example: Highlight sales > 10000 in green. Helps spot top performers instantly. 34. What are COUNTIFS and SUMIFS? They apply conditions while counting or summing. Example: =SUMIFS(C:C, A:A, "East", B:B, "Laptop") Total sales of laptops in East region. 35. What is data validation? Restricts incorrect data entry. Example: Create dropdown for Region (East, West, North). Data → Data Validation → List. 36. How do you remove duplicates in Excel? Select data, Data → Remove Duplicates Example: Remove duplicate customer IDs. 37. What is IF formula used for? Applies logical conditions. Example: =IF(C2>5000,"High Sales","Low Sales") 38. Difference between relative and absolute reference? Relative → A2 changes when copied Absolute → $A$2 stays fixed Example: =A2*$E$1 Tax rate fixed while copying formula. 39. How do you clean data in Excel? Remove duplicates, TRIM extra spaces, Fix date formats, Handle blanks Example: =TRIM(A2) 40. What are common Excel mistakes analysts make? • Merged cells • Hard-coded values • No pivot tables • Poor formatting • No documentation Double Tap ♥️ For Part-5

𝟯 𝗙𝗥𝗘𝗘 𝗧𝗲𝗰𝗵 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗧𝗼 𝗘𝗻𝗿𝗼𝗹𝗹 𝗜𝗻 𝟮𝟬𝟮𝟲 😍 Upgrade your tech skills with FREE certification courses  𝗔𝗜, 𝗚𝗲𝗻𝗔𝗜 & 𝗠𝗟 :- https://pdlink.in/4bhetTu 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 :- https://pdlink.in/497MMLw 𝗢𝘁𝗵𝗲𝗿 𝗧𝗼𝗽 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 :- https://pdlink.in/4qgtrxU 🎓 100% FREE | Certificates Provided | Learn Anytime, Anywhere

Data Analyst Interview Questions with Answers: Part-3 21. What is SELECT used for? SELECT is used to fetch specific columns or data from a table. Example: SELECT customer_name, sales FROM orders; This query returns customer names and their sales from the orders table.   22. Difference between WHERE and HAVING? WHERE filters rows before aggregation. HAVING filters results after aggregation. Example: SELECT product, SUM(sales) AS total_sales FROM orders WHERE region = 'East' GROUP BY product HAVING SUM(sales) > 100000; Here, WHERE filters region first, HAVING filters aggregated sales.   23. What is GROUP BY? GROUP BY groups rows with the same values so aggregate functions can be applied. Example: SELECT region, SUM(sales) AS total_sales FROM orders GROUP BY region; This gives total sales per region.   24. What are aggregate functions? Aggregate functions perform calculations on multiple rows. Common examples: • COUNT → total rows • SUM → total value • AVG → average • MIN / MAX → smallest or largest value Example: SELECT COUNT(order_id), AVG(sales) FROM orders;   25. Difference between INNER JOIN and LEFT JOIN? INNER JOIN: Returns only matching records. LEFT JOIN: Returns all rows from left table and matching rows from right table. Example: SELECT o.order_id, c.customer_name FROM orders o LEFT JOIN customers c ON o.customer_id = c.customer_id; All orders appear even if customer info is missing.   26. What are subqueries? A subquery is a query inside another query. Example: SELECT * FROM orders WHERE sales > (SELECT AVG(sales) FROM orders); Returns orders with sales above average.   27. What is a CTE? CTE (Common Table Expression) is a temporary named result set that improves readability. Example: WITH sales_summary AS ( SELECT region, SUM(sales) AS total_sales FROM orders GROUP BY region ) SELECT * FROM sales_summary WHERE total_sales > 500000;   28. How do you handle duplicates in SQL? Identify duplicates: SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id HAVING COUNT(*) > 1; Remove duplicates (using ROW_NUMBER): DELETE FROM orders WHERE order_id IN ( SELECT order_id FROM ( SELECT order_id, ROW_NUMBER() OVER (PARTITION BY customer_id ORDER BY order_date) rn FROM orders ) t WHERE rn > 1 );   29. How do you handle NULL values? Check NULL: SELECT * FROM orders WHERE sales IS NULL; Replace NULL: SELECT COALESCE(sales, 0) AS sales_amount FROM orders;   30. What are window functions? Window functions perform calculations across rows without grouping them. Example: SELECT customer_id, sales, ROW_NUMBER() OVER (PARTITION BY customer_id ORDER BY sales DESC) AS rn FROM orders; This ranks sales per customer without collapsing rows. Double Tap ♥️ For Part-4

✅ Data Analyst Interview Questions with Answers: Part-2 11. What is structured data? Structured data is organized in rows and columns with a fixed schema, making it easy to store and query using SQL. Example: Sales tables, customer databases.   12. What is semi-structured data? Semi-structured data does not follow a strict table format but contains tags or keys. Example: JSON files, XML data, API responses.   13. What is unstructured data? Unstructured data has no predefined format. Example: Emails, images, videos, customer reviews text.   14. What is a database? A database is an organized system used to store, manage, and retrieve data efficiently. Example: MySQL, PostgreSQL, SQL Server.   15. Difference between OLTP and OLAP? OLTP (Online Transaction Processing) → Handles daily transactions (e.g., orders, payments). OLAP (Online Analytical Processing) → Used for reporting and analysis.   16. What is a primary key? A primary key uniquely identifies each record in a table. Example: Customer_ID in a customer table.   17. What is a foreign key? A foreign key links one table to another using the primary key of another table. Example: Customer_ID in Orders table linking to Customers table.   18. What is a fact table? Fact table contains measurable business data like sales, revenue, or quantity.   19. What is a dimension table? Dimension table contains descriptive details like customer name, region, product category.   20. What is a data warehouse? A data warehouse is a centralized system that stores large volumes of historical data for analysis and reporting. Double Tap ♥️ For Part-3