🎰 Welcome Bonus 1200% — Maczo Crypto Casino
🎮 Crypto exchange · Sports · Live casino — all in one place
💳 USDT instant deposit & withdrawal
→ https://t.me/maczo_official_global

Hey guys,

Today, I’m covering some Excel interview questions that often pop up in data analyst roles 👇👇

1. What are the most common functions used in Excel for data analysis?

- SUM(): Adds up values in a range.
- AVERAGE(): Finds the mean of a range of numbers.
- VLOOKUP() / XLOOKUP(): Searches for a value in a table and returns a related value.
- INDEX-MATCH: A more flexible alternative to VLOOKUP, allowing lookups in any direction.
- IF(): Performs logical tests and returns one value if TRUE, another if FALSE.
- COUNTIF(): Counts the number of cells that meet a specific condition.
- PivotTables: For summarizing, analyzing, and exploring large datasets.

2. What is the difference between VLOOKUP and XLOOKUP?

- VLOOKUP is an older function used to find data in a vertical column and return a value from another column to the right.

Example:

  =VLOOKUP("A2", B2:D10, 3, FALSE)
  

- XLOOKUP is more powerful, offering the flexibility to search both vertically and horizontally, and it doesn’t require the lookup value to be in the first column.

Example:

  =XLOOKUP(A2, B2:B10, C2:C10)
  

Tip: Explain the limitations of VLOOKUP (like not being able to search left or needing sorted data for approximate matches) and how XLOOKUP overcomes them.

3. How do you create a PivotTable in Excel, and why is it useful?

A PivotTable allows you to summarize large amounts of data quickly. Here’s how to create one:

1. Select your data.
2. Go to the Insert tab and click on PivotTable.
3. Choose where to place the PivotTable.
4. Drag and drop fields into the Rows, Columns, Values, and Filters sections.

4. What is conditional formatting, and how do you use it?

Conditional formatting is used to change the appearance of cells based on their content. It helps highlight trends, patterns, and outliers.

For example, to highlight cells greater than 1000:
1. Select the range of cells.
2. Go to the Home tab, click on Conditional Formatting.
3. Choose Highlight Cell Rules > Greater Than and enter 1000.
4. Choose a format (e.g., cell color) to apply.

5. How do you handle large datasets in Excel without slowing it down?

Here are some strategies to improve efficiency:

- Turn off automatic calculations: Use manual recalculation to prevent Excel from recalculating formulas every time you make a change.

  File > Options > Formulas > Calculation Options > Manual
  

- Use fewer volatile functions: Functions like NOW(), TODAY(), and INDIRECT() recalculate every time a change is made.

- Use tables instead of ranges: Structured references in tables are more efficient.

- Split large datasets: If feasible, split your data across multiple sheets or workbooks.

- Remove unnecessary formatting: Too much formatting can bloat file size and slow down processing.

6. How do you use Excel for data cleaning?

Data cleaning is one of the first and most important steps in data analysis, and Excel provides multiple ways to do this:

- Remove duplicates: Easily eliminate duplicate entries.

- Text to Columns: Split data in one column into multiple columns (e.g., splitting full names into first and last names).

- TRIM(): Remove extra spaces from text.

- FIND() and SUBSTITUTE(): For locating and replacing specific characters or substrings.

7. What are some advanced Excel functions you’ve used for data analysis?

Aside from the basics, some advanced Excel functions you might mention include:

- ARRAYFORMULA(): Allows multiple calculations to be performed at once.
- OFFSET(): Returns a range that is offset from a starting point.
- FORECAST(): Predicts future values based on historical data.
- POWER QUERY: For data extraction, transformation, and loading (ETL) tasks.

I have curated best 80+ top-notch Data Analytics Resources 👇👇
https://t.me/DataSimplifier

Like for more Interview Resources ♥️

Share with credits: https://t.me/sqlspecialist

Hope it helps :)

🚀 𝗣𝗮𝘆 𝗔𝗳𝘁𝗲𝗿 𝗣𝗹𝗮𝗰𝗲𝗺𝗲𝗻𝘁 | 𝗚𝗲𝘁 𝗛𝗶𝗿𝗲𝗱 𝗶𝗻 𝗧𝗼𝗽 𝗧𝗲𝗰𝗵 𝗖𝗼𝗺𝗽𝗮𝗻𝗶𝗲𝘀! 💼🔥

