E-Commerce Sales Report

This E-commerce Sales Report for 2024 provides a comprehensive overview of a online store's performance, focusing on key metrics such as total sales, discount impact, and average order value. The dashboard meticulously highlights top-selling categories, preferred payment methods, and crucial sales trends over time, offering a clear picture of market dynamics and customer purchasing behavior. It serves as a vital tool for understanding revenue streams and identifying areas for growth.

The development of this report involved a rigorous data pipeline, commencing with initial data cleaning and transformation in Excel, where mixed date formats and inconsistent numerical values were standardized using Power Query. Subsequently, the data was structured and normalized within a MySQL database using SQL, creating dedicated dimension tables for categories, payment methods, and a robust date dimension to enhance analytical capabilities. Finally, Power BI was utilized to connect to this clean, structured data, enabling the creation of the interactive and insightful dashboard presented here.