✅ Excel / Power BI Interview Questions with Answers 🟦

1️⃣ How would you clean messy data in Excel?
⦁ Use TRIM() to remove extra spaces
⦁ Use Text to Columns to split data
⦁ Use Find & Replace to correct errors
⦁ Apply Data Validation to control inputs
⦁ Remove duplicates via Data → Remove Duplicates

2️⃣ What is the difference between Pivot Table and Power Pivot?
⦁ Pivot Table: Used for summarizing data in a single table
⦁ Power Pivot: Can handle large data models with relationships, supports DAX formulas, and works with multiple tables

3️⃣ Explain DAX measures vs calculated columns.
⦁ Measures: Calculated at query time (dynamic), used in visuals
Example: SUM(Sales[Amount])
⦁ Calculated Columns: Computed when data is loaded; becomes a new column in the table
Example: Sales[Profit] = Sales[Revenue] - Sales[Cost]

4️⃣ How to handle missing values in Power BI?
⦁ Use Power Query → Replace Values / Remove Rows
⦁ Fill missing values using Fill Down / Fill Up
⦁ Use IF() or COALESCE() in DAX to substitute missing values

5️⃣ Create a KPI visual comparing actual vs target sales.
⦁ Load data with Actual and Target columns
⦁ Go to Visualizations → KPI
⦁ Set Actual Value as indicator, Target Value as target
⦁ Add a trend axis (e.g., Date) for better analysis

💬 Tap ❤️ for more!