Sales Dashboard

This data analysis project aims to provide insights into the sales performance over three years.

I implemented a ComboBox to streamline navigation, incorporating within it the key metrics:

Quantity, Transactions, Revenue, COGS, and Profit.

The peak year in terms of revenue performance is 2019.

The results highlight Wednesday and Friday as the days with the highest revenue, with Thursday marking

the lowest performance.

Quarter 1 stands out as the quarter with the highest revenue, in contrast to Quarter 3, which exhibits

the lowest performance.

Moreover, I conducted a comparison of revenue between the selected month and the preceding month

to assess whether it witnessed an increase or decrease.

The combined contribution of the top 5 profitable customers accounts for 1.3% of the total revenue.

while 'Rialto,' 'Roseville,' and 'Victorville,' the leading three profitable cities, jointly contribute to 5.2%

of the total revenue.

At the end, I present daily profits, highlighting the most lucrative day for each chosen month.

The aim of this thorough analysis is to offer valuable insights to facilitate informed decision-making and

strategic planning.