Post #2419

✅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!