Master the most in-demand tech skills and kickstart your career with industry-leading training.

🎯 Program Highlights:
✅ Learn Coding from Industry Experts
✅ Real-World Projects & Interview Preparation
✅ Dedicated Placement Support
✅ Avg. Package: ₹7.2 LPA
✅ Highest Package: ₹41 LPA 🚀

🎓 Perfect for Freshers, Students & Career Switchers

𝐑𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐍𝐨𝐰 👇:-

 https://pdlink.in/42WOE5H

Hurry! Limited seats are available.🏃‍♂️

✅ Top Skills Every Data Analyst Should Master 📊🧠

1️⃣ Excel
- Formulas (VLOOKUP, INDEX-MATCH)
- Pivot Tables, Charts, Conditional Formatting
- Data Cleaning & Analysis

2️⃣ SQL
- SELECT, JOINs, GROUP BY, HAVING
- Subqueries, CTEs, Window Functions
- Extracting and analyzing relational data

3️⃣ Data Visualization
- Tools: Power BI, Tableau, Excel
- Dashboards, filters, slicers, KPIs
- Clear, insightful visuals

4️⃣ Python
- Libraries: Pandas, NumPy, Matplotlib, Seaborn
- Data cleaning, wrangling, EDA
- Basic automation and scripting

5️⃣ Statistics
- Mean, median, mode, standard deviation
- Probability, distributions
- Hypothesis testing, A/B Testing

6️⃣ Business Understanding
- Know key metrics: revenue, churn, CAC, CLV
- Interpret data in business context
- Communicate insights clearly

7️⃣ Critical Thinking
- Ask the right questions
- Validate findings
- Avoid assumptions

8️⃣ Communication Skills
- Report writing
- Presenting insights to non-technical teams
- Storytelling with data

💬 React ❤️ for more!

𝗧𝗼𝗽 𝟱 𝗙𝗥𝗘𝗘 𝗔𝗜 & 𝗠𝗟 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 🚀

These FREE courses can help you develop industry-relevant skills and create a strong foundation in ML & AI. 📈

✅ 100% Free Learning Resources
✅ Beginner-Friendly Content
✅ Hands-On Projects
✅ Build an ML Portfolio
✅ Boost Your Resume & Career Opportunities

🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:

https://pdlink.in/4dXk9Sc

📌 Save this post and start your AI journey today!

✅ Complete SQL Roadmap in 2 Months

Month 1: Strong SQL Foundations
Week 1: Database and query basics
- What SQL does in analytics and business
- Tables, rows, columns
- Primary key and foreign key
- SELECT, DISTINCT
- WHERE with AND, OR, IN, BETWEEN
Outcome: You understand data structure and fetch filtered data.

Week 2: Sorting and aggregation
- ORDER BY and LIMIT
- COUNT, SUM, AVG, MIN, MAX
- GROUP BY
- HAVING vs WHERE
- Use case like total sales per product
Outcome: You summarize data clearly.

Week 3: Joins fundamentals
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- Join conditions
- Handling NULL values
Outcome: You combine multiple tables correctly.

Week 4: Joins practice and cleanup
- Duplicate rows after joins
- SELF JOIN with examples
- Data cleaning using SQL
- Daily join-based questions
Outcome: You stop making join mistakes.

Month 2: Analytics-Level SQL
Week 5: Subqueries and CTEs
- Subqueries in WHERE and SELECT
- Correlated subqueries
- Common Table Expressions
- Readability and reuse
Outcome: You write structured queries.

Week 6: Window functions
- ROW_NUMBER, RANK, DENSE_RANK
- PARTITION BY and ORDER BY
- Running totals
- Top N per category problems
Outcome: You solve advanced analytics queries.

Week 7: Date and string analysis
- Date functions for daily, monthly analysis
- Year-over-year and month-over-month logic
- String functions for text cleanup
Outcome: You handle real business datasets.

Week 8: Project and interview prep
- Build a SQL project using sales or HR data
- Write KPI queries
- Explain query logic step by step
- Daily interview questions practice
Outcome: You are SQL interview ready.

Practice platforms
- LeetCode SQL
- HackerRank SQL
- Kaggle datasets

Double Tap ♥️ For Detailed Explanation of Each Topic

