corona virus period sales

Determinants

Weak data collected, most of the data was during the Corona phase

The presence of several data that does not have a specific value

Steps:

PowerQuery and the DAX language were used to create equations and display using Power BI

The data was cleaned, collected, converted, and analyzed and presented.

data :

The data consists of the years in which the data was collected, a classification of the products used in cleaning at the levels of Upper Egypt, the Delta, Cairo, and Giza, and the sales value and quantities.

Results:

Through analysis and presentation, these visions are revealed

In the period between 2020 and 2021, there was a decline in the growth of sales and quantities due to the ban period and the lack of trade exchange, as well as the impact of the presence of sufficient stores on the amount of sales. Cairo and Giza were the lowest in sales because they had one store and also the least number of representatives, and the delta was larger than the average sales in the two regions. Others in terms of sales

The month of March witnessed the highest sales, while the month of December witnessed the lowest sales. Also, through the study, it was found that sales on days other than Friday were greater than the average sales.