Practice File: Data_Import_Power_Query_Practice.xlsx

Raw Data

Student Tasks

1. Import the data.
2. Open Power Query Editor.
3. Promote/identify headers correctly.
4. Remove the duplicate O102 record.
5. Clean unnecessary spaces.
6. Standardize City values.
7. Set appropriate data types.
8. Add a Sales column:

Sales = Quantity × Price

9. Filter the data for Sirsa.
10. Load the transformed data back into Excel.
11. Modify the source data.
12. Use Refresh All.
13. Verify that the updated data appears.

Final Output

Create a professional:

Sales Data Import & Transformation Report

showing the complete process:

Import → Transform → Clean → Load → Refresh