Must important topics to look before any excel interview for Data/Business Analyst role :-

Data Handling: Cell formatting, rows/columns, basic functions (SUM, AVERAGE, COUNT etc).

Data Management Mastery: Sorting, filtering, data validation, diverse cell references. Function Proficiency: Explore SUMIF, (V & X)LOOKUP, INDEX, MATCH, IF, and advanced function nesting.

Advanced Analytics: Master PivotTables for dynamic data analysis and various chart creation.

Advanced Analysis Techniques: Conditional formatting, goal-seeking, in-depth what-if analysis.

Advanced Functions: COUNTIF/IFS, SUMIFS, AVERAGEIF/IFS, CONCATENATE, date/time functions.

These are the most important one's which I tried to summarise in the best possible way, please let me know in the comments if I have missed something important.

𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 & 𝗔𝗜 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝘄𝗶𝘁𝗵 𝗣𝗹𝗮𝗰𝗲𝗺𝗲𝗻𝘁 𝗦𝘂𝗽𝗽𝗼𝗿𝘁😍

Build a Career in Data Science & AI with a job-focused curriculum designed by industry experts.

✅ Learn from IIT Alumni & Top Industry Professionals
✅ 500+ Hiring Partners
✅ 100% Job Assistance
✅ Real-World Projects & Case Studies
✅ Mock Interviews & Career Support

Whether you're a student, fresher, or working professional, this program can help you transition into high-growth Data & AI roles.

🎯 Don't wait for opportunities — create them!

𝐑𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐍𝐨𝐰 👇:-

 https://pdlink.in/4fdWxJB

⚡ Limited Seats Available – Apply Fast!

1. What data sources can Power BI connect to?

Ans: The list of data sources for Power BI is extensive, but it can be grouped into the following:
Files: Data can be imported from Excel (.xlsx, xlxm), Power BI Desktop files (.pbix) and Comma Separated Value (.csv).
Content Packs: It is a collection of related documents or files that are stored as a group. In Power BI, there are two types of content packs, firstly those from services providers like Google Analytics, Marketo, or Salesforce, and secondly those created and shared by other users in your organization.
Connectors to databases and other datasets such as Azure SQL, Database and SQL, Server Analysis Services tabular data, etc.


2. What are the different integrity rules present in the DBMS?

The different integrity rules present in DBMS are as follows:
Entity Integrity: This rule states that the value of the primary key can never be NULL. So, all the tuples in the column identified as the primary key should have a value.
Referential Integrity: This rule states that either the value of the foreign key is NULL or it should be the primary key of any other relation.


3. What are some common clauses used with SELECT query in SQL?

Some common SQL clauses used in conjuction with a SELECT query are as follows:
WHERE clause in SQL is used to filter records that are necessary, based on specific conditions.
ORDER BY clause in SQL is used to sort the records based on some field(s) in ascending (ASC) or descending order (DESC).
GROUP BY clause in SQL is used to group records with identical data and can be used in conjunction with some aggregation functions to produce summarized results from the database.
HAVING clause in SQL is used to filter records in combination with the GROUP BY clause. It is different from WHERE, since the WHERE clause cannot filter aggregated records.


4. What is the difference between count, counta, and countblank in Excel?

The count function is very often used in Excel. Here, let’s look at the difference between count, and it’s variants - counta and countblank.

1. COUNT
It counts the number of cells that contain numeric values only. Cells that have string values, special characters, and blank cells will not be counted.

2. COUNTA
It counts the number of cells that contain any form of content. Cells that have string values, special characters, and numeric values will be counted. However, a blank cell will not be counted.

3. COUNTBLANK
As the name suggests, it counts the number of blank cells only. Cells that have content will not be taken into consideration.

🔥 4 Most Asked SQL Theoretical Interview Questions 🔥

❓ 1. What is the difference between WHERE and HAVING?

✅ WHERE filters rows before aggregation.
✅ HAVING filters groups after aggregation.

💡 WHERE → Rows | HAVING → Groups

━━━━━━━━━━━━━━

❓ 2. What is the difference between RANK(), DENSE_RANK(), and ROW_NUMBER()?

✅ ROW_NUMBER() → Unique number for each row
✅ RANK() → Skips ranks after ties
✅ DENSE_RANK() → No skipped ranks after ties

💡 A favorite topic in SQL interviews.

━━━━━━━━━━━━━━

❓ 3. What is a CTE?

✅ CTE (Common Table Expression) is a temporary result set created using the WITH clause.

💡 Helps make complex queries cleaner and easier to understand.

━━━━━━━━━━━━━━

❓ 4. What is the difference between DELETE, TRUNCATE, and DROP?

🗑️ DELETE → Removes selected rows
⚡ TRUNCATE → Removes all rows
💥 DROP → Removes the entire table

━━━━━━━━━━━━━━

React ♥️ for more interview questions

𝗔𝗜 &𝗠𝗟 𝗙𝗥𝗘𝗘 𝗢𝗻𝗹𝗶𝗻𝗲 𝗠𝗮𝘀𝘁𝗲𝗿𝗰𝗹𝗮𝘀𝘀 😍

💫 Future-Proof Your AI & Machine Learning Career in 2026 with Generative AI Skills
​
💫Kickstart Your AI & Machine Learning Career

Eligibility :- Students ,Freshers & Working Professionals

𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇 :-

https://pdlink.in/43oLYOA

( Limited Slots ..Hurry Up‍ )

Date & Time :- 10th June 2026 , 7:00 PM

🔥 DAX Interview Questions 🔥

Q1 : What is the difference between a Calculated Column and a Measure?

✅ Answer:

A Calculated Column is computed row by row and stored in the data model.

A Measure is calculated dynamically at query time based on the current filter context and is not stored.

Q2 : What is Filter Context in DAX?

✅ Answer:

Filter Context is the set of filters applied to a calculation through visuals, slicers, filters, or DAX expressions. It determines which data is included in the calculation.

Q3 : What is the purpose of the CALCULATE() function?

✅ Answer:

CALCULATE() modifies the filter context before evaluating an expression. It is one of the most powerful and frequently used functions in DAX.

Q4 : What is the difference between ALL() and REMOVEFILTERS()?

✅ Answer:

Both functions remove filters from columns or tables.
REMOVEFILTERS() is generally preferred for readability, while ALL() can also return a table and is often used in advanced DAX calculations.

React ♥️ for more interview questions 🔥

🧠 Advanced SQL Interview Question ⚡

📊 Find employees who earn more than their manager

Table: Employees

Columns:

employee_id, employee_name, manager_id, salary

🔍 Query:

SELECT
e.employee_id,
e.employee_name,
e.salary,
m.employee_name AS manager_name,
m.salary AS manager_salary
FROM Employees e
JOIN Employees m
ON e.manager_id = m.employee_id
WHERE e.salary > m.salary;

🎯 Why this question matters:

✅ Tests Self Joins
✅ Evaluates understanding of hierarchical data
✅ Commonly asked in SQL interviews and real-world scenarios

🚀 Pro Tip:

Whenever a table references itself (employees-managers, users-referrals, categories-parent categories), a Self Join is often the cleanest solution.

🔥 React ❤️ for more advanced SQL interview questions 🚀

💫 𝗔𝗧𝗧𝗘𝗡𝗧𝗜𝗢𝗡 𝗦𝗧𝗨𝗗𝗘𝗡𝗧𝗦 & 𝗙𝗥𝗘𝗦𝗛𝗘𝗥𝗦 🔥

This could be the biggest opportunity you join in 2026!

🏆 Win from ₹50 Lakh+ Prize Pool
🎓 Open to All Students
🤖 Explore AI & Innovation
📜 Earn Recognition
💯 Registration is FREE

Imagine adding a national innovation challenge to your resume before graduation.

⚡ Registration Closes Soon

𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘 👇:-

https://pdlink.in/4fFWOqX

Share with your friends, classmates, teammates & colleagues who shouldn't miss this opportunity.

Data Analyst Interview Preparation Roadmap ✅

Technical skills to revise

- SQL
Write queries from scratch.
Practice joins, group by, subqueries.
Handle duplicates and NULLs.
Window functions basics.

- Excel
Pivot tables without help.
XLOOKUP and IF confidently.
Data cleaning steps.

- Power BI or Tableau
Explain data model.
Write basic DAX.
Explain one dashboard end to end.

- Statistics
Mean vs median.
Standard deviation meaning.
Correlation vs causation.

- Python. If required
Pandas basics.
Groupby and filtering.

Interview question types

