📚 Interview Preparation: Excel | SQL | Power BI

[hirenpatel1903]

📚 Interview Preparation: Excel | SQL | Power BI

A comprehensive collection of interview questions focused on core technical skills:
Excel, SQL, and Power BI — widely used in data analysis, reporting, and business intelligence.

---

📊 Excel Interview Questions

No.	Question
1	What is the difference between a workbook and a worksheet in Excel?
2	How do you use the VLOOKUP function? Give an example.
3	What are dynamic arrays in Excel? How do they work?
4	Explain the use of the IF function in Excel. Can you give an example?
5	How do you use pivot tables in Excel? How do you create one?
6	How do you use conditional formatting to highlight specific values?
7	What is the difference between COUNT and COUNTA functions?
8	How do you protect a worksheet in Excel?
9	Can you explain how INDEX and MATCH functions work together?
10	How would you remove duplicates from a dataset in Excel?
11	What is the purpose of the Data Validation feature in Excel?
12	How do you create a drop-down list in Excel?
13	What is the difference between relative, absolute, and mixed cell references?
14	How do you split text into separate columns using a delimiter in Excel?
15	Explain the purpose of the SUMIFS function. How is it different from SUMIF?

---

🗄️ SQL Interview Questions

No.	Question
1	What is SQL, and why is it important for data management?
2	What is the difference between INNER JOIN and OUTER JOIN?
3	How do you retrieve unique values from a column in SQL?
4	Explain the difference between WHERE and HAVING clauses.
5	What is the purpose of the GROUP BY clause in SQL?
6	How do you create a table in SQL? Can you give an example?
7	What is the purpose of a primary key in a database table?
8	How can you handle duplicate rows in SQL?
9	What is a subquery, and how is it used in SQL?
10	What are the differences between UNION and UNION ALL?
11	How do you find the second highest salary in a table?
12	What is a stored procedure in SQL, and why would you use one?
13	Explain the concept of the COUNT function in SQL.
14	What is normalization, and why is it important in databases?
15	How do you write an SQL query to join three tables?

---

📈 Power BI Interview Questions

No.	Question
1	What is Power BI, and how is it used for data visualization?
2	What is the difference between Power BI Desktop and Power BI Service?
3	How do you create a calculated column in Power BI?
4	What is a relationship in Power BI, and how do you create one?
5	Explain the difference between a measure and a calculated column.
6	How do you apply filters to a report in Power BI?
7	What is DAX, and why is it important in Power BI?
8	How do you handle many-to-many relationships in Power BI?
9	Explain the use of slicers in Power BI reports.
10	How do you publish a Power BI report to the Power BI Service?
11	What is the purpose of the Power Query Editor?
12	How do you refresh data in a Power BI report?

---

📝 How to Use This Repository

✔ Use this list for interview preparation
✔ Practice answering each question
✔ Share with peers or contribute more questions via Pull Request.

🌐 Follow & Subscribe

Stay connected and support us online:

Platform	Link
🐦 Twitter	https://twitter.com/einzigartigetec/
📘 Facebook	https://www.facebook.com/einzigartige/
💼 LinkedIn	https://www.linkedin.com/company/einzigartige/
▶️ YouTube	https://www.youtube.com/@einzigartige_/
🌍 Website	http://einzigartige.in/

---

📊 Live YouTube Statistics

👉 Subscribe here: https://www.youtube.com/@einzigartige_/