? Power Query – Filters, Sorting & Splitting

✨ Quick Overview

This lesson focuses on row-level and column-level transformations. Filtering, sorting, and splitting help reduce data size and prepare data for accurate analysis.

? Key Concepts

• Filters reduce rows based on conditions
• Sorting only changes order, not data
• Split Column breaks one column into multiple columns
• All actions are tracked in Applied Steps

? Sample Data Used

// Raw sales data before transformation
OrderID,CustomerName,City,ProductCode,Amount,Status
1,Rahul,Pune,EL-1001,15000,Completed
2,Anita,Mumbai,EL-1002,45000,Completed
3,Ravi,Pune,AC-2001,20000,Pending

? Filters in Power Query

Filters are used to keep only required rows. They reduce dataset size and improve report performance.

↕️ Sorting Data

Sorting arranges data in ascending or descending order. It does not remove rows.

✂️ Split Column

Split Column divides one column into multiple columns using a delimiter (like a hyphen or comma).

? Use Cases

• Filtering city-wise sales (e.g., only Pune)
• Sorting transactions to find the highest value
• Splitting product codes into category and ID