- SQL questions
Top N per group.
Running totals.
Duplicate records.
Date based queries.

- Business case questions
Why did sales drop.
Which metric matters most and why.

- Dashboard questions
Explain one KPI.
How users will use this report.

- Project questions
Data source.
Cleaning logic.
Key insight.
Business action.

Resume preparation
- Must have Tools section.
- One strong project.
- Metrics driven points.
Example: Improved reporting time by 30 percent using Power BI.

Mock interviews
- Practice explaining out loud.
- Time your answers.
- Use real datasets.

Daily prep plan
1 SQL problem.
1 dashboard review.
10 interview questions.

- Common mistakes
Memorizing queries.
No project explanation.
Weak business reasoning.

- Final task
- Prepare one project story.
- Prepare one SQL solution on paper.
- Prepare one business metric explanation.

Double Tap ♥️ For More

Here are some tricky🧩 SQL interview questions!

1. Find the second-highest salary in a table without using LIMIT or TOP.

2. Write a SQL query to find all employees who earn more than their managers.

3. Find the duplicate rows in a table without using GROUP BY.

4. Write a SQL query to find the top 10% of earners in a table.

5. Find the cumulative sum of a column in a table.

6. Write a SQL query to find all employees who have never taken a leave.

7. Find the difference between the current row and the next row in a table.

8. Write a SQL query to find all departments with more than one employee.

9. Find the maximum value of a column for each group without using GROUP BY.

10. Write a SQL query to find all employees who have taken more than 3 leaves in a month.

These questions are designed to test your SQL skills, including your ability to write efficient queries, think creatively, and solve complex problems.

Here are the answers to these questions:

1. SELECT MAX(salary) FROM table WHERE salary NOT IN (SELECT MAX(salary) FROM table)

2. SELECT e1.* FROM employees e1 JOIN employees e2 ON e1.manager_id = (link unavailable) WHERE e1.salary > e2.salary

3. SELECT * FROM table WHERE rowid IN (SELECT rowid FROM table GROUP BY column HAVING COUNT(*) > 1)

4. SELECT * FROM table WHERE salary > (SELECT PERCENTILE_CONT(0.9) WITHIN GROUP (ORDER BY salary) FROM table)

5. SELECT column, SUM(column) OVER (ORDER BY rowid) FROM table

6. SELECT * FROM employees WHERE id NOT IN (SELECT employee_id FROM leaves)

7. SELECT *, column - LEAD(column) OVER (ORDER BY rowid) FROM table

8. SELECT department FROM employees GROUP BY department HAVING COUNT(*) > 1

9. SELECT MAX(column) FROM table WHERE column NOT IN (SELECT MAX(column) FROM table GROUP BY group_column)

Here you can find essential SQL Interview Resources👇
https://t.me/mysqldata

Like this post if you need more 👍❤️

Hope it helps :)

𝗙𝘂𝗹𝗹 𝗦𝘁𝗮𝗰𝗸 & 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 🎓

Looking to land a high-paying tech job in 2026? This is your chance to learn the most in-demand skills 🔥

✅ 60+ Hiring Drives Monthly
👉100% Placement Assistance
💫500+ Hiring Partners
💼 Avg. Package: ₹7.2 LPA
💰Highest: ₹41 LPA

👨‍💻Fullstack :- https://pdlink.in/4fdWxJB

📈 DataAnalytics :- https://pdlink.in/42WOE5H

📌 Start Learning Today & Upgrade Your Career!

🚀 Most Asked Pandas Interview Questions 🐼

🧠 1. Difference between loc[] and iloc[]

👉 loc[] is label-based indexing, while iloc[] is position-based indexing.

🧠 2. What does isna() do?

👉 It detects missing values and returns a boolean (True/False) mask.

🧠 3. Default axis in drop()

👉 Default is axis=0, which means rows are dropped.

🧠 4. What does groupby() return?

👉 It returns a GroupBy object, not a DataFrame directly.

🧠 5. What happens if fillna() is not assigned?

👉 It returns a new DataFrame; original data remains unchanged.

React for more interview questions ♥️

✅ Basic SQL Queries Interview Questions With Answers 🖥️

1. What does SELECT do
– SELECT fetches data from a table
– You choose columns you want to see
Example: SELECT name, salary FROM employees;

