Data Preparation using Power Query

This sheet represents the data preparation and transformation stage of a sales analysis project using Microsoft Excel and Power Query.

Multiple datasets (from different years such as 2017, 2018, and 2019) were combined into a single unified table using the Append feature in Power Query. The final dataset includes key fields such as Product ID, Date, Quantity, Price, and Revenue.

This step ensures that the data is clean, structured, and ready for analysis. It also demonstrates the ability to handle data integration from multiple sources and prepare it for further analysis and visualization.

Overall, this stage highlights strong skills in data cleaning, data transformation, and data consolidation using Power Query.