2. What does FROM do
– FROM tells SQL where data lives
– It specifies the table name
Example: SELECT * FROM customers;

3. What is WHERE clause
– WHERE filters rows
– It runs before aggregation
Example: SELECT * FROM orders WHERE status = 'Delivered';

4. Difference between WHERE and HAVING
– WHERE filters rows before GROUP BY
– HAVING filters groups after aggregation
Example: WHERE filters orders, HAVING filters total_sales

5. How do you sort data
– Use ORDER BY
– Default order is ASC
Example: SELECT * FROM employees ORDER BY salary DESC;

6. How do you sort by multiple columns
– SQL sorts left to right
Example: SELECT * FROM students ORDER BY class ASC, marks DESC;

7. What is LIMIT
– LIMIT restricts number of rows returned
– Useful for top N queries
Example: SELECT * FROM products LIMIT 5;

8. What is OFFSET
– OFFSET skips rows
– Used with LIMIT for pagination
Example: SELECT * FROM products LIMIT 5 OFFSET 10;

9. How do you filter on multiple conditions
– Use AND, OR
Example: SELECT * FROM users WHERE city = 'Delhi' AND age > 25;

10. Difference between AND and OR
– AND needs all conditions true
– OR needs one condition true

Quick interview advice
• Always say execution order: FROM → WHERE → SELECT → ORDER BY → LIMIT
• Write clean examples
• Speak logic first, syntax next¹

Double Tap ❤️ For More

🎓𝟱 𝗙𝗥𝗘𝗘 𝗜𝗕𝗠 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝟮𝟬𝟮𝟲 🚀

IBM SkillsBuild offers FREE online courses, digital credentials, and career-focused learning paths to help students and professionals become job-ready. 🌟

✔️ 100% Free Learning Resources
✔️ Industry-Recognized Digital Badges
✔️ Self-Paced Learning
✔️ Hands-On Projects & Assessments
✔️ Resume & LinkedIn Profile Enhancement

🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:

https://pdlink.in/4vPMTDO

⏳ Start Learning Today & Boost Your Career!

Data Analyst Interview Questions with Answers: Part-1 🧠

1️⃣ What is the role of a data analyst?
A data analyst collects, processes, and analyzes data to help businesses make data-driven decisions. They use tools like SQL, Excel, and visualization software (Power BI, Tableau) to identify trends, patterns, and insights.

2️⃣ Difference between data analyst and data scientist
• Data Analyst: Focuses on descriptive analysis, reporting, and visualization using structured data.
• Data Scientist: Works on predictive modeling, machine learning, and advanced statistics using both structured and unstructured data.

3️⃣ What are the steps in the data analysis process?
1. Define the problem
2. Collect data
3. Clean and preprocess data
4. Analyze data
5. Visualize and interpret results
6. Communicate insights to stakeholders

4️⃣ What is data cleaning and why is it important?
Data cleaning is the process of fixing or removing incorrect, incomplete, or duplicate data. Clean data ensures accurate analysis, improves model performance, and reduces misleading insights.

5️⃣ Explain types of data: structured vs unstructured
• Structured: Organized data (e.g., tables in SQL, Excel).
• Unstructured: Text, images, audio, video — data that doesn’t fit neatly into tables.

6️⃣ What are primary and foreign keys in databases?
• Primary key: Unique identifier for a table row (e.g., Employee_ID).
• Foreign key: A reference to the primary key in another table to establish a relationship.

7️⃣ Explain normalization and denormalization
• Normalization: Organizing data to reduce redundancy and improve integrity (usually via multiple related tables).
• Denormalization: Combining tables for performance gains, often in reporting or analytics.

8️⃣ What is a JOIN in SQL? Types of joins?
A JOIN combines rows from two or more tables based on related columns.
Types:
• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• FULL OUTER JOIN
• CROSS JOIN

9️⃣ Difference between INNER JOIN and LEFT JOIN
• INNER JOIN: Returns only matching rows in both tables.
• LEFT JOIN: Returns all rows from the left table and matching rows from the right; unmatched right-side values become NULL.

🔟 Write a SQL query to find duplicate rows

SELECT column_name, COUNT(*)  
FROM table_name  
GROUP BY column_name  
HAVING COUNT(*) > 1;

This identifies values that appear more than once in the specified column.

💬 Double Tap ♥️ For